Update Example queries for our application authored by Erlend Ydse's avatar Erlend Ydse
...@@ -6,24 +6,24 @@ Port: 33060 ...@@ -6,24 +6,24 @@ Port: 33060
Database: employees Database: employees
Example basic queries: Example basic queries:
``` ```sql
show tables; show tables;
``` ```
``` ```sql
describe titles; describe titles;
``` ```
``` ```sql
select title from titles limit 20; select title from titles limit 20;
``` ```
``` ```sql
select emp_no from titles limit 20; select emp_no from titles limit 20;
``` ```
``` ```sql
select emp_no, titles from titles limit 20; select emp_no, titles from titles limit 20;
``` ```
Explain analyze: Explain analyze:
``` ```sql
EXPLAIN ANALYZE EXPLAIN ANALYZE
SELECT * SELECT *
FROM FROM
...@@ -35,3 +35,9 @@ FROM ...@@ -35,3 +35,9 @@ FROM
; ;
``` ```
Heavy query example from Norvald's Github:
```sql
select sleep(2), st_buffer(point(0,0), 1000, st_buffer_strategy(point_circle, i)) from (values row(1), row(10), row(1000), row(10000), row(50000)) as ints(i);
```
\ No newline at end of file