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

[Marc Delisle]

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