• Error in my SQL syntax on SQL Fiddle 2018-10-31

    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: "You

    Tags: mysql, sql, sqlfiddle
  • How to join tables so even rows with no matches are included? 2014-08-20

    I'm trying to join persons to shirts table in the result displaying all persons and shirts that are in color blue. Here's my persons: ID NAME 1 Antonio Paz 2 Lilliana Angelovska 3 Michael SpringRoll 4 Poor dude And shirts: ID STYLE COLOR OWNER 1 polo

    Tags: mysql, sql, sqlfiddle
  • MySQL error 150 with foreign keys 2014-02-26

    I have this issue using foreign keys on MySQL. I am new in the language, and I have read a lot of the official documentation but got nothing in clear. I also have checked other questions on this site about foreign keys but also didn't help me. I even

    Tags: database, mysql, sql, foreign keys, sqlfiddle
  • MSSQL join tables w bit 2013-06-11

    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 3 1 1 2 2 1 3 2 0 The first table is the user table with user informations

    Tags: sql server, sql server 2008, pivot, join, sqlfiddle
  • ORA-00933: SQL command not properly ended in insert command 2012-10-12

    The are many questions with this same title but I can't find an answer among those. What am I doing wrong? CREATE TABLE J (A integer) ; INSERT INTO J (A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10) ; The create alone works. The problem i

    Tags: oracle, sqlfiddle

Copyright (C) dskims.com, All Rights Reserved.

processed in 5.764 (s). 9 q(s)