开发者

How to INSERT SQL statements INTO table

开发者 https://www.devze.com 2023-02-13 23:55 出处:网络
In MS Access, how do I insert a row which has one column that takes an SQL statement (SELECT) as value? In other words, how开发者_高级运维 to I tell the SQL interpreter not to try to parse that statem

In MS Access, how do I insert a row which has one column that takes an SQL statement (SELECT) as value? In other words, how开发者_高级运维 to I tell the SQL interpreter not to try to parse that statement and give me errors?


Wrap it in quotes like any other character.

INSERT INTO myTable
('MySQLColumn')
VALUES
('SELECT * FROM MyOtherTable')
0

精彩评论

暂无评论...
验证码 换一张
取 消