SQL help

PeanutGallery

Well-known member
Totally absolutely new to SQL.

Linux
DB Browser for SQLite
Version 3.10.1
Qt Version 5.11.1
SQLite Version 3.24.0

When I go to the tab 'Execute SQL', I can run either one of the following scripts individually; however, I can't seem to run both at the same time. Is this a limitation, or is the syntax incorrect?


select * from Bible where Book > 39 and Book < 67 ;

UPDATE Bible
SET Scripture = replace(Scripture,"Eglise","église") ;

Basically while in 'Execute SQL', I want to change all occurrences "Eglise" to "église" in the NT.
However, I can only select NT and not make changes; or, I can make changes but not only in NT.
 

Algernon

Active member
Totally absolutely new to SQL.

Linux
DB Browser for SQLite
Version 3.10.1
Qt Version 5.11.1
SQLite Version 3.24.0

When I go to the tab 'Execute SQL', I can run either one of the following scripts individually; however, I can't seem to run both at the same time. Is this a limitation, or is the syntax incorrect?


select * from Bible where Book > 39 and Book < 67 ;

UPDATE Bible
SET Scripture = replace(Scripture,"Eglise","église") ;

Basically while in 'Execute SQL', I want to change all occurrences "Eglise" to "église" in the NT.
However, I can only select NT and not make changes; or, I can make changes but not only in NT.

Basic SQL isn't procedural which seems to be your expectation.

UPDATE provides a WHERE clause for limiting updates to specific rows.
 
Top