How to make 'from' as column name in MySQL?

Use the backticks symbol to consider ‘from’ as column name since it is a reserved word. We will now create a table with from reserved word surrounded by backtick −

mysql> create table DemoTable1810
     (
     `from` varchar(20)
     );
Query OK, 0 rows affected (0.00 sec)

Insert some records in the table using insert command −

mysql> insert into DemoTable1810 values('US');
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1810 values('UK');
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1810 values('AUS');
Query OK, 1 row affected (0.00 sec)

Display all records from the table using select statement −

mysql> select `from` from DemoTable1810;

This will produce the following output −

+------+
| from |
+------+
| US   |
| UK   |
| AUS  |
+------+
3 rows in set (0.00 sec)

AmitDiwan

Updated on 24-Dec-2019 06:11:46

• Related Questions & Answers
• How to extract column name and type from MySQL?
• MySQL query to display columns name first name, last name as full name in a single column?
• Change the column name from StudentName to FirstName in MySQL?
• How to get column index from column name in Python Pandas?
• Rename column name in MySQL?
• Can we use MySQL keyword as alias name for a column?
• Can we use reserved word ‘index’ as MySQL column name?
• Wildcards in column name for MySQL?
• Display distinct column name in MySQL
• How to select ID column as null in MySQL?
• How to display column values as CSV in MySQL?
• How to select a column name with spaces in MySQL?
• How to find the name of a column in MySQL?
• How to make MySQL result set the same as specified?
• Select the table name as a column in a UNION select query with MySQL?