求一个Mysql的两个表间取数据的SQL语句
有两个表结构完全相同的表m1（mid，vipid）和m2（mid,vipid）,只是两表中的数据记录数不同，现在要求用SQL语句实现：取出两表中vipid不同的数据记录，把这些数据写入表m中，望高手赐教，怎么对两个表得到的结果集进行处理，谢谢！
既然相同 为什么要哦设计两个表呢？
lz 可以用个左连接 left join 试试看。
SQL code:
mysql> create table tab_B(id int primary key auto_increment,username varchar(20
);
Query OK, 0 rows affected (0.09 sec)
mysql> insert into tab_A values('A');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> insert into tab_A(username) values('A');
Query OK, 1 row affected (0.05 sec)
mysql> insert into tab_A(username) values('B');
Query OK, 1 row affected (0.05 sec)
mysql> insert into tab_B(username) values('C');
Query OK, 1 row affected (0.05 sec)
mysql> insert into tab_B(username) values('D');
Query OK, 1 row affected (0.05 sec)
mysql> [color=#FF0000]select * from tab_a union all select * from tab_b;[/color]
+----+----------+
| id | username |
+----+----------+
| 1 | A |
| 2 | B |
| 1 | C |
| 2 | D |
+----+----------+
4 rows in set (0.00 sec)
mysql>
SQL code:
mysql> create table tab_B(id int pr
相关问答：
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
sql的软件在哪里可以下啊！在网上找了蛮多都用不了啊
随便搞一D版吧，
迅雷第一个就可以用
2000,2005都这样
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
上面一个简单的SQL,执行时间2.6� ......
字段1,字段2.....字段N,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
想要的结果是:
1,Na ......
第一句:
select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je
from ht left join gfdm on ht.gfdm=gfdm.gfdm
join jh on ht.htbh=jh.hth
and ht.htbh not like'del%' and ht. ......
