The Most Important mysql Commands : Command « Introduction « MySQL Tutorial






  1. MySQL Tutorial
  2. Introduction
  3. Command
AbbreviationCommandInterpretation
\cclearterminates input of command.
\hhelpdisplays a list of commands.
\qexit or quitends mysql.
\sstatusshows status information on the MySQL server.
\T [f]tee [filename]logs all input and output into the specified file.
\tnoteeends tee. The logging can be resumed at any time with tee or \T.
\u dbuse databasemakes the specified database the default.
\. fnsource filenameexecutes the SQL commands contained in the given file. The commands must be separated by semicolons.


1.2.Command
1.2.1.You can enter multiple statements on a single line and end each one with a semicolon:
1.2.2.A simple multiple-line statement.
1.2.3.Prompts and their meaning
1.2.4.To cancel the command: type the '\c' command
1.2.5.The Most Important mysql Commands