sampledb.sql

来自「MYSQL 连接控件 MYSQL 连接控件」· SQL 代码 · 共 59 行 · 第 1/2 页

#----------------------------
# Table structure for accounts
#----------------------------
create table accounts (
   AccountID int(11) not null auto_increment,
   AccountName varchar(255) not null,
   AccountAddr varchar(255),
   primary key (AccountID));

#----------------------------
# Records for table accounts
#----------------------------


insert  into accounts values (1, 'A. AAAAA', 'POBox 1, A, 1111') ;
insert  into accounts values (2, 'B. BBBBC', 'POBox 2, B, 2222') ;
insert  into accounts values (3, 'C. CCCCD', 'POBox 3, C, 3333') ;
#----------------------------
# Table structure for orders
#----------------------------
create table orders (
   OrderID int(11) not null auto_increment,
   AccountID int(11) not null default '0',
   ProductID int(11) not null default '0',
   primary key (OrderID));

#----------------------------
# Records for table orders
#----------------------------