日期:2013-03-21  浏览次数:20536 次

//mysql数据库的sql

CREATE TABLE user(  id int(5) DEFAULT '0' NOT NULL AUTO_INCREMENT,  name varchar(20),  city varchar(20),  postcode varchar(10),address varchar(100),  password varchar(10), level tinyint(2) DEFAULT '0',right tinyint(2),email varchar(40), PRIMARY KEY (id),  UNIQUE id (id));
INSERT INTO myuser VALUES (1,'王友','北京','100083','北京市海淀区学院路',111,0,0,'wangyou000@263.net');
INSERT INTO myuser VALUES (2,'金风','武汉','430071','武汉市武昌区水果湖',111,0,0,'jinfeng000@263.net');
INSERT INTO myuser VALUES (3,'常丽','襄樊','441021','襄樊市襄城区南街',111,0,0,'changli000@263.net'); 

1.查寻全部

<html>                                                             
                                                                   
 <head>                                                            
  <title> 查寻全部</title>                                      
 </head>                                                           
                                                                   
<body>                                                             
                                                                   
  <h2 align=center>                                                 <