Stack Overflow
Stack Overflow

Questions tagged [sqlfiddle]

A tool for easy online testing and sharing of database problems and their solutions.

SQLFiddle is a tool for easy online testing and sharing of database problems and their solutions. The project began in January 2012, and was built by Jake Feasel, a web developer originally from Anchorage (Alaska).

SQLFiddle currently supports scripts for the following database engines:

  • MySQL 5.5
  • MySQL 5.6
  • Oracle 11g R2
  • PostgreSQL 9.3
  • SQLite (WebSQL)
  • SQLite (SQL.js)
  • MS SQL Server 2014
  • MS SQL Server 2008

Related links:

140 questions
-2
votes
1 answer

Error in my SQL syntax on SQL Fiddle

I'm new to sql programming. For a computer science project I am trying to apply my knowledge of sql in some way. On SQL Fiddle, I am using the MySQL 5.6 database and I am having so much trouble building schema. This is what it keeps telling me:…
Armani Jackson
  • 11
  • 2
-2
votes
1 answer

MSSQL join tables w bit

I have three tables : 1) UserTable UserId UserName 1 Mike 2 John 3 Jennifer 2) FormName fID fName 1 edit 2 cafe 3 backoffice 3)User to form fId UserId Allowed(bit) 1 1 0 2 1 1 …
Burak Gazi
  • 535
  • 2
  • 7
  • 23
-3
votes
2 answers

MySQL query giving erroneous results because of the mode of only full group by

I have this unanswered question where I had this erroneous result query: SELECT t1.patient_id, CONVERT(aes_decrypt(t4.patient_name_en, :encKey) USING utf8mb4) as patient_name_en, min(t3.date_of_visit) as date_of_visit, …
alim1990
  • 4,656
  • 12
  • 67
  • 130
-3
votes
1 answer

New to SQL, Need to check schoolwork on Fiddle - Is my code correct?

CREATE TABLE Customer_Master ( customer_ID INTEGER(30) NOT NULL AUTO_INCREMENT, first_name VARCHAR(100) NOT NULL, last_name VARCHAR(100) NOT NULL, street_address VARCHAR(100) NOT NULL, apt INTEGER(9), city VARCHAR(30) NOT NULL, state…
kb2425
  • 1
  • 2
-3
votes
1 answer

Unable to Query Table with SQL Fiddle

I'm using SQL Fiddle, and I'm unable to run a simple query (SELECT * FROM CUSTOMER;) after building my schema with the code below. The only error I get is "Oops! Something went wrong. Try it again and if this keeps happening, email…
MysteriousMuffins
  • 15
  • 4
1 2 3
…
9
10