"Richard Boyd" <[EMAIL PROTECTED]> wrote: > >>Use the built-in quote() function. > -- > > Ok I think I found it. (http://www.sqlite.org/lang_expr.html) > I'm not really familiar with this method of calling a function in an > expression. Is there away to have it only quote the TEXT columns and not the > INTEGER columns, or does it do this anyway by default? > > Ideally I'd like the entire row returned with TEXT strings in quotes but > everything else left as normal. > > SELECT * from Table0 quote(??some expression in here??); > ???? >
SELECT quote(column1), quote(column2), ... FROM table0; The quote function leaves number unchanged. It only quotes TEXT and BLOB data. If you are using the command-line client, you can also do this: .mode insert table_x select * from table0; The above will output SQL containing INSERT statements for table_x. -- D. Richard Hipp <[EMAIL PROTECTED]>
