5 Jul
2002
5 Jul
'02
4:46 a.m.
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
15 Jul
15 Jul
8:44 a.m.
Loïc wrote:
Hi List!
Olivier wrote:
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
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
e
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
8103
days inactive
8113
days old
2 comments
3 participants
participants (3)
-
Loïc -
Marc Delisle -
Robin Johnson