How to create table show example
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
How to show certain selected rows with the value "pcds".
How to delete a column and add a new column to database
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
Restore database (or database table) from backup.
How to dump a table from a database.
How to make a column bigger and delete unique from table.
How you will show all data from a table.
What is cold backup and hot backup (in case of oracle)?
What are the two major subsystems of system r?
What are cursors give different types of cursors?
What is cold backup (in case of oracle)?
What is hot backup (in case of oracle)?