Marek at 13:21, 12 July 2012

2012-07-12T13:21:00Z

Marek: Created page with "SELECT a column whose name contains spaces?

You can access columns where the name contains a space.
DROP TABLE Spac..."

2012-07-11T12:14:58Z

Created page with "SELECT a column whose name contains spaces? <div class='ht'> <div> You can access columns where the name contains a space. </div> <source lang=sql class='tidy'>DROP TABLE Spac..."

New page

SELECT a column whose name contains spaces?
<div class='ht'>
<div>
You can access columns where the name contains a space.
</div>
<source lang=sql class='tidy'>DROP TABLE SpaceMonster
</source>
<source lang='sql' class='def e-access'>CREATE TABLE SpaceMonster([Account Balance] INT);
INSERT INTO SpaceMonster VALUES (42);
SELECT [Account Balance] FROM SpaceMonster</source>
<source lang='sql' class='def e-mysql'>CREATE TABLE SpaceMonster(`Account Balance` INT);
INSERT INTO SpaceMonster VALUES (42);
SELECT `Account Balance` FROM SpaceMonster</source>
<source lang='sql' class='def'>CREATE TABLE SpaceMonster("Account Balance" INT);
INSERT INTO SpaceMonster VALUES (42);
SELECT "Account Balance" FROM SpaceMonster
</source>
<div class="ecomm e-access" style="display: none">Use square brackets.</div>
<div class="ecomm e-sqlserver" style="display: none">You can use square brackets or double quotes.</div>
<div class="ecomm e-mysql" style="display: none">Use back ticks.</div>
</div>
{{SELECT Ref}}

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

Column name with spaces - Revision history

Marek at 13:21, 12 July 2012

Marek: Created page with "SELECT a column whose name contains spaces? You can access columns where the name contains a space. DROP TABLE Spac..."

Marek: Created page with "SELECT a column whose name contains spaces?

You can access columns where the name contains a space.
DROP TABLE Spac..."