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

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

• Related Questions & Answers
• Problem using the column name 'from' in a MySQL query?
• Does using SERIAL as column name already includes 'NOT NULL' in MySQL?
• How to use wildcards like $ ('#name*'), $ ('#name%') in jQuery selectors?
• How to make numbers 'human readable' in MySQL?
• MySQL query to select ENUM('M', 'F') as 'Male' or 'Female'?
• How to make 'Paneer' at home?
• Converting date from 'dd/mm/yyyy' to 'yyyymmdd' in MySQL
• MySQL where column = 'x, y, z'?
• How to DROP a database in MySQL with character '?' in its name?
• Update 'a' record with 'b' and 'b' with 'a' in a MySQL column (swap) with only 'a' and 'b' values?
• How to easily 'create table from view' syntax in MySQL?
• How to delete '\\' entry in MySQL?
• Why can't we use column name “desc” in MySQL?
• Program to find number of string we can make where 'a' can be 'a' or 'b', and 'b' remains 'b'in Python
• How to get all collections where collection name like '%2015%'?