List of all MySQL commands:Note that all text commands must be first on line and end with ';'? (\?) Synonym for `help'.clear (\c) Clear the current input statement.connect (\r) Reconnect to the server. Optional arguments are db and host.delimiter (\d) Set statement delimiter.edit ...
Command-Line Format --tls-version versions Type String Default Value A comma-separated (",") list of TLS versions to request, if SSL is enabled. --ssl-ca file_path Command-Line Format --ssl-ca file_path Type String Default Value Path to the SSL CA file to verify a server's ...
4.5.1 mysql — The MySQL Command-Line Client 4.5.1.1 mysql Client Options 4.5.1.2 mysql Client Commands 4.5.1.3 mysql Client Logging 4.5.1.4 mysql Client Server-Side Help 4.5.1.5 Executing SQL Statements from a Text File 4.5.1.6 mysql Client Tips...
Any long option that may be given on the command line when running a MySQL program can be given in an option file as well. To get the list of available options for a program, run it with the--helpoption. (Formysqld, use--verboseand--help.) The syntax for specifying options in an ...
line. WARNING: option deprecated; use --disable-named-commands instead.*/ -i, --ignore-spaces //忽视函数名后面的空格. --local-infile //启动/禁用 LOAD DATA LOCAL INFILE. -b, --no-beep //sql错误时,禁止嘟的一声 -h, --host=name //设置连接的服务器名或者Ip ...
[root@lhrmgr60 /]# mysql -uroot -plhr -hrw-mysql-mgr-server-lhr.service.consul -P3306 mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 54447 Server version: 8.0.22 ...
line. WARNING: option deprecated; use --disable-named-commands instead.*/ -i, --ignore-spaces //忽视函数名后面的空格. --local-infile //启动/禁用 LOAD DATA LOCAL INFILE. -b, --no-beep //sql错误时,禁止嘟的一声 -h, --host=name //设置连接的服务器名或者Ip ...
Percona Server manual:http://www.percona.com/doc/percona-server/8.0/For the MySQL Reference Manual:http://dev.mysql.com/To buy Percona support,training,or other products,visit:https://www.percona.com/Listofall MySQL commands:Note that all text commands must be first on line and endwith';...
-G, --named-commands Enable named commands. Named commands mean this program's internal commands; see mysql> help . When enabled, the named commands can be used from any line of the query, otherwise only from the first line, before an enter. ...
that you issue to the server to be executed. There is also a set of commands thatmysqlitself interprets. For a list of these commands, type help or \h at the mysql> prompt: mysql>helpList of all MySQL commands: Note that all text commands must be first on line and end with ';' ...