Thank you Simon. Will do. Shantanu ________________________________________ From: [email protected] [[email protected]] on behalf of Simon Slavin [[email protected]] Sent: Tuesday, October 14, 2014 11:27 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] UPDATE Help
On 15 Oct 2014, at 1:10am, Shantanu Namjoshi <[email protected]> wrote: > ALTER TABLE dailydelete ADD COLUMN SMB varchar(11); If you find yourself doing things like this your schema is messed up. SMB is obviously data, not a column. Redesign your table so that HML, SMB, UMD and Rf are values in a column, not the names of columns. By the way, SQLite doesn't have a varchar type. Your data will be interpreted as TEXT, and will not be truncated to 11 characters. It would be better just to declare the column as TEXT. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://cp.mcafee.com/d/5fHCNEedEI8IIIcK6zCVKVJAsCVssqekjr8VdOXP3NJAsCVssqemjoUsej79II6WgRkhHgD8546WixZasTqI8tW3pIwTikfFjCXlx3LgrdzH6zDQ6m7-LO8VxMsDvHTbFIL6zDCkjhOy-UVORQr8FGTKVOEuvkzaT0QSyrhdTWVEVs73C4jhOO-rKr01Q5zVj_w0ajRTHU0xsxa62qKMM-l9OwXna2NYF-nrFYq6W2NYF-nrFYq5O5mUm-waEb7OD_00jrbBNNI5-Aq83iTgmfBfPiWq80C5wUg18Qq80LVWNJdwTvf_-a2 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
