On 23 Mar 2013, at 4:07pm, Marco Turco <m.tu...@softwarexp.co.uk> wrote:
> I have a table with one field defined as smallint(3) and I would like to > change the field type now in char(3) (without lost the value inside). > > How can I make the change ? Do I need to create a new table with the new > fields where import the current data or is there a better method ? First, SQLite doesn't have smallint or char types. It will understand those as INTEGER and TEXT affinities. Second, one way do to what you want is to use the SQLite shell tool: <http://www.sqlite.org/sqlite.html> You can download a precompiled version from the SQLite download page. Use the '.dump' command to write your whole database (or maybe just the table) as SQL commands. Then use a text editor to change the command that creates that table. Then use the '.read' command to read that file in, which will make the new table and put the data back in again. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
