I have a database on a mysql server (version 4.0.20-max) with this table:
mysql> show create table Dsmaccnt\G
*************************** 1. row ***************************
Table: Dsmaccnt
Create Table: CREATE TABLE `Dsmaccnt` (
...
...
`Termination ` tinyint(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:
ERROR 1166: Incorrect column name 'Termination '
On the same server (4.0.20-max) if i try to create a dummy table with
same blank-added field i've got same error:
mysql> create table prova (`Termination ` int);
ERROR 1166: Incorrect column name 'Termination '
mysql>
How is possible that i have this table with this field? (The database
was created by others admin, not by me).
There are some particular SQL mode that permit this?
Thank in advance. Francesco.
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
