15 Jul
2002
15 Jul
'02
10:59 a.m.
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(a)orbis-terrarum.net
Home Page : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ# : 30269588 or 41961639