SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE `books` ( id INT AUTO_INCREMENT NOT NULL, `title` VARCHAR(60) NOT NULL, `author` VARCHAR(60) NOT NULL, UNIQUE KEY `unique_book` (`title`, `author`), PRIMARY KEY(id) ); INSERT INTO `books` (`title`, `author`) VALUE ('My Book', 'The Author'); SELECT * FROM `books`; INSERT INTO `books` (`title`, `author`) VALUE ('My Book', 'The Author'); INSERT INTO `books` (`title`, `author`) VALUE ('My Another Book', 'The Author'); SELECT * FROM `books`;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear