Difference between revisions of "Column name with spaces"

Latest revision as of 13:21, 12 July 2012

SELECT a column whose name contains spaces?

schema:scott

You can access columns where the name contains a space.

DROP TABLE SpaceMonster

CREATE TABLE SpaceMonster([Account Balance] INT);
INSERT INTO SpaceMonster VALUES (42);
SELECT [Account Balance] FROM SpaceMonster

CREATE TABLE SpaceMonster(`Account Balance` INT);
INSERT INTO SpaceMonster VALUES (42);
SELECT `Account Balance` FROM SpaceMonster

CREATE TABLE SpaceMonster("Account Balance" INT);
INSERT INTO SpaceMonster VALUES (42);
SELECT "Account Balance" FROM SpaceMonster

Column name with spaces

NULL

@@ Line 1: / Line 1: @@
 SELECT a column whose name contains spaces?
 <div class='ht'>
+<div class=params>schema:scott</div>
 <div>
 You can access columns where the name contains a space.