sairam
sairam

Reputation: 309

How to insert same value to entire column in sqlite3?

I need to insert a text to entire column in the table. Column is having 200 rows. I need to insert the same value into entire 200 rows of the same column...

How could I do this?

Upvotes: 7

Views: 3560

Answers (1)

Paul
Paul

Reputation: 141877

UPDATE `Table` SET `Column` = 'value'

Just with no WHERE clause

Upvotes: 10

Related Questions