Howdy, Recently I was working with a contractor on a schema for a project. I'm terribly embarrassed to admit that one of the tables we came up with got named "order" since it keeps track of an order number assigned to a shipment by a vendor. I bet you know what's coming next. Somehow, mysql didn't complain when he created the table, but I quickly realized our mistake when every query, including RENAME and DROP queries came up as invalid because of the reserved word ORDER.
I figure that I'll have to dump all of the other tables, create a new db, reload all the tables into the new db and drop the old db to get rid of that "order" table, then re-create it under a new name (ship_order, maybe). I was just hoping someone on the list might have another idea or some way to delimit the name. To be honest, I'm mostly curious at this point. It's not really that much work to fix this (unless dropping the db proves to not work). Here's a thought: Would renaming the MYD, MYI, and frm files do the job? I'll try that now. Thanks, Matt Kenigson --------------------------------------------------------------------- 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
