MySQL online

 


This MySQL playground allows you to test SQL online. You can test MySQL queries online (MySQL 8.0).

It is an MySQL editor online, it does not require installation. It can help to make small tests easily in a few seconds.

/!\ The data (tables, index, ...) that you create are deleted after approximately 30 minutes of inactivity.

Autocomplete: Ctrl-space for autocomplete.

How to test MySQL queries online?

  • Enter your SQL query in the editor, finally click on "Run" to execute it. The query result will be displayed below the editor .

  • You can also run only one query entered in the editor. To do this, simply select it before clicking on "Run".

  • If you want to export the results in csv format, click on "Export".

Code editor

The sql queries entered in the editor are saved so that you will find them during your next visits.
Warning, this is a local backup in your browser, it can be deleted at any time.

How to share SQL snippet ?

You can share SQL snippet. Click on "Share snippet" to share your SQL code.
Your database will not be backed up, this only saves the editor code! This is useful for sharing SQL code.

How to dump MySQL database ?

You can dump MySQL database to SQL file. Click on "Database > Dump DB to SQL" to export your database.


About MySQL tester

MySQL is an open-source relational database, and is also available under proprietary licenses. MySQL is used by many database-driven web applications, and also used by many popular websites!

This small tool allows you to execute queries. You can test the queries with a syntax specific to Mysql.

You can quickly test table structures, and if you are satisfied with the result, you can export your database to SQL format.

Your requests pass through the network, avoid playing with production data.


Export results to CSV

Separator
NULL string
Header
Save and Share SQL snippet
Save SQL code in order to share it.
Your database will not be backed up, this only saves the editor code!
Be careful, the data will be accessible to everyone, please do not save sensitive data.
Save SQL snippet
Your SQL snippet has been permanently saved and you (or anybody) can access with this link:
Password
Choice a password to modify/delete this SQL snippet later Enter password to modify this SQL snippet. Enter password to delete this SQL snippet. Enter the new password for the fork.
You can report a bug or give feedback by adding a comment (below) or by clicking "Contact me" link (at the top right hand corner of the page).

Comments




James-2020-10-22 13:11
REFERENCES command denied to user ''@'localhost' for table 'table_name'

Looks like some permissions need to be updated before we can test out foreign keys.


Cyril (Admin)-2020-10-22 13:25
Hello James, it is fixed, foreign key creation now works :)


Mariana-2020-11-03 12:43
Hallo,
I have problem with:

select top (5)
from....

The error is: execute command denied to user ''@'localhost' for routine 'top'


Cyril (Admin)-2020-11-03 12:58
Hello,

top is not supported by MySQL. You can use LIMIT:

Select * from MyTable Limit 3


Mariana-2020-11-03 13:13
ok