Ocean Base console
SQL
A read-only query and its rows.
SQL
Statements run in one transaction. Read mode refuses writes; no DDL (change the schema instead).
Query
rows_read 3 · rows_written 1
SELECT name, score FROM leads WHERE note = 'a;b'
1 rows · rows_read 2 · rows_written 0
| name | score |
|---|---|
| Ada | 72 |
UPDATE leads SET score = 1 WHERE id = 2
0 rows · rows_read 1 · rows_written 1
| No rows. |