Mysql Interview Questions

1. how to do login in mysql with unix shell.
2. how you will Create a database on the mysql server with unix shell.
3. how to list or view all databases from the mysql server.
4. How Switch (select or use) to a database.
5. How To see all the tables from a database of mysql server.
6. How to see table's field formats or description of table.
7. How to delete a database from mysql server.
8. How we get Sum of column.
9. How to delete a table.
10. How you will Show all data from a table.
11. How to returns the columns and column information pertaining to the designated table.
12. How to Show certain selected rows with the value "pcds".
13. Use a regular expression to find records. Use "REGEXP BINARY" to force case-sensitivity. This finds any record beginning with r.
14. How you will Show unique records.
15. how we will Show selected records sorted in an ascending (asc) or descending (desc).
16. how to Return total number of rows.
17. How to Join tables on common columns.
18. How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
19. How to Change a users password from unix shell.
20. How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
21. How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
22. How to Set a root password if there is on root password.
23. How to Update a root password.
24. 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.
25. How to give user privilages for a db. Login as root. Switch to the MySQL db. Grant privs. Update privs.
26. How To update info already in a table and Delete a row(s) from a table.
27. How to Update database permissions/privilages.
28. How to Delete a column and Add a new column to database .
29. Change column name and Make a unique column so we get no dupes.
30. How to make a column bigger and Delete unique from table.
31. How to Load a CSV file into a table .
32. How to dump all databases for backup. Backup file is sql commands to recreate all db's.
33. How to dump one database for backup.
34. How to dump a table from a database.
35. Restore database (or database table) from backup.
36. How to Create Table show Example .