selec A.hblfile,B.hbltxlfile from
(select id,hblfile from file where number = '2012050002' group by hblfile having hblfile != '' order by id desc limit 1) A,
(select id,hbltxlfile from file where number = '2012050002' group by hbltxlfile having hbltxlfile != '' order by id desc limit 1) B
select F.number,A.hblfile,B.hbltxlfile,C.mblfile,D.mbltxlfile,E.loadingfile from file F
left join
(select id,number,hblfile from file where number = '2012050002' group by hblfile having hblfile != '' order by id desc limit 1) A
on F.number = A.number
left join
(select id,number,hbltxlfile from file where number = '2012050002' group by hbltxlfile having hbltxlfile != '' order by id desc limit 1) B
on F.number = B.number
inner join
(select id,number,mblfile from file where number = '2012050002' group by mblfile having mblfile != '' order by id desc limit 1) C
on F.number = C.number
left join
(select id,number,mbltxlfile from file where number = '2012050002' group by mbltxlfile having mbltxlfile != '' order by id desc limit 1) D
on F.number = D.number
left join
(select id,number,loadingfile from file where number = '2012050002' group by loadingfile having loadingfile != '' order by id desc limit 1) E
on F.number = E.number
where F.number = '2012050002' limit 1
create trigger Tupdate
before insert on cargo2
for each row
begin
declare @number varchar(30)
select @number=number from inserted
update cargo1 set valid = '1' where number = @number
end
create trigger Tupdate
before insert on cargo2
for each row
begin
declare @number
select @number = number for inserted
update cargo1 set valid = '1' where number = @number
end;
分享到:
相关推荐
tw2865 tw2868 tw2960驱动
TW6802中文V5.7可用于IE监控端胡炒作
TW8811 8816 屏幕驱动芯片。实现OSD 视频缩放。不同分辨率显示的。
8836资料文档,主要包含8836的相关代码,驱屏等等。总之需要慢慢悟!
TW6802与TW6805监控软件驱动TW6802与TW6805监控软件驱动
SDK_TW8836_v1 keil 源代码 TW_Terminal3.zip I2C调试工具 OSDsolution_264h.exe OSD工具 TW8836B_FN8645.2.pdf datasheet
TW883X 调试工具说明文档,用于TW883X芯片开发
基于TW-TOF的UWB室内定位技术与优化算法研究基于TW-TOF的UWB室内定位技术与优化算法研究基于TW-TOF的UWB室内定位技术与优化算法研究基于TW-TOF的UWB室内定位技术与优化算法研究基于TW-TOF的UWB室内定位技术与优化...
tw2866 tw2865 datasheet
The TW2865 is a 4-in-1 video decoder and audio codec plus video encoder for security surveillance applications. The device includes four high quality NTSC/PAL/SECAM video decoders that convert analog ...
TW8816.rar为屏驱动IC的源代码,车载类产品此IC用的很多。
TW8816是高集成多用途的模拟和数字面板的LCD显示方案,集成了8位MCU和CCFL(冷阴极灯管)控制器。通过复用输入端口,TW8816可从TV调谐器、DVD播放机、备份相机、DTV/DMB(数字多媒体广播)接收器和导航/GPS接收器等...
这是本人在看英文文档所做的中文翻译注释,对于刚接触tw2836的童鞋有一些帮助,里面会有多不翻译不对的地方,希望谅解
TECHWILL最新产品TW8835应用原理图,有需要的请下载
8836烧录工具 - TW_Terminal2.exe TW_Dongle All Windows.inf TW_Terminal2.ini TW8836B
Video processor TW8844-45 datasheet.
TW入门手册
Assassins.Creed.III.TW.THETA.RIP.torrent3DMGAME.Assassins.Creed.III.TW.THETA.RIP.torrent3DMGAME.Assassins.Creed.III.TW.THETA.RIP.torrent3DMGAME.Assassins.Creed.III.TW.THETA.RIP.torrent3DMGAME....
config VIDEO_TW6869 tristate "Techwell tw6869 Video For Linux" depends on VIDEO_DEV && PCI && VIDEO_V4L2 select VIDEOBUF2_DMA_SG tw6869-objs := tw6869-core.o tw6869-video.o tw6869-audio.o