lizhe <l...@...> writes: > > > Dear Sir: > I have a table type is blob,I think update integer type, > How to solve my trouble? "alter" SQL?
[...] use the CLI (sqlite3) and your favourite editor: sqlite3 yourdatabase .output file.sql .dump .q edit file.sql <change from your column type to INTEGER> sqlite3 yournewdatabase < file.sql ready Oliver _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
