MySQL Online IDE & Code Editor for Technical Interviews
Running MySQL Server 8.0 - IntelliSense is not available
MySQL mode spins up a MySQL server with a default database with some sample data in it. The schema of the default database looks like:
employees projects
+---------------+---------+ +---------------+---------+
| id | int |<----+ +->| id | int |
| first_name | varchar | | | | title | varchar |
| last_name | varchar | | | | start_date | date |
| salary | int | | | | end_date | date |
| department_id | int |--+ | | | budget | int |
+---------------+---------+ | | | +---------------+---------+
| | |
departments | | | employees_projects
+---------------+---------+ | | | +---------------+---------+
| id | int |<-+ | +--| project_id | int |
| name | varchar | +-----| employee_id | int |
+---------------+---------+ +---------------+---------+
Code language: SQL (Structured Query Language) (sql)
The database is reset when the “Reset” button is clicked, or the pad switches to another language.
Output format
Having trouble seeing query results because of line wrapping? Try the \G option:
SELECT * from employees \G;
yields
Code language: SQL (Structured Query Language) (sql)*************************** 1. row *************************** id: 1 first_name: John last_name: Smith salary: 20000 department_id: 1 *************************** 2. row *************************** id: 2 first_name: Ava last_name: Muffinson salary: 10000 department_id: 5 ...