SQLite Studio 多个sql语句一起执行
insert into Sockets
( zoneindex, electricequipmentindex, brand, sockettype, vendor, communicationmode)
values
(@_zoneindex, @v_electricequipmentindex, @v_brand, @v_sockettype, @v_vendor, @v_communicationmode);
insert into reportmeterdatadictionary
( variabletype, SocketIndex, variablename, variableunits)
values
( 'real', (select max(SocketIndex) from Sockets), 'Name', 'Unites');