I'm fairly new to MySQL and am getting an error messages like:
ERROR 1064 (42000) at line 5: 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 'id int(14) unsigned NOT NULL auto_increment,
forename varchar(40)
Hugh Sasse [EMAIL PROTECTED] wrote on 13/10/2005 16:27:44:
I'm fairly new to MySQL and am getting an error messages like:
ERROR 1064 (42000) at line 5: 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 'id
On Thu, 13 Oct 2005, [EMAIL PROTECTED] wrote:
Hugh Sasse [EMAIL PROTECTED] wrote on 13/10/2005 16:27:44:
I'm fairly new to MySQL and am getting an error messages like:
ERROR 1064 (42000) at line 5: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL
Hugh Sasse [EMAIL PROTECTED] wrote on 10/13/2005 11:27:44 AM:
I'm fairly new to MySQL and am getting an error messages like:
ERROR 1064 (42000) at line 5: 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
Hugh,
Agreed that the MySQL error reporter is primitive, and that 'lint for
MySQL' would be a smash hit, but if you look up error 1064 you'll find
it is a naming error, two of which are visible in your error
report--column names enclosed in double quotes.
PB
http://www.artfulsoftware.com
On Thu, 13 Oct 2005, [EMAIL PROTECTED] wrote:
MySQL does not normally use (double quotes) as name identifiers, it
uses ` `(backticks). Change all of your to ` to make your syntax
correct. That would mean that part of your original statement will look
like
Thank you.
In this case
On Thu, 13 Oct 2005, Peter Brawley wrote:
Hugh,
Agreed that the MySQL error reporter is primitive, and that 'lint for MySQL'
If I were familiar with the code base I'd happy send patches, but I
was hoping improve diagnostics might get nudged up somebody's
list by raising it.
would be a