How to show all records starting with the letters 'sonia' and the phone number '9876543210'
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 cte? : Mysql dba
what is database white box testing? : Mysql dba
what is the default port for mysql server? : Mysql dba
can you tell the order of sql select statement? : Mysql dba