CREATE TABLE IF NOT EXISTS `utilisateur` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `nom` varchar(200) NOT NULL, `prenom` varchar(200) NOT NULL, `email` varchar(80) DEFAULT NULL, `tel` int(12) DEFAULT NULL, `date_nai` date NOT NULL, `mot_passe` varchar(100) NOT NULL, `mot_passe_conf` varchar(100) NOT NULL, PRIMARY KEY (`id`), ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0
ALTER TABLE `utilisateur` ADD `col_1` VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL