读书人

Sqlite SQL语句的最大长度是多少?解决

发布时间: 2012-02-07 17:45:36 作者: rapoo

Sqlite SQL语句的最大长度是多少??
我想多个语句一起提交..
它的SQL语句最大长度是多少字节?
貌似我用的,超过5k就会有问题...

[解决办法]
1000000,似乎远大于你的5K啊,你是在什么中执行啊?

引用Maximum Length Of An SQL Statement

The maximum number of bytes in the text of an SQL statement is limited to SQLITE_MAX_SQL_LENGTH which defaults to 1000000. You can redefine this limit to be as large as the smaller of SQLITE_MAX_LENGTH and 1073741824.

读书人网 >其他数据库

热点推荐