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
