Re: Incorrect column name

2005-08-29 Thread Scott Noyes
> mysql> create table prova (`Termination ` int); > ERROR 1166: Incorrect column name 'Termination ' The manual says: "Database, table, and column names should not end with space characters." http://dev.mysql.com/doc/mysql/en/legal-names.html -- MySQL General Mailing

Re: Incorrect column name

2005-08-29 Thread Michael Stassen
inyint(3) unsigned NOT NULL default '0', ... ... ) TYPE=MyISAM 1 row in set (0.01 sec) mysql> The field `Termination ` cause me some trouble: If i try to recreate from dump (mysqldump from 4.0) the table 'Dsmaccnt', on another server (version 4.1), i've got this error

Incorrect column name

2005-08-29 Thread Francesco Dalla Ca'
ult '0', ... ... ) TYPE=MyISAM 1 row in set (0.01 sec) mysql> The field `Termination ` cause me some trouble: If i try to recreate from dump (mysqldump from 4.0) the table 'Dsmaccnt', on another server (version 4.1), i've got this error: ERROR 1166: Incorrect column n