---
title: "MySQL | CoderPad"
description: "Learn more about MySQL from CoderPad."
canonical: "https://coderpad.io/languages/mysql/"
last_modified: "2023-04-17 03:48:53"
---
# MySQL online IDE & code editor for technical interviews

Running MySQL Server 8.0 – IntelliSense is not available

### Experience the MySQL IDE yourself

See just how easy and intuitive CoderPad Interview is to use below.

[Launch the environment](https://embed.coderpad.io/sandbox?question_id=%20247190&use_question_button)

## 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](https://dev.mysql.com/doc/refman/5.5/en/mysql-tips.html#vertical-query-results):

`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)
```

## Need a better way to interview candidates?

[Request a demo](https://coderpad.io/sales/)