Nitish
Reputation: 14123
Insert same value in all elements of field in a SQLite query
I have some 750 rows in my sqlite table. I am adding a new field localPath into it. I have to insert the same string default in the field as value. How to insert this value for 750 rows?
Upvotes: 1
Views: 135
Answers (1)
deed02392
Reputation: 5022
It should be as simple as:
UPDATE table SET localPath = 'default'
Upvotes: 3
Related Questions
- SQLite: How to insert the same value to multiple columns?
- How to insert same value to entire column in sqlite3?
- Adding all elements of same column in SQLite
- Batch insert values to a specific column in sqlite3 on iOS
- Inserting multiple rows in SQLite3
- how to insert values in sqlite
- Insert Values In SQLITE Database
- how can I insert value into my sqlite3 database table?
- Insert statement doesn't check for duplicate values
- How do I insert multiple values into a single column using sqlite?