Little brother Read the "PHP and Mysql,web development", today just saw the database, according to the code copied a SQL script, ready to upload with phpMyAdmin, but the error is as follows, check the one hours Leng did not understand the wrong where, ask the Big God to guide the Maze ah ...
The code is as follows:
CREATE table Customers{customerid int unsigned NOT NULL auto_increment primary Key,name char (a) not null,address char (100 ) not null,city char (+) not null};create table Orders{orderid int unsigned NOT NULL auto_increment primary Key,customerid int unsigned not null,amout float (6,2), date date not null};create table Books{isbn char (all) not null primary Key,author C Har (+), title char (+), price float (4,2)};create table Order_items{orderid int unsigned not NULL,ISBN char (all) not null,qu Antity tinyint unsigned,primary key (ORDERID,ISBN)};create table Book_reviews{isbn char (all) NOT null primary Key,review TE XT};
Reply to discussion (solution)
The younger brother himself to find the reason, the original is {} should be replaced (), shame where, in the end e-book is too small to see clearly, haha, sorry ...