SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE IF NOT EXISTS `users` ( `id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT, `firstname` varchar(200) NOT NULL, `lastname` varchar(200) NOT NULL, `age` int unsigned NOT NULL ) DEFAULT CHARSET=utf8; INSERT INTO `users` (`firstname`, `lastname`, `age`) VALUES ('ada', 'lovelace', 36), ('grace', 'hopper', 85), ('nicole-Reine', 'lepaute', 65), ('maria', 'mitchell', 70); SELECT * FROM `users`; SELECT `firstname` FROM `users`; select `firstname` , `lastname` from `users` limit 2; select * from `users` where age > 65; select * from `users` where ( age > 60 and age < 80 ); /*toutes les colonnes classées par age en ordre croissant*/ select * from `users` order by age; /*toutes les colonnes classées par age en ordre décroissant*/ select * from `users` order by -age ; /*tout les noms commençant par la lettre l*/ select `lastname` from `users` where `lastname` like 'l%'; /*tout les prenoms qui ne contiennent pas la lettre a*/ select `firstname` from `users` where `firstname` not like '%a%'; /*10-ajouter meg whitman 55 ans à la table users*/ INSERT INTO `users` (`firstname`, `lastname`, `age`) VALUES ('meg', 'whitman', 55); SELECT * FROM `users`; /*10-modifier l'age de meg whitman à 65*/ update `users` set age = 65 where firstname = 'meg'; SELECT * FROM `users`; /*11-toute les colonne du user meg whitman*/ select * from `users` where firstname = 'meg';
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear