tableA:
idA name age scroll
1 kaka 14 54
2 lala 22 46
3 nana 24 86
tableB:
idB idA name age staut
1 1 kaka 14 1
2 3 nana 24 1操作过程是这样的:
由一个tableA的Id,比如1,得到相关条数据,然后判断,如果scroll>50,那么就把这条数据写入tableB中一条sql能完成么?
idA name age scroll
1 kaka 14 54
2 lala 22 46
3 nana 24 86
tableB:
idB idA name age staut
1 1 kaka 14 1
2 3 nana 24 1操作过程是这样的:
由一个tableA的Id,比如1,得到相关条数据,然后判断,如果scroll>50,那么就把这条数据写入tableB中一条sql能完成么?
select idA,name,age,1
from tableA
where scroll>50
TRYinsert into tableB(idA,name,age,staut)
select idA,name,age,1
from tableA
where scroll>50
+-----+------+------+--------+
| idA | name | age | scroll |
+-----+------+------+--------+
| 1 | kaka | 14 | 54 |
| 2 | lala | 22 | 46 |
| 3 | nana | 24 | 86 |
+-----+------+------+--------+
3 rows in set (0.00 sec)mysql> select * from tableB;
Empty set (0.00 sec)mysql> insert into tableB(idA,name,age,staut)
-> select idA,name,age,1
-> from tableA
-> where scroll>50;
Query OK, 2 rows affected (0.06 sec)
Records: 2 Duplicates: 0 Warnings: 0mysql> select * from tableB;
+-----+------+------+------+-------+
| idB | name | idA | age | staut |
+-----+------+------+------+-------+
| 1 | kaka | 1 | 14 | 1 |
| 2 | nana | 3 | 24 | 1 |
+-----+------+------+------+-------+
2 rows in set (0.00 sec)mysql>
id用的是int
犯了一个错误,测试的时候,把一个表起名叫'order'...因为是'定单表'