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 |