Erreur mysql
DemonZ
-
DemonZ -
DemonZ -
Bonjour,
CREATE TABLE 'test-monaie'.'monnaie' (
'id' SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
'pays' enum( "Canada" ) default "Canada",
'denomination' enum( "1 cent", "3 cents", "5 cents", "10 cents", "20 cents", "25 cents", "50 cents", "1 dollar", "2 dollars" ) NOT NULL,
'figure' enum( "Victoria", "Edward VII", "George V", "George VI", "Elizabeth II" ) NOT NULL,
'annee' year,
'condition' enum( "AG-3","G-4","G-6","VG-8","VG-10","F-12","F-15","VF-20","VF-30","EF-40","EF-45","AU-50","AU-55","MS-60","MS-62","MS-63","MS-64","MS-65","MS-66","PL-65","PL-66","PL-67","PL-68","SP-65","SP-66","PR-65","PR-67" ) Not NUll,
'variete' Tinytext,
'description' Tinytext,
'metal' Tinytext,
'prixachat' numeric(10,2),
'prixvente' Numeric(10,2),
'commentaire' Tinytext,
'emplacement' Tinytext,
);
J'obtiens une erreur de syntaxe 1064 à la ligne 15
pouvez-vous m'aider?
CREATE TABLE 'test-monaie'.'monnaie' (
'id' SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
'pays' enum( "Canada" ) default "Canada",
'denomination' enum( "1 cent", "3 cents", "5 cents", "10 cents", "20 cents", "25 cents", "50 cents", "1 dollar", "2 dollars" ) NOT NULL,
'figure' enum( "Victoria", "Edward VII", "George V", "George VI", "Elizabeth II" ) NOT NULL,
'annee' year,
'condition' enum( "AG-3","G-4","G-6","VG-8","VG-10","F-12","F-15","VF-20","VF-30","EF-40","EF-45","AU-50","AU-55","MS-60","MS-62","MS-63","MS-64","MS-65","MS-66","PL-65","PL-66","PL-67","PL-68","SP-65","SP-66","PR-65","PR-67" ) Not NUll,
'variete' Tinytext,
'description' Tinytext,
'metal' Tinytext,
'prixachat' numeric(10,2),
'prixvente' Numeric(10,2),
'commentaire' Tinytext,
'emplacement' Tinytext,
);
J'obtiens une erreur de syntaxe 1064 à la ligne 15
pouvez-vous m'aider?
A voir également:
- Erreur mysql
- Mysql community server - Télécharger - Bases de données
- Erreur 0x80070643 - Accueil - Windows
- J'aime par erreur facebook notification - Forum Facebook
- Code erreur f3500-31 ✓ - Forum Bbox Bouygues
- Java code erreur 1603 ✓ - Forum Windows