[sqlite] CREATE TABLE work arounds?

[David Lyon]

I am parsing fields on the fly and then creating tables, unfortunately one of 
the fields is "Order" and is a "special word" in SQL as is not allowed. Is 
there a way around this instead of intercepting with perl s'/Order/Orders/g'



thanks



sqlite3 DB "CREATE TABLE META (channel_count  TEXT  , description  TEXT  , 
feature_count  TEXT  , Order  TEXT  , platform  TEXT  , platform_organism  TEXT 
 , platform_technology_type  TEXT  , pubmed_id  TEXT  , reference_series  TEXT  
, sample_count  TEXT  , sample_organism  TEXT  , sample_type  TEXT  , title  
TEXT  , type  TEXT  , update_date  TEXT  , value_type  TEXT  )"

Error: near "Order": syntax error


      
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users