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), INSERT INTO `users` (`firstname`, `lastname`, `age`) VALUES ('meg', 'whitman', 55);