Top "Mysql-error-1064" questions

How to increment a field in MySql using "ON DUPLICATE KEY UPDATE" when inserting multiple rows?

How to increment a field in MySql using "ON DUPLICATE KEY UPDATE" when inserting multiple rows? For one row: INSERT …

mysql sql mysql-error-1064

'<!-- PMA-SQL-ERROR --> when importing db

I'm trying to import my database into a new one however I get the following error: 1064 - You have an …

phpmyadmin mysql-error-1064

MySQL replication Error 'You cannot 'ALTER' a log table if logging is enabled' on query

MySQL replication got broken with the last error being Last_Errno: 1580 Last_Error: Error 'You cannot 'ALTER' a log table …

mysql replication mysql-error-1064 database-replication

Using IF() With ON DUPLICATE KEY UPDATE in MySQL

I have a PHP script which runs a MySQL query. $query = "INSERT INTO table (col1, col2) VALUES('$val1', …

mysql mysql-error-1064

MySQL Server 8.0.14 failed to Install on Windows 10

I have already installed Visual Studio 2015 x64 Redistributable but still the server failed to install. What could be the reason?

mysql mysql-workbench mysql-error-1064

MySQL - Trouble with creating user defined function (UDF)

I'm trying to create this function: CREATE FUNCTION remove_non_alphanum (prm_strInput varchar(3000)) RETURNS VARCHAR(3000) DETERMINISTIC BEGIN DECLARE i …

mysql mysql-error-1064 user-defined-functions dbvisualizer