On 15 Oct 2014, at 1:10am, Shantanu Namjoshi <shantanu.namjo...@business.uconn.edu> 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
