在SQL中怎么样将一个表的的多条记录插入到另一个表中
列名不一定要相同,只要你在HH中列出要插入列的列表跟select from mm表中的选择的列的列表一一对应就可以了,
当然两边的数据类型应该是兼容的。
比如:insert into hh (fielda,fieldb,fieldc) select fieldx,fieldy,fieldz from mm
SQL语句示例:
insert into RHISTORY_TBL \
select S.MACID,S.CURTMPRTE,sysdate() \
from RCURSTATE_TBL S\
WHERE S.CURSTATE = 0
获得系统时间:
第一种方法:select current_date;
mysql> select current_date as Systemtime;
+------------+
| Systemtime |
+------------+
| 2009-07-29 |
+------------+
第二种方法:select now()
mysql> select now() as Systemtime;
+---------------------+
| Systemtime |
+---------------------+
| 2009-07-29 19:06:07 |
+---------------------+
第三种方法:select sysdate()
mysql> select sysdate() as Systemtime;
+---------------------+
| Systemtime |
+---------------------+
| 2009-07-29 19:06:45 |
+---------------------+