how can you test for null values in a database? : Mysql dba
Answer / Aradhana Mishra
To check for NULL values in a MySQL database, you can use the IS NULL or IS NOT NULL operators in your SELECT statements. For example, to find all NULL values in a column called 'column_name', you would use: SELECT column_name FROM table_name WHERE column_name IS NULL;
| Is This Answer Correct ? | 0 Yes | 0 No |
what is JOIN? Give example & types of join?
14 Answers iMedia, Millennium, RAM Software, Satyam,
In which language mysql has been written?
What is the limit of mysql database?
What are the other commands to know the structure of a table using mysql commands except explain command?
Is number a datatype in mysql?
What is the purpose of using ifnull() function?
can you tell how can you display the maximum salary in sql? : Mysql dba
Why should I learn mysql?
What happens if you no create privilege in a database?
What are the 5 r's of managing behaviors?
How to drop an existing view in mysql?
What are the common mysql functions?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)