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)