这条插入语句如何写我有两个表CREATE TABLE `outletinfo` (
`outletno` int(10) unsigned NOT NULL default '0',
`outletname` varchar(45) NOT NULL default '',
`ip` varchar(45) NOT NULL default '',
PRIMARY KEY (`outletno`)
) ;INSERT INTO `outletinfo` (`outletno`,`outletname`,`ip`,`subbranchno`) VALUES
(1,'钟楼','192.168.1.11'),
(2,'火车站','192.168.1.12'),
(3,'软件园','192.168.1.13');
CREATE TABLE `wlog` (
`id` int(10) unsigned NOT NULL auto_increment,
`workerno` int(11) NOT NULL default '0',
`outletno` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
);INSERT INTO `wlog` (`workerno`,`outletno`) VALUES (1001,1);其中wlog中的outletno是在outletinfo表中,现在要在wlog表中插入一条记录,已知workerno,ip,如何从写出SQL语句
`outletno` int(10) unsigned NOT NULL default '0',
`outletname` varchar(45) NOT NULL default '',
`ip` varchar(45) NOT NULL default '',
PRIMARY KEY (`outletno`)
) ;INSERT INTO `outletinfo` (`outletno`,`outletname`,`ip`,`subbranchno`) VALUES
(1,'钟楼','192.168.1.11'),
(2,'火车站','192.168.1.12'),
(3,'软件园','192.168.1.13');
CREATE TABLE `wlog` (
`id` int(10) unsigned NOT NULL auto_increment,
`workerno` int(11) NOT NULL default '0',
`outletno` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
);INSERT INTO `wlog` (`workerno`,`outletno`) VALUES (1001,1);其中wlog中的outletno是在outletinfo表中,现在要在wlog表中插入一条记录,已知workerno,ip,如何从写出SQL语句
select 1001,outletno
from outletinfo
insert into `wlog` (`workerno`,`outletno`) select 1001,outletno from outletinfo where ip='192.168.1.11'