Google News
logo
MySQL - Interview Questions
What are some of the common MySQL commands?
ALTER : To alter a database or table
 
BACKUP : To back-up a table
 
\c : To cancel Input
 
CREATE : To create a database
 
DELETE : To delete a row from a table
 
DESCRIBE : To describe a table's columns
 
DROP : To delete a database or table
 
EXIT(ctrl+c) : To exit
 
GRANT : To change user privileges
 
HELP (\h, \?) : Display help
 
INSERT : Insert data
 
LOCK : Lock table(s)
 
QUIT(\q) : Same as EXIT
 
RENAME : Rename a Table
 
SHOW : List details about an object
 
SOURCE : Execute a file
 
STATUS (\s) : Display the current status
 
TRUNCATE : Empty a table
 
UNLOCK : Unlock table(s)
 
UPDATE : Update an existing record
 
USE : Use a database
 
 
 
Advertisement