15 Jul
2002
15 Jul
'02
7:44 a.m.
Loïc wrote:
Hi List!
Olivier wrote:
try to delete the table "www.nukeland"
This is a known MySQL problem: dot is an invalid character in db/table/column name but MySQL doesn't check for it while creating db/table/column.
I just tried with phpMyAdmin 2.3.0-rc3, and MySQL 3.23.38.
phpMyAdmin did not check for a dot in db, table or column name.
MySQL gave an error when creating the db, table. MySQL accepted to create the column, and to delete it.
Marc
BTW it can't do anything with such a db/table/colum.
PMA already checks for such invalid characters as soon as you create db/table/column with PMA forms. But it doesn't if you run a SQL script and I'm afraid it would be really too hard to code it.
Loïc
e