SQLize Online / PHPize Online  /  SQLtest Online

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';