MySQL delimiter syntax error

by

DELIMITER is not a MySQL command. It’s a command that your MySQL client needs to support. I was running PHPMyAdmin 2.8.2.4, which didn’t support it. When I upgraded to the newest version, which is currently 3.4.9, it worked just fine. Your MySQL version has nothing to do with DELIMITER and whether it’s supported or not.

Also note that some clients might have a bug with DELIMITER being case-sensitive where either only the lowercase delimiter or the uppercase DELIMITER works.

More Related Contents:

  1. SQL split values to multiple rows
  2. How can I fix MySQL error #1064?
  3. Delimiters in MySQL
  4. 1064 error in CREATE TABLE … TYPE=MYISAM
  5. Using an Alias in SQL Calculations
  6. What is the question mark’s significance in MySQL at “WHERE column = ?”?
  7. MySQL: Split comma separated list into multiple rows
  8. How do I modify a MySQL column to allow NULL?
  9. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  10. Get Insert Statement for existing row in MySQL
  11. GRANT with database name wildcard in MySQL?
  12. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  13. i have an error which i dont understand. can you help me? [closed]
  14. mysql error 1364 Field doesn’t have a default values
  15. SQL: What is the default Order By of queries?
  16. How to group by week in MySQL?
  17. Can I use a function for a default value in MySql?
  18. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  19. Mysql order by specific ID values
  20. How do I check if a column is empty or null in MySQL?
  21. MySQL versus PDO [duplicate]
  22. Increment a database field by 1
  23. Row number per group in mysql
  24. is there a mysql function to decode html entities?
  25. MySQL fails on: mysql “ERROR 1524 (HY000): Plugin ‘auth_socket’ is not loaded”
  26. MySQL – SQL_BIG_SELECTS
  27. How to Prevent Connection Timeouts for Large MySQL Imports
  28. How to use MySQL DECIMAL?
  29. How to get the mysql table columns data type?
  30. How to export / dump a MySql table into a text file including the field names (aka headers or column names)

Leave a Comment