Learning PHP and MySQL
Example 07-01 Creating the books and authors tables
CREATE TABLE books ( title_id INT NOT NULL AUTO_INCREMENT,
title VARCHAR (150),
pages INT,
PRIMARY KEY (title_id));
CREATE TABLE authors ( author_id INT NOT NULL AUTO_INCREMENT,
title_id INT NOT NULL,
author VARCHAR (125),
PRIMARY KEY (author_id));
Posted by on 08/18 at 10:40 AM