Discussion:
[Erp5-dev] again comma with mysql >= 4.0.20
Sebastien Robin
2004-09-01 15:42:47 UTC
Permalink
I tell you again this problem, just to remind things :-) :

According to ISO/IEC 9075-2:2003, trailing commas are not allowed when you
create a new table :

<table element list> ::=
<left paren> <table element> [ { <comma> <table element> }... ] <right
paren>


So all last version of MySQL will give you an error if you do :

create table test (
myfield tinyint(2),
);

The right syntax is :
create table test (
myfield tinyint(2)
);

Please see http://bugs.mysql.com/bug.php?id=3481 if you want more
information.

Sebastien.
--
Sebastien Robin, Nexedi Technical Director
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.com
ERP5: Free / Open Source ERP Software for small and medium companies
http://www.erp5.org
Storever: OpenBrick, WiFi infrastructure, notebooks and servers
http://www.storever.com
Loading...