Summary of Common Commands for Getting Started with MySQL Database Basics

mysql --help

      #mysql database management command Usage: mysql [OPTIONS] [database]

      #Syntax format --help #View help document --auto-rehash

      #Auto-completion function -A, --no-auto-rehash

      #No need for automatic completion -B, --batch

    #Do not use history file, disable interaction --character-sets-dir=name

     #Character set installation directory -C, --compress

 #Compression when the client and server transmit information-#--debug[=#]

     #Call function -D, --database=name

     #Use database --default-character-set=name

     #Set the default character set -e, --execute=name

     #Execute sql statement -E, --vertical

    #Vertical print output information -f, --force

    #Skip the error and execute the following command -G, --named-commands

    #Print the query results by column -i, --ignore-spaces

    #Ignore spaces -h, --host=name

     #Set the address and IP of the connection server

--line-numbers

    #Show the line number with error -L, --skip-line-numbers

    #Ignore the line number with error -n, --unbuffered

    #Refresh the cache after each SQL execution --column-names

    #Display column information when querying -N, --skip-column-names

    #Do not display column information -p, --password[=name]

    #Enter password information -P, --port=#

    #Set port information --prompt=name

    #Set mysql prompt --protocol=name

    #Set the usage protocol -s, --silent

   # Output line by line, tab interval -S, --socket=name

   #Connect to the server using socket file -t, --table

   #Output in table format -u, --user=name

   #Username to connect to the server -v, --verbose

   #Print the command executed by sql -V, --version

   #Output version information -w, --wait

   #Time to wait for the server to restart after shutdown --connect-timeout=#

   #Time to wait before connecting --max-allowed-packet=#

#The maximum length of packets sent and received by the server --show-warnings

  #Display warning message

mysqldump --help

#mysql database backup command (logical backup)

Usage: mysqldump [OPTIONS] database [tables]

mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]

mysqldump [OPTIONS] --all-databases [OPTIONS]

     #Backup command format --print-defaults

   #Print the default program parameter list --no-defaults

  #Do not output default option parameters --defaults-file=#

  #Set the specified option parameter file -A, --all-databases

  #All databases --add-drop-database

#Add the drop database statement before creating data --add-locks

#Add lock tables before exporting each table and unlock tables afterwards

--character-sets-dir

  #Character set file directory --compact

  #Export less output information -B --databases

#Specify database --debug-info

# Output debugging information and exit --default-character-set

#Set the default character set, the default is utf8

--dump-slave

#Append the main binlog location and file name to the exported data file --events,-E

  #Backup event information --flush-logs,-F

  #Refresh log after backup -p, --password[=name]

  #Connect to database password -P, --port=#

  #Set port information -S, --socket=name

  #Connect to the server using the socket file -V, --version

  #Output version information -u, --user=name

  #Username to connect to the server

mysqlbinlog --help

#View the information recorded in mysql binlog log file Usage: mysqlbinlog [options] log-files

   #Syntax format --character-sets-dir=name

    #Specify the character set file directory -d, --database=name

    #View the log file of the specified database -h, --host=name

    #View the log file on the specified host --start-position=953

      #Starting pos point --stop-position=1437

      #End pos point --start-datetime=

      #Starting time point --stop-datetime=

      #End time point --database=

      #Specify to restore only the database