I want to be able to create simple tables and run SQL queries on them. I'm talking tables with fewer than 12 items. Is there an online tool to do this? This might seem crazy, but it'd really help as I go between 3-4 computers a day.
Example:
Cats
Cat Names | Age
Marsha | 5
Melon | 3
Select * from Cats where Age > 3
Marsha | 5
Obviously that's a very, very simple example ... but I'm looking more towards testing some trickier SQL statements.
Edit: Not doing support. Right now I'm doing training and presentations. Screen sharing is not an option.
#5) Jdoodle Online SQL Editor Jdoodle is an online tool to execute shortcode lines easily and securely. Its aim is to provide a platform to create new projects for shortcodes and easily execute them. It supports languages like PHP, Ruby, Python, and HTML, etc. It supports MongoDB and MySQL databases.
Online SQL Compiler: CREATE TABLE Wait File Owner DB Run Team Export Import SQL.BanD for Business Hint: click "Button Save" (Top-Right) CREATE TABLE
RazorSQL has a SQL Query Builder Tool that allows the user to visually build queries. You can choose the type of SQL statement you want to generate by selecting the columns and operations to be included.
SQL Fiddle is another top tool. If you look at this website, you will see that it is an open-source SQL editor which supports many different types of databases. The main purpose of this tool was to conduct easy online testing and sharing of problems and related solutions of the database.
Search “Online SQL Editor” in the search engine. Open the tool or editor which you would like to work on. But always keep in mind that using online SQL editors may vary according to their functionality. It is not that every online editor works in the same way.
try sql fiddle - it allows you to build your own schema and supports multiple vendors.
rextester supports Sql Server, Oracle, PostgreSQL and MySQL
I just found this tool today:
ideone
It lets you choose from a number of languages (including SQL), write your code and then execute it. Pretty cool
Thanks to FreeAsInBeer for pointing me towards it.
If you're interested in using Oracle, you could sign up for a free workspace at http://apex.oracle.com. That is intended to give you the ability to try out Oracle's Application Express (APEX) product but the APEX development environment (all web based) does have places where you can create tables, insert data, etc. This has the nice side effect of letting you persist the data over time. And, you may find that you enjoy using APEX to build web apps as well.
See steps of creating account on Apex here
http://www.oraclebin.com/2013/01/how-to-execute-sql-queries-online.html
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With