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, title 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
;
Heavy query example from Norvald's Github:
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);