1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| 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.utilisater 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' )
Error executing: INSERT into ahiweb.utilisater 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' )
. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ahiweb.utilisater' doesn't exist
UPDATE ahiweb.utilisateur SET nom = 'AANNDDAANNSSOONN' WHERE id = '284'
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) |