June 19, 2013

Post: MySQL Error Message Nonsenses

… syntax error gives you information about tokens near by but little details: mysql> select * from user oder by pwd; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL

Comment: Userstats patches with information schema support

… the unquoted table name mysql> use information_schema; Database changed mysql> select count(*) from table_statistics\G ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL