Changes
Page history
Update Example queries for our application
authored
Sep 16, 2020
by
Erlend Ydse
Show whitespace changes
Inline
Side-by-side
Example-queries-for-our-application.md
View page @
6ffac899
...
...
@@ -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