use database; -- On execute TOUT ou RIEN START TRANSACTION; ALTER TABLE `configurations` CHANGE `labNameShort` `labNameShort` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; ALTER TABLE `materiels` CHANGE `numero_laboratoire` `numero_laboratoire` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; COMMIT;