INSERT INTO ac12 (id,aac111,aac001,aab001,aac124,aac125 ) VALUES ( SELECT nextval('seq_ac01_aac001'),'11','11',(SELECT aab001 FROM ac01 WHERE aac001 = '0000008862'),'11','11' )SELECT nextval('seq_ac01_aac001')是调用一个函数获取一个值。
请问一下这种语句在MYSQL中怎么写?
请问一下这种语句在MYSQL中怎么写?
SELECT nextval('seq_ac01_aac001'),'11','11',aab001,'11','11' from ac01 where aac001 = '0000008862'
VALUES ( (SELECT nextval('seq_ac01_aac001')),'11','11',(SELECT aab001 from ac01 where aac001 = '0000008862'),'11','11' )
SELECT nextval('seq_ac01_aac001'),'11','11',aab001 ,'11','11' FROM ac01 WHERE aac001 = '0000008862'
SELECT nextval('seq_ac01_aac001'),'11','11',aab001,'11','11' from ac01 where aac001 = '0000008862'