From seb at nexedi.com  Wed Sep  1 17:42:47 2004
From: seb at nexedi.com (Sebastien Robin)
Date: Wed, 01 Sep 2004 15:42:47 -0000
Subject: [Erp5-dev] again comma with mysql >= 4.0.20 
Message-ID: <200409011743.50202.seb@nexedi.com>

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