查询用select a.order_type,delivery_date,procedure_no from table_one a,table_two b where a.order_type=b.order_type
目前mysql还不支持select *** into table_three
你只好用create table的办法创建新表,然后再用insert into table_three select a.order_type,delivery_date,procedure_no from table_one a,table_two b where a.order_type=b.order_type
一定行的。
目前mysql还不支持select *** into table_three
你只好用create table的办法创建新表,然后再用insert into table_three select a.order_type,delivery_date,procedure_no from table_one a,table_two b where a.order_type=b.order_type
一定行的。
解决方案 »
- 【求助】php新手问题,用zend studio连接Oracle出错。
- 用 php 打开本地目录可行否?
- 请问php pdo 在select的时候怎么判断结果集为空?
- 关于html中select的问题,大家请进。
- 急!为什么结果集是空的???
- PHP与Apache?
- PHP中GD显示汉字--发个贴,顺便送点分。
- 执行substr($content,0,32),因为$content中可能存在字母,也可能存在汉字,所以输出$content的时候,总是出现"?" 虚心请教解决方法
- 我提交验证码后为什么不能正常登录到后台主页,恳请大神指点!
- 数据库报错,求解
- 請教一個session的問題.
- 有个十万火急的问题
select one.order_type,one.quantity,one.delivery_date,two.lot_no,two.procedure_no,two.machine_in,two.user_time into table_three from table_one as one left join table_two as two [where one.delivery_date > to_day(NOW())] order by one.order_type desc,one.delivery_date asc,two.procedure_no asc
from table_one as one left join table_two as two on one.order_type=two.order_type
insert into table_three select one.order_type,one.quantity,one.delivery_date,two.lot_no,two.procedure_no,two.machine_in,two.user_time from table_one as one left join table_two as two on one.order_type=two.order_type
[where one.delivery_date > to_day(NOW())] order by one.order_type desc,one.delivery_date asc,two.procedure_no asc
order by one.order_type desc让'u'记录在前面