He didn't name a column 'column', he named a table 'column'. This may have seemed reasonable given his application.
In any case, bad idea or not, his point is well-taken. It worked in one place but not another. While column is a reserved word, the directions at http://www.mysql.com/doc/L/e/Legal_names.html clearly state you can use it as a table name anyway, as long as you quote it properly. So, it seems to me, either Tozz did something wrong when he invoked mysqldump, or there's a bug which breaks mysqldump on tables named 'column' (or any other reserved word, I'd guess). I suppose it would be useful to know which version of mysql he is using and how he's calling mysqldump so we can figure out which is the case. Michael On Sun, 17 Mar 2002, Bob Hall wrote: > On Sun, Mar 17, 2002 at 05:31:52AM +0100, Tozz wrote: > > Hey > > > > > Column is a mysql reserved word. > > > Just like desc or asc or tons of others. > > > See here: > > > http://www.mysql.com/doc/R/e/Reserved_words.html > > > Dan > > > > Then, imho I think its stupid that MySQL lets you create tables with > > reserved words, but it stops you from making dumps. Still seems like a bug > > to me. > > Sir, naming a column "column" is generally considered a > bad idea, regardless of the DBMS being used. It's like > naming a variable "variable". > > Bob Hall > -- > All my databases are named "database", "datafile", "datafil", > etc. The tables are all named "table", "tabell", "datasett", > etc. Every one who has to do maintenance on the databases hates > me. It's MySQL's fault for letting me set them up that way. > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
