MySQL×Ö·û´®´¦Àíϵͳ

ÒÔÏÂÊÇÍêÕûµÄÀý×Ó¡£
1¡¢Ð½¨±í
#title: ×Ô¶¨Òå×Ö·û
#auther: Ð¡Ç¿(Õ¼²·Ê¦) 
#date: 
2008
-
01
-08
drop
 
table
 
if
 
exists
 Category;
create
 
table
 Category
(
   cateId                         
int
(
5
)                         
not
 
null
 AUTO_INCREMENT,
   chiName                        
varchar
(
80
),
   
primary
 
key
 (cateId)
);
drop
 
table
 
if
 
exists
 OpenRecord;
create
 
table
 OpenRecord
(
   opreId                         
int
(
5
)                         
not
 
null
 AUTO_INCREMENT,
   cateIds                        
varchar
(
80
),
   
primary
 
key
 (opreId)                    
);
2¡¢³õʼ»¯Êý¾Ý
insert
 Category(chiName) 
values
 (
'
fish
'
),(
'
shrimp
'
),(
'
crab
'
),(
'
tiger
'
);
insert
 OpenRecord(cateIds) 
values
(
'
1,2
'
);
insert
 OpenRecord(cateIds) 
values
(
'
2,3