我写了类似的东西
create table if not exists QuickTest (
id integer primary key NOT NULL,a TEXT DEFAULT @0,b TEXT,c TEXT);
我在@ 0上收到错误.有没有办法在这里插入参数或我需要硬编码值?我通常喜欢在设置值时使用参数.
解决方法
您必须使用字符串常量或NULL.
http://www.sqlite.org/syntaxdiagrams.html#column-constraint
The DEFAULT constraint specifies a default value to use when doing an INSERT. The value may be NULL,a string constant,a number,or a constant expression enclosed in parentheses. The default value may also be one of the special case-independant keywords CURRENT_TIME,CURRENT_DATE or CURRENT_TIMESTAMP. If the value is NULL,a string constant or number,it is inserted into the column whenever an INSERT statement that does not specify a value for the column is executed. If the value is CURRENT_TIME,CURRENT_DATE or CURRENT_TIMESTAMP,then the current UTC date and/or time is inserted into the columns. For CURRENT_TIME,the format is HH:MM:SS. For CURRENT_DATE,YYYY-MM-DD. The format for CURRENT_TIMESTAMP is “YYYY-MM-DD HH:MM:SS”.
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|