RobinNixon
12 lines
342 B
SQL
12 lines
342 B
SQL
CREATE TABLE customers (
|
|
name VARCHAR(128),
|
|
isbn VARCHAR(13),
|
|
PRIMARY KEY (isbn)) ENGINE InnoDB;
|
|
INSERT INTO customers(name,isbn)
|
|
VALUES('Joe Bloggs','9780099533474');
|
|
INSERT INTO customers(name,isbn)
|
|
VALUES('Mary Smith','9780582506206');
|
|
INSERT INTO customers(name,isbn)
|
|
VALUES('Jack Wilson','9780517123201');
|
|
SELECT * FROM customers;
|