On 9/18/06, Richard Stern <[EMAIL PROTECTED]> wrote:
I have a big table and I want to change all the values in a row to the same thing but I'm not sure what key word would allow me to do this.
Nothing built into the SQL language. it would be something like this: update mytable set column1 = 'test', column2 = 'test', column3 = 'test' where rowid = something You can write a program to do this fairly simply. -- -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------