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 "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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]