Re: [sqlite] INSERT into a whole table at once

[Jay Sprenkle]

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]
-

[sqlite] INSERT into a whole table at once

[Richard Stern]

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.

I tried things like:

INSERT INTO Table ALL VALUES ("test");

But it has an error on the ALL. I tried putting the ALL in lots of different
places but it didn't work. I also tried * as a wildcard in the place where
you normally specify columns but that didn't work either.

There is a way to do this right?


Richard



-
To unsubscribe, send email to [EMAIL PROTECTED]
-