Discussion :

[biloute73]

CREATE TABLE `clients` (

`idclient` int( 11 ) NOT NULL AUTO_INCREMENT ,
`referenceproduit` int( 11 ) NOT NULL default '0',
`nomproduit` varchar( 100 ) NOT NULL default '',
`statut` varchar( 100 ) NOT NULL default '',
`nomclient` varchar( 48 ) NOT NULL default '',
`prenom` varchar( 48 ) NOT NULL default '',
`adresse1` varchar( 250 ) NOT NULL default '',
`adresse2` varchar( 250 ) NOT NULL default '',
`code` int( 11 ) NOT NULL default '0',
`ville` varchar( 48 ) NOT NULL default '',
`pays` varchar( 48 ) NOT NULL default '',
`telephone` int( 11 ) NOT NULL default '0',
`telecopie` int( 11 ) NOT NULL default '0',
`mobile` int( 11 ) NOT NULL default '0',
`mail` varchar( 100 ) NOT NULL default '',
`residence` varchar( 100 ) NOT NULL default '',
`dates` varchar( 48 ) NOT NULL default '0000-00-00',
`contrat` varchar( 48 ) NOT NULL default 'non envoyé',
`paiement` varchar( 48 ) NOT NULL default 'en attente',
PRIMARY KEY ( `idclient` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =10
MySQL a répondu:

#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 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10' at line

Que faire?

[Maximil ian]

Adapter cette requête à la version du serveur MySQL cible qui doit être plus ancienne.

ENGINE => TYPE
DEFAULT CHARSET => rien (je crois)
...