From: "rik onckelinx" <[EMAIL PROTECTED]> > where "FULLTEXT" was causing the error. My workaround was renaming (in the sql > create table scirpt) > > fulltext -> ful_text > option -> optio_
The easiest solution to preventing these errors from popping up from time to time is to put backticks (`) around names of databases, tables and columns... INSERT INTO `fulltext` SET (...) ; SELECT * FROM `insert`.`from` WHERE (...) PHPMyAdmin uses this also. You can tell mysqldump to include these quotes with the option -Q : --quote-names, -Q Quote database, table, and column names within ``' characters. If the server SQL mode includes the ANSI_QUOTES option, names are quoted within `"' characters. As of MySQL 4.1.1, --quote-names is on by default, but can be disabled with --skip-quote-names. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
