mysql> use dazhe;
Database changed
mysql> create table shops(id int primary key auto_increment not null,name varchar(100),info varchar(200
Query OK, 0 rows affected (0.41 sec) mysql> create table lanmu(id int primary key auto_incrememt not null,name varchar(100),fatherid int);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MyS
herid int)' at line 1
mysql> create table lanmu(id int primary key auto_incrememt not null,name varchar(100),fatherid int);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MyS
herid int)' at line 1
mysql> create table lanmu(id int ,name varchar(100),fatherid int);
Query OK, 0 rows affected (0.14 sec) mysql> create table sl(sid int,lid int);
Query OK, 0 rows affected (0.14 sec) mysql> insert into shops(id,name,info) values(,'nike','45%');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MyS
mysql> insert into shops(id,name,info) values(,'nike','0.6');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MyS
mysql> insert into shops(id,name,info) values(1,'nike','0.6');
Query OK, 1 row affected (0.08 sec) mysql> insert into shops(id,name,info) values(2,'adidas','0.4');
Query OK, 1 row affected (0.08 sec) mysql> insert into shops(id,name,info) values(3,'puma','0.8');
Query OK, 1 row affected (0.06 sec) mysql> insert into lanmu(1,'boy',0);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MyS
mysql> insert into lanmu(id,name,fatherid) values(1,'boy',0);
Query OK, 1 row affected (0.08 sec) mysql> insert into lanmu(id,name,fatherid) values(2,'girl',0);
Query OK, 1 row affected (0.07 sec) mysql> insert into lanmu(id,name,fatherid) values(3,'famous',0);
Query OK, 1 row affected (0.39 sec) mysql> insert into lanmu(id,name,fatherid) values(4,'boyshoe',1);
Query OK, 1 row affected (0.12 sec) mysql> insert into lanmu(id,name,fatherid) values(5,'pants',1);
Query OK, 1 row affected (0.11 sec) mysql> insert into lanmu(id,name,fatherid) values(6,'girlpants',2);
Query OK, 1 row affected (0.08 sec) mysql> insert into lanmu(id,name,fatherid) values(7,'witch',3);
Query OK, 1 row affected (0.07 sec) mysql> create table lanmu_shopname(id,lid int,sname varchar(100));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MyS
mysql> create table lanmu_shopname(id int,lid int,sname varchar(100));
Query OK, 0 rows affected (0.26 sec) mysql> insert into lanmu_shopname(id,lid,sname) values(1,1,'nike');
Query OK, 1 row affected (0.08 sec) mysql> insert into lanmu_shopname(id,lid,sname) values(2,1,'adidas');
Query OK, 1 row affected (0.08 sec) mysql> select * from lanmu where id=1;
+------+------+----------+
| id | name | fatherid |
+------+------+----------+
| 1 | boy | 0 |
+------+------+----------+
1 row in set (0.00 sec) mysql> select * from lanmu_shopname where id=1;
+------+------+-------+
| id | lid | sname |
+------+------+-------+
| 1 | 1 | nike |
+------+------+-------+
1 row in set (0.00 sec) mysql> select * from lanmu_shopname where lid=1;
+------+------+--------+
| id | lid | sname |
+------+------+--------+
| 1 | 1 | nike |
| 2 | 1 | adidas |
+------+------+--------+
2 rows in set (0.00 sec) mysql> select sname from lanmu_shopname where lid=1;
+--------+
| sname |
+--------+
| nike |
| adidas |
+--------+
2 rows in set (0.00 sec) mysql> select * from shop where sname in(select sname from lanmu_shopname where lid =1);
ERROR 1146 (42S02): Table 'dazhe.shop' doesn't exist
mysql> select * from shops where sname in(select sname from lanmu_shopname where lid =1);
ERROR 1054 (42S22): Unknown column 'sname' in 'IN/ALL/ANY subquery'
mysql> select * from shops where name in(select sname from lanmu_shopname where lid =1);
+----+--------+------+
| id | name | info |
+----+--------+------+
| 1 | nike | 0.6 |
| 2 | adidas | 0.4 |
+----+--------+------+
2 rows in set (0.02 sec)
版权声明：本文为博主原创文章，未经博主允许不得转载。