Update Example queries for our application authored by Erlend Ydse's avatar Erlend Ydse
......@@ -6,24 +6,24 @@ Port: 33060
Database: employees
Example basic queries:
```
```sql
show tables;
```
```
```sql
describe titles;
```
```
```sql
select title from titles limit 20;
```
```
```sql
select emp_no from titles limit 20;
```
```
```sql
select emp_no, titles from titles limit 20;
```
Explain analyze:
```
```sql
EXPLAIN ANALYZE
SELECT *
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