Top "Mysql-error-1064" questions

1064 means "syntax error" in MySQL.

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO

I've looked through all the other StackOverflow (and google) posts with the same problem, but none seemed to address my …

php sql mysql pdo mysql-error-1064
Warning about SSL connection when connecting to MySQL database

With the two classes below, I've tried connect to a MySQL database. However, I always get this error: Wed Dec 09 22:46:52 …

java ssl database-connection mysql-error-1064
How can I fix MySQL error #1064?

When issuing a command to MySQL, I'm getting error #1064 "syntax error". What does it mean? How can I fix it?

mysql parsing syntax syntax-error mysql-error-1064
How to grant all privileges to root user in MySQL 8.0

Tried mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; Getting ERROR 1064 (42000): You …

mysql mysql-error-1064 mysql-8.0
How to delete from multiple tables in MySQL?

I am trying to delete from a few tables at once. I've done a bit of research, and came up …

mysql sql mysql-error-1064 sql-delete
mysql is not recognised as an internal or external command,operable program or batch

I had set the MySQL path, but still getting the same error. Please let me know whether I followed the …

mysql mysql-error-1064
MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

I have the Stored procedure like this: CREATE PROCEDURE ProG() BEGIN SELECT * FROM `hs_hr_employee_leave_quota`; END But …

mysql mysql-error-1064
MySql Inner Join with WHERE clause

Here is my code: SELECT table1.f_id FROM table1 WHERE table1.f_com_id = '430' AND table1.f_…

mysql sql where-clause mysql-error-1064
Check for database connection, otherwise display message

I would like to check if the website can connect to mySQL. If not, I would like to display an …

php mysql mysql-error-1064
Declaring and using MySQL varchar variables

I'm trying to do some simple manipulations with variables in MySQL 5.0 but I can't quite get it to work. I've …

sql mysql mysql-error-1064