圖書管理程式（一）_PHP教程

本級程式所用的資料表結構：
# ------------------------------------- -------------------
#
# 資料表的結構'author'
#

CREATE TABLE author (
   author_id int(6) DEFAULT '0' NOT NULL auto_increment,
   first_name varchar(20) binary NOT NULL,
  
   zipcode varchar(10) NOT NULL,
   telephone varchar(10) NOT NULL,
   e EY (author_id ),
   KEY first_name (first_name),
   KEY last_name (last_name),
   KEY address ( 🎜>) ;

# ------------------------------------------ --------------
#
# 資料表的結構'books'
#

CREATE TABLE books (
   books_id int(6 ) DEFAULT '0' NOT NULL auto_increment,
   books_name varchar(100) binary NOT NULL,
   publisher_id varchar(6) NOT NULL,
   publisher_id varchar(6) NOT NULL, ' NOT NULL,
   type varchar(6) NOT NULL,
   pages varchar(4) NOT NULL,
   price float(6,2) DEFAULT '0.00' NOT N9 binary NOT NULL,
   ISBN varchar(25) NOT NULL,
   PRIMARY KEY (books_id),
   KEY name (books_name),
_pub (date_pub) ,
   KEY price (price),
   KEY pages (pages),
   KEY type (type),
  -------------------------------------------------- -
#
# 資料表的結構'books_author'
#

CREATE TABLE books_author (
   id int(6) DEFAULT '0' NOT NULL_uto_pbook varchar(6) NOT NULL,
   author_id varchar(6) NOT NULL,
   author_type varchar(6) NOT NULL,
   PRIMARY KEY (id)
🎜> -------------------------------------------------- -----
#
# 資料表的結構'publisher'
#

CREATE TABLE publisher (
   publisher_id int(6) DEFAULT '0' NOTULL
   publisher_name varchar(100) binary NOT NULL,
   address varchar(100) NOT NULL,
   zipcode varchar(10) NOT NULL,
   zipcode varchar(10) NOT NULL,
   zipcode varchar(10) NOT NULL,
   zipcode.  telefax varchar (10) NOT NULL,
   email varchar(50) NOT NULL,
   PRIMARY KEY (publisher_id),
   KEY name (publisher_name),
   KEY address (address),
   KEY email ( email)
);





http://www.bkjia.com/PHPjc/315968.html

www.bkjia.com

true

http: //www.bkjia.com/PHPjc/315968.html

TechArticle

本級程式所使用的資料表結構： # -------------- ------------------------------------------ # # 資料表的結構'author ' # CREATE TABLE author ( author_id int(6) DEFAULT '...