Question : I was wondering about this example CREATE TABLE cities ( city varchar(80) primary key, location point ); CREATE […]
MySQL load data infile ERROR 1064
Question : I am using MySQL version 5.5 and I am trying to use load data infile and I am […]
Converting old SQL Server outer join syntax
Question : I’m a Power Builder (PB) developer. I’ve migrated PB from 10 .5 to 12.5, and now I need […]
I’m trying to use a variable in Oracle PL/SQL, but I’m getting an error. What’s wrong here?
Question : I come from an SQL Server background and I’m trying to figure out how to use Oracle PL/SQL […]
Incorrect syntax near the keyword ‘WHERE’ – SQL Server 2014
Question : The error I get is Incorrect syntax near the keyword ‘WHERE’. Script: SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER […]
Why can’t I call my UDF directly? Why do I need to qualify it 3 levels deep?
Question : I just created a UDF and testing it I found only works when I use this syntax SELECT […]
PSQL cte delete seem have have ambiguity when select same column from delete table
Question : Both these two sql can be execute , the first one delete all , the second one is […]
How to create a temporary table using VALUES in PostgreSQL
Question : I am learning PostgreSQL and trying to figure out how to create a temporary table or a WITH […]
Why is “INSERT INTO table;” a syntax error?
Question : I have this: CREATE TABLE people ( id bigserial, timestamp timestamptz DEFAULT now() NOT NULL, PRIMARY KEY (id) […]
Why can’t I create a index using column definition in MySQL?
Question : Consider the following create table syntax CREATE TABLE test1 (f1 int primary key, f2 int, unique key(f2)); I […]