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. 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
______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif
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
On Mon, 15 Jul 2002, Marc Delisle wrote:
phpMyAdmin did not check for a dot in db, table or column name.
It will soon ;-)
MySQL gave an error when creating the db, table. MySQL accepted to create the column, and to delete it.
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.
Actually, my new parser can handle it really easily.
The dot in the name is known as a qualifier, and my parser will reject qualifiers in invalid locations.
eg CREATE foo (bar.bad double) Produces a table: CREATE TABLE foo ( bad double default NULL ) TYPE=MyISAM;
The 'bar' part is totally ogne.
-
Loïc -
Marc Delisle -
Robin Johnson