

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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)
- 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?
Advertisements