Vous n'êtes pas identifié(e).
L'icône rouge permet de télécharger chaque page du wiki visitée au format PDF et la grise au format ODT →
Ceci est une ancienne révision du document !
//nath_test.sql CREATE DATABASE IF NOT EXISTS `nath_test`; USE `nath_test`; CREATE TABLE IF NOT EXISTS `users` ( `id` INT(11) NOT NULL, `name` VARCHAR(250) NOT NULL, `surname` VARCHAR(250) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=UTF8; INSERT INTO `users` (`id`, `name`, `surname`) VALUES (1, 'Jean-Marc', 'Joseph'), (2, 'Nathalie', 'D urso'), (3, 'Lionel', 'Joseph'), (4, 'Samuel', 'D urso'), (5, 'Helene-Fleur', 'D urso'); ALTER TABLE `users` ADD PRIMARY KEY (`id`); ALTER TABLE `users` MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=28; CREATE TABLE IF NOT EXISTS `tree_country_state_city` ( `id` INT(11) NOT NULL, `name` VARCHAR(250) NOT NULL, `parent_id` INT(11) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=UTF8; INSERT INTO `tree_country_state_city` (`id`, `name`, `parent_id`) VALUES (1, 'USA', 0), (2, 'Canada', 0), (3, 'Australia', 0), (4, 'New York', 1), (5, 'Alabama', 1), (6, 'California', 1), (7, 'Ontario', 2), (8, 'British Columbia', 2), (9, 'New South Wales', 3), (10, 'Queensland', 3), (11, 'New York city', 4), (12, 'Buffalo', 4), (13, 'Albany', 4), (14, 'Birmingham', 5), (15, 'Montgomery', 5), (16, 'Huntsville', 5), (17, 'Los Angeles', 6), (18, 'San Francisco', 6), (19, 'San Diego', 6), (20, 'Toronto', 7), (21, 'Ottawa', 7), (22, 'Vancouver', 8), (23, 'Victoria', 8), (24, 'Sydney', 9), (25, 'Newcastle', 9), (26, 'City of Brisbane', 10), (27, 'Gold Coast', 10); ALTER TABLE `tree_country_state_city` ADD PRIMARY KEY (`id`); ALTER TABLE `tree_country_state_city` MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=28;
mysql -u root -p < ~/user/Test/nath_test.sql
└───public |_ MysqlSingleton.php |_ gestionnairePDO.php |_ data_users.php |_ data_tree.php |_ index.php