> mysql> create table ABC (col1 varchar(10)); > Query OK, 0 rows affected (0.03 sec) > > mysql> show tables; > +------------------+ > | Tables_in_userdb | > +------------------+ > | abc | > +------------------+ > 1 row in set (0.00 sec) > > mysql> > > NOTE THE FACT THAT THE TABLE IS created in LOWER case!
Are you using MySQL on Windows? If so, please read this: Case-insensitive names Filenames are not case sensitive on Windows, so MySQL database and table names are also not case sensitive on Windows. The only restriction is that database and table names must be specified using the same case throughout a given statement. See Section 9.2.2, "Identifier Case Sensitivity". ( http://dev.mysql.com/doc/mysql/en/windows-vs-unix.html ) Try using lower-case names to avoid facing problems when porting data from windows to *nix-systems. Regards, TomH -- PROSOFT EDV-Loesungen GmbH & Co. KG http://www.proSoft.org St.-Kassians-Platz 6, D-93047 Regensburg [EMAIL PROTECTED] Geschaeftsfuehrer: Axel-Wilhelm Wegmann phone: +49 941 / 78 88 7-121 AG Regensburg HRA 6608 USt.183/68311 cellphone: +49 171 / 40 54 777 -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
