1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Error executing: START TRANSACTION;
INSERT into ahiweb.utilisateur VALUES ('955', '55', '117', 'Tata', 'Titi', 'toto', 'toto', '2', '1', 'toto@gmail.com', '1', '0656565656', '2012-01-02 00:00:00', '2012-01-02 00:00:00', '', '2012-01-02 00:00:00', '2012-01-02 00:00:00', '0', '0', '0', '0', '0' );
INSERT into ahiweb.utilisateur VALUES ('956', '55', '117', 'Tutu', 'Titi', 'toto', 'toto', '2', '1', 'toto@gmail.com', '1', '0656565656', '2012-01-02 00:00:00', '2012-01-02 00:00:00', '', '2012-01-02 00:00:00', '2012-01-02 00:00:00', '0', '0', '0', '0', '0' );
CREATE TABLE `ahiweb`.`tabletest` (
`idtabletest` INT NOT NULL AUTO_INCREMENT COMMENT '',
`nomtabletest` VARCHAR(45) NULL COMMENT '',
`numerotabletest` INT NULL COMMENT '',
`villetabletest` INT(10) UNSIGNED NULL COMMENT '',
PRIMARY KEY (`idtabletest`) COMMENT '',
INDEX `FKTest_idx` (`villetabletest` ASC) COMMENT '',
CONSTRAINT `FKTest`
FOREIGN KEY (`villetabletest`)
REFERENCES `ahiweb`.`adr` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION);
. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'INSERT into ahiweb.utilisateur VALUES ('955', '55', '117', 'Tata', 'Titi', 'toto' at line 3 |
Partager