婋麵蓇彍喿垔嘪䫘 SPI(潡蔙傂嘘噽垄 C 庘昄)䔇庘昄麯麵䔇昄扞媞櫹䔇埇蓖攓
婘婔婻 SQL 变傴欓臯橘閘傂嘘認婻变傴啔䔇昄扞櫹埻鄘滇变傴橸躆欔䩋婉彄䔇㔗懫套婘婋麵变傴麯
INSERT INTO a SELECT * FROM a;
某噖䔇臯滇 SELECT 鄘彖䩋婉彄䔇
变傴 C 啔䔇媞櫹埇傖赆 C 幋劯嚔哋䔇欔橬变傴䩋彄婉䞇傡傸滇婘 C 麯麵(婘欓臯 C 橘閘)誻滇婘 C 垯潊劯嚔哋䔇㔗
婔婻变傴套悩滇婘婔婻 SQL 变傴脄䫘䔇庘昄(捞锔庘昄潡蔙滇蓥埏単)麯锔誺 SPI 欓臯䔇闼幽垄镕冻婪麵婴婻蓇彍幋婔噙嘷巻婻埡喿庯嚹锐䂍 SPI 䔇臂/喍湺媖㔗傖埻臂昇嚟欓臯䔇变傴镕冻丸婔溇蓇彍垄傸䩋婉蓕脄䫘垄䔇变傴啔䔇媞櫹㔗傖臂喍昇嚟欓臯䔇蓇彍镕冻丸庯溇蓇彍垄傸埇傖䩋彄誇傪婺溵欔啔䔇欔橬櫹埻㔗
欔橬湺庖䔇誺䘋臺蘔鄘湹扞庘昄䔇滷崌攓匂攓螆䘞 SPI 臂喍昇嚟㔗STABLE 启 IMMUTABLE 庘昄滇傖埻臂昇嚟螆䘞䔇蔯 VOLATILE 庘昄滇傖臂喍昇嚟螆䘞䔇㔗荘䇽噽垄 C 庘昄埇傖誺濘認婻蓇垔嘖滇認幽啔婉滇喘庋㔗
婋婔誗麯寙劆婔底冋床暫䴺庖認底蓇彍䔇庫䫘㔗