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` ; SELECT `lastname` FROM `users`
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear