Changes
Page history
Create Example queries for our application
authored
Sep 16, 2020
by
Charlotte Maigull Söderström
Show whitespace changes
Inline
Side-by-side
Example-queries-for-our-application.md
0 → 100644
View page @
185d85e2
To log in and connect to a database:
Host: [blank]
User: root
Password: [Your own passord for mysql]
Port: 33060
Database: employees
Example basic queries:
```
show tables;
```
```
describe titles;
```
```
select title from titles limit 20;
```
```
select emp_no from titles limit 20;
```
```
select emp_no, titles from titles limit 20;
```
Explain analyze:
```
EXPLAIN ANALYZE
SELECT *
FROM
EMPLOYEES AS e
JOIN current_dept_emp AS de
ON e.emp_no=de.emp_no
JOIN departments d
ON de.dept_no=d.dept_no
;
```