Top "Mysql-error-1064" questions

1064 means "syntax error" in MySQL.

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
Using INSERT INTO SELECT when table structures do not match in MySQL

I'm familiar with the following use of the command: INSERT INTO mytable SELECT * FROM other_table This works fine when …

mysql sql insert mysql-error-1064
MySQL 8 won't start after "Data dictionary upgrading" in log file

I'm running MySQL 8 and it's suddenly just decided to shutdown and not come back when I try to start it …

mysql mysql-error-1064 mysql-8.0
MySQL - Using UNION with LIMIT

i noticed that (SELECT title, relavency, 'search1' as source FROM search1 ORDER BY relavency DESC LIMIT 10) UNION (SELECT title, …

sql mysql mysql-error-1064
Update multiple rows in a table based on result from subquery

I have the following query: SELECT stat.mcq_id, ROUND( stat.total_score / stat.num_taken, 2 ) AS avg_score FROM ( …

mysql group-by mysql-error-1064