Danabalou Mohanassoundarame a écrit :
Hello/Bonjour,
I got a problem to create this table in mysql-5.0.18
any idea
CREATE TABLE issues( borrowernumber int( 11 ) NOT NULL default '0', itemnumber int( 11 ) NOT NULL default '0', date_due date default NULL , branchcode char( 4 ) default NULL , issuingbranch char( 18 ) default NULL , returndate date default NULL , lastreneweddate date default NULL , RETURN char( 4 ) default NULL , renewals tinyint( 4 ) default NULL , timestamptimestamp( 14 ) NOT NULL , KEY issuesborridx( borrowernumber ) , KEY issuesitemidx( itemnumber ) , KEY bordate( borrowernumber, timestamp ) ) TYPE = MYISAM ;
*MySQL a répondu:*Documentation <http://dev.mysql.com/doc/refman/5.0/en/error-returns.html>
| #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'return char(4) default NULL, renewals tinyint(4) default NULL, timestamp t' at line 9
cordialement Return seems to be a reserved word for mysql5.0 Try with quoting this word. 'return' or "return" or `return`
HTH. -- Henri-Damien LAURENT