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); SHOW COLUMNS FROM users; SELECT FIRSTNAME FROM users; SELECT FIRSTNAME, LASTNAME FROM users LIMIT 2; SELECT*FROM users where AGE > 65; SELECT*FROM users where AGE BETWEEN 60 AND 80; SELECT*FROM users ORDER BY AGE ; SELECT*FROM users ORDER BY AGE DESC; SELECT*FROM users WHERE LASTNAME LIKE 'L%'; SELECT*FROM users WHERE FIRSTNAME NOT LIKE '%A%'; INSERT INTO `users` (`firstname`, `lastname`, `age`) VALUES ('MEG' , 'WHITEMEN' , 55); update users SET AGE=65 WHERE id = 5; delete from users where id = 5;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear