在單個(gè)SQL查詢中插入多行？我一次要插入多組數(shù)據(jù)，比如4行。我的桌子有三列：Person, Id和Office.INSERT INTO MyTable VALUES ("John", 123, "Lloyds Office");INSERT INTO MyTable VALUES ("Jane", 124, "Lloyds Office");
INSERT INTO MyTable VALUES ("Billy", 125, "London Office");INSERT INTO MyTable VALUES ("Miranda", 126, "Bristol Office");我能insert一次中的所有4行SQL statement?
在單個(gè)SQL查詢中插入多行？
POPMUISE
2019-06-15 18:26:36