mysql - 从两个表插入where条件

Question

我有3张 table

表 1 EIN 列:

id, name, plate,in_datetime,time,image-name.

表 2 EOUT 列:

id, name, plate, out_datetime, time, image-name.

表 3 侦察列:

id, plate,in_datetime,in_entry_id,out_datetime, out_entry_id,Processed, duration.

我需要使用 where 条件将表 1 和表 2 的值放入表 3 列中。我正在使用以下查询:

INSERT INTO recon (id,EIN.plate,EIN.in_datetime, EIN.id,  EOUT.out_datetime, EOUT.id,null, null) 
    SELECT EIN.RegistrationMark,EIN.datetime,EIN.id, EOUT.date,EOUT.id FROM EIN_anpr_vega as EIN, EOUT_anpr_vega as  EOUT
    where EIN.plate = EOUT.plate
    and EIN.in_datetime = EOUT.out_datetime

我在 null 附近遇到错误，null。下面是错误。

for the right syntax to use near 'null, null

Answer 1

在列名中不能写 null

INSERT INTO recon (id,EIN.plate,EIN.in_datetime, EIN.id,  EOUT.out_datetime, EOUT.id,null, null) 

相反，请写入列名称并将空值放入选择中。像这样:

INSERT INTO recon (id,EIN.plate,EIN.in_datetime, EIN.id,  EOUT.out_datetime, EOUT.id,col1, col2) 
    SELECT EIN.RegistrationMark,EIN.datetime,EIN.id, EOUT.date,EOUT.id, null, null FROM EarlsdonMSIN_anpr_vega as EIN, EarlsdonMSOUT_anpr_vega as  EOUT
    where EIN.plate = EOUT.plate
    and EIN.in_datetime = EOUT.out_datetime