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
> 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 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
Thank you, I'm off there now.