The Ultimate Guide to High Availability with MariaDB

requete mysql ne fonctionne plus suite au passage en Mariadb10

You are viewing an old version of this question. View the current version here.

Bonjour, Je suis passé de Mysql à Mariadb10, et je rencontre un problème depuis avec cette requete qui fonctionnait très bien avant:

sprintf(buf2,"INSERT INTO arrosage.log_hist VALUES ('','%s', '%d', NOW())",hum1Str,vanne,date);

J'ai a présent l'erreur suivante: Error: 83 = Incorrect integer value: '' for column `arrosage`.`log_hist`.`id` at row 1.

Table:

CREATE TABLE `log_hist` ( `id` int(255) NOT NULL, `humidite1` float NOT NULL, `vanne` int(10) NOT NULL, `date` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

ALTER TABLE `log_hist` ADD PRIMARY KEY (`id`), ADD KEY `id` (`id`);

ALTER TABLE `log_hist` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101; COMMIT;

Quelque pourrait m'aider ? merci d'avance Christophe

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.