诗意的栖居

详细链接http://blog.youkuaiyun.com/linchunhua/article/details/7184439 $sqlite3 myDB #运行并且使用myDB这个数据库 SQLite version 3.7.2 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite>...

1、sqlite支持建立自增主键，sql语句如下： CREATE TABLE w_user( id integer primary key autoincrement, userename varchar(32), usercname varchar(32), userpassword varchar(32), userpermission varchar(32), ...