Informatics Practices
The Doc_name Column of a table Hospital is given below :
| Doc_name |
|---|
| Avinash |
| Hariharan |
| Vinayak |
| Deepak |
| Sanjeev |
Based on the information, find the output of the following queries :
(i) SELECT docname FROM HOSPITAL WHERE Docname like "%v";
(ii) SELECT docname FROM HOSPITAL WHERE docname like "%e%";
Answer
(i) SELECT doc_name FROM HOSPITAL WHERE Doc_name like "%v";
+----------+
| doc_name |
+----------+
| Sanjeev |
+----------+
Working
The query SELECT doc_name FROM HOSPITAL WHERE Doc_name like "%v"; selects the doc_name from the HOSPITAL table where the Doc_name column ends with the letter "v" using the LIKE operator with the "%" wildcard. This pattern matches any string where "v" is the last character, and any characters can precede it.
(ii) SELECT doc_name FROM HOSPITAL WHERE doc_name like "%e%";
+----------+
| doc_name |
+----------+
| Deepak |
| Sanjeev |
+----------+
Working
The query SELECT doc_name FROM HOSPITAL WHERE doc_name like "%e%"; selects the doc_name from the HOSPITAL table where the doc_name column contains the letter "e". This is achieved using the LIKE operator with the "%" wildcard before and after the letter "e", which matches any sequence of characters that have "e" in them.
Related Questions
Differentiate between DROP TABLE, DROP clause of ALTER TABLE.
Mr. Mittal is using a table with following columns :
Name, Class, Stream_Id, Stream_nameHe needs to display names of students who have not been assigned any stream or have been assigned stream_name that ends with "computers".
He wrote the following command, which did not give the desired result.
SELECT Name, Class FROM Students WHERE Stream_name = NULL OR Stream_name = "%computers" ;Help Mr. Mittal to run the query by removing the error and write correct query.
Sarthak, a student of class XII, created a table "Class". Grade is one of the columns of this table. To find the details of students whose Grades have not been entered, he wrote the following MySql query, which did not give the desired result:
SELECT * FROM Class WHERE Grade = "Null";Help Sarthak to run the query by removing the errors from the query and write the correct query.
What is the purpose of ALTER TABLE command ? Can you add new columns with constraints such as NOT NULL ? Give example to justify your answer.