Need to practice SQL online? Check out our new, free Online SQL Editor. It’s perfect for students and anyone looking to sharpen their database skills.
DBHawk’s advanced features make it a top choice for professionals, too. Try it out today!
Try our free Online SQL editor
We developed this Online SQL Editor using DBHawk REST API. It lists all the tables from the MySQL and PostgreSQL databases. We are running free MySQL database with Aiven MySQL
It loads all the tables on the right side
When you click on the particular table name, it loads the SQL on the right side text area.
After that you can click on the Run SQL button and it will run the SQL query in the backed and will display the results.
You can also create a database table by writing SQL like below:
For example, below SQL will create the CHART table
CREATE TABLE `chart` ( `Year1` int(11) NOT NULL, `Value1` int(11) DEFAULT NULL, `Value2` int(11) DEFAULT NULL, `Value3` int(11) DEFAULT NULL, PRIMARY KEY (`Year1`)) ENGINE=InnoDB DEFAULT CHARSET=latin1
After creating a chart table, you should be able to insert the data:
INSERT INTO `chart`( `Year1`, `Value1`, `Value2`, `Value3`) VALUES (2021,100, 90,70) ;
This is just a sample application. DBHawk Online SQL Editor provides robust much more features including support for running any SQL queries, DBHawk Online SQL Editor provides robust much more features including support for running any SQL queries, auto completion, running database update, running various commands such as show schema, show tables, etc. upload saved SQL queries and execute it. Supported databases are Oracle, SQL Server, Postgres, Redshift, and many others. It’s user-friendly and collaborations features makes easy and pleasant to work with your team members.
Give it a try to this simple SQL Editor and sign up for our free trial to explore the full benefits of our Online SQL Editor. If you need any help regarding this, you can reach out to Datasparc support team by submitting the form.