Re: [Phpmyadmin-devel] Re: table name with "." / pma demo

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.