How to select a column name with a space in MySQL

Smoothly sail with SQL syntax — the underscores way!

Universally embraced across the SQL family, underscores serve as the perfect substitute for spaces.

Replace the space — solidify with the underscore!

-- Spacing was too mainstream anyway ✌️
SELECT `First_Name` FROM users;


The avoidance of spaces in column names makes for smoother queries and neater syntax.

Redefining Columns — Evoke the power of ALTER TABLE!

Reign over your table definitions and transform them on your whim. Bless the columns with the cool new underscore attire and bid farewell to spaces.

-- Time to patch things up with ALTER TABLE 💪🎩
ALTER TABLE users CHANGE `First Name` First_Name VARCHAR(255);


Terminate the annoyances of spaces, maximise readability and improve portability.

Master the art of SQL Aliases

Breathe life into your SQL queries by making them more readable and elegant with the power of SQL aliases.

-- When life gives you column spaces, make aliases! 🍋🍹
SELECT `Business Name` AS BusinessName FROM clients;


When the elusive space cannot be avoided

External schemas such as those sourced from MS Access may not always abide by your strict no-spaces policy. The impending collision between such schemas and your MySQL syntax can be avoided with specific strategies.

Seek the strength of Search-And-Replace

Your output data carries evidence of previous columns with spaces? Worry not, a simple search-and-replace strategy in your favourite programming language bathes these column names in a new light.

# Python to the rescue of MySQL! 🐍
column_names = [col.replace(" ", "_") for col in database_column_names]


Syntax variations — Know thy DBMS

Database Management Systems are capricious creatures and each have their own preferences. While MySQL envelops spaces in backticks, MS Access, preferring the formal attire, encloses them in square brackets:

-- As they say, "When in Rome, do as the Romans do!" 🏛️
# MySQL syntax
SELECT `Business Name` FROM clients;
# MS Access syntax
SELECT [Business Name] FROM clients;


Let the true syntax shine

The Power of Backticks : Unlock MySQL's full potential

When handling MySQL queries with spaced columns, backticks (`) come to your rescue effortlessly interpreting the full column name. Their presence ensures clarity in syntax and prevents misinterpretations.

Prioritise performance — say no to spaces

With the privilege of designing your own schema, avoid complex column names. Not only do they demand backticks for proper interpretation but they also may slow down the DBMS's parsing process. The simplicity of an underscore can greatly improve the efficiency of query executions.

The long game — Future-proofing your database

A stitch in time saves nine. Incorporating the underscore practice in naming conventions today could save countless hours of debugging in the future as your database evolves in both complexity and size.