Syntax error Write down the MySQL query which shows equality condition?

Write down the MySQL query which shows equality condition?

MySQL MySQLi Database

The binary equality operators compare their operands for strict equality or inequality. In MySQL, the equal-to-operator (=) returns 1 if both the operands have the same value otherwise returns 0. Following MySQL query show an equality condition −

mysql> Select tender_value From estimated_cost WHERE id = 3;

The above query shows an equality condition because the column id equates to the integer value.

mysql> Select tender_value From estimated_cost1 WHERE Name_company = 'Chd Ltd.';

The above query shows an equality condition because column Name_company equates to the string value.

Kumar Varma

Updated on: 2020-06-22T06:24:12+05:30

128 Views

Kickstart Your Career

Get certified by completing the course

Advertisements