开发者

How to INSERT SQL statements INTO table

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜