MySQL online IDE & code editor for technical interviews

Guidelines to use MySQL in this online IDE

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

*************************** 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
...Code language: SQL (Structured Query Language) (sql)