1.

What are some of the common MySQL commands?

Answer»
CommandAction
ALTERTo alter a database or table
BACKUPTo back-up a table
\cTo cancel Input
CREATETo create a database
DELETETo delete a row from a table
DESCRIBETo describe a table's columns
DROPTo delete a database or table
EXIT(ctrl+c)To exit
GRANTTo CHANGE user privileges
HELP (\h, \?)DISPLAY help
INSERTInsert data
LOCKLock table(s)
QUIT(\q)Same as EXIT
RENAMERename a Table
SHOWList details about an object
SOURCEExecute a file
STATUS (\s)Display the current status
TRUNCATEEmpty a table
UNLOCKUnlock table(s)
UPDATEUpdate an EXISTING record
USEUse a database


Discussion

No Comment Found

Related InterviewSolutions