- 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
Can we use backticks with column value in MySQL?
You cannot use backticks with column value. For this, use only table name or column name. If you use backtick with column value then MySQL will give the following error message:
ERROR 1054 (42S22): Unknown column '191.23.41.10' in 'where clause'
Let us first create a table:
mysql> create table DemoTable6 ( SystemIPAddress varchar(200) ); Query OK, 0 rows affected (0.46 sec)
Following is the query to insert some records in the table using insert command:
mysql> insert into DemoTable values('192.68.1.0');
Query OK, 1 row affected (0.19 sec)
mysql> insert into DemoTable values('191.23.41.10');
Query OK, 1 row affected (0.12 sec)Now you can display specific record from the table using select statement:
mysql> select *from DemoTable where SystemIPAddress=`191.23.41.10`;
This will produce the following output i.e. an error since we used backtick with column value:
ERROR 1054 (42S22): Unknown column '191.23.41.10' in 'where clause'
Let us see the correct way to display the same record:
mysql> select *from DemoTable where SystemIPAddress='191.23.41.10';
This will produce the following output:
+-----------------+ | SystemIPAddress | +-----------------+ | 191.23.41.10 | +-----------------+ 1 row in set (0.00 sec)
Updated on 30-Jul-2019 22:30:25
- Related Questions & Answers
- Can we use current_date() for table with column timestamp default in MySQL?
- How can we use MySQL EXPORT_SET() function with column of a table?
- Can we use str_replace in MySQL?
- How can we use MySQL POWER() function with the column’s data values?
- How can we create MySQL views with column list?
- How can we use MySQL function STR_TO_DATE(Column, ‘%input_format’)?
- Can we use MySQL keyword as alias name for a column?
- How can we use SIGNAL statement with MySQL triggers?
- Can we use IFNULL along with MySQL ORDER BY?
- Can we use “rank” as column name with MySQL8?
- Can we use reserved word ‘index’ as MySQL column name?
- How can we combine ROW selection with COLUMN selection in MySQL?
- Why can't we use column name “desc” in MySQL?
- How can we use MySQL INSTR() function with WHERE clause?
- How can we use MySQL SUM() function with HAVING clause?
Advertisements