Create Example queries for our application authored by Charlotte Maigull Söderström's avatar Charlotte Maigull Söderström
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
;
```