SQL
zoo.net
SELECT a column whose name contains spaces?
SQLite
DB2
Ingres
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
MySQL
You can access columns where the name contains a space.
Run the
tidy
code silently
CREATE TABLE SpaceMonster(`Account Balance` INT); INSERT INTO SpaceMonster VALUES (42); SELECT `Account Balance` FROM SpaceMonster
Specific to MySQL
Use back ticks.
Related links:
SELECT
Concatenate two or more fields.
Make union between different tables to build one single view or request?
Use 'like' in a sql select statement
How to build a statement on a word with an Apostrophe such as WHERE name='Tom's Book'
Full text search
Display a column name for an aggregate function.
How do you use Equi Join to join two tables with the same name.
Use SELECT for a column whose name contains spaces.
use NULL