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

[Robin Johnson]

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.

-- 
Robin Hugh Johnson
E-Mail     : robbat2 at orbis-terrarum.net
Home Page  : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ#       : 30269588 or 41961639