QUERY:1.How we can see existing database in mysql.



QUERY:2.How we can create database.



QUERY:3.How we can delete a database.



QUERY:4.How we can use an existing database.



QUERY:5.How we can create table in the database.



QUERY:6.How we can see the structure of existing table.



QUERY:7.How we can delete a table.



QUERY:8.How we can insert data in the table.



QUERY:9.How we can delete all the data of the table.



QUERY:10.To delete all the rows from the table we can use a DDL command also.



QUERY:11.How we can update the data of the table.



QUERY:12.How we can select and extract data from table (all column & all rows).



QUERY:13.To see selective column of the table (specific column,all rows).



QUERY:14.Find the record of the student whose roll in(1,3,4).



QUERY:15.Find out the record of thr student whose name is start with A.



QUERY:16.To create a table from another table we will use the create command with select command.



QUERY:17.How we can sort the data of table.



QUERY:18.Find out the name of the student who is having maximum marks.



QUERY:19.How we ccan see existing tables in database.



QUERY:20. Find the record of the student table whose name contain null values.