List:General Discussion« Previous MessageNext Message »
From:Hugh Sasse Date:October 13 2005 4:02pm
Subject:Re: MySQL 4.1.13 lint?
View as plain text  
On Thu, 13 Oct 2005, SGreen@stripped 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 "line 2" did not refer to the position in the script but to 

but line 5 was at least line 7 in the script, and at most line 4 in
the statement.
> the line within the statement. Your line 1 was something like
> 
> CREATE TABLE sometablename (
> 
> which made your first column definition (the id column) appear on line 2. 
> Make better sense?

Yes. Thank you.
> 
> For more details on ` vs. "  please read 
> http://dev.mysql.com/doc/refman/4.1/en/legal-names.html
> 
Thank you, I'm off there now.
        Hugh
Thread
MySQL 4.1.13 lint?Hugh Sasse13 Oct
  • Re: MySQL 4.1.13 lint?Alec.Cawley13 Oct
    • Re: MySQL 4.1.13 lint?Hugh Sasse13 Oct
  • Re: MySQL 4.1.13 lint?SGreen13 Oct
    • Re: MySQL 4.1.13 lint?Hugh Sasse13 Oct
  • Re: MySQL 4.1.13 lint?Peter Brawley13 Oct
    • Re: MySQL 4.1.13 lint?Hugh Sasse13 Oct