Run the command without specifying a format to Tables, columns that auto-complete when you are typing.Įxecutes the SQL commands from the named file.ĭisplays status information about the client machine, server, andĮxecutes a shell command and outputs the results.Ĭhange the output format. Refreshes the cached auto-completion data. See the pager section of the documentation.Ĭhange the prompt format. Specify a command that will be used as the pager. For more information, see theĮnable the use of a pager for outputting query results. For moreĭisables the output to the tee file. Will be set as the default database for your connection.ĭisplay a help message listing mycli's commands.ĭisable the use of pager software for outputting query results. You can optionally supply a database name that Toggle whether or not the time it takes to execute a statement is displayed Use -o to overwrite any existing file content. Output the next query's results to an output file. List the databases on the MySQL server host. See Favorite Queries for more information. Favorite queries support shell-style parameter They can be passed to the query after the name, e.g., \f users_by_name If the favorite query requires parameters, If this is entered without a current query, it will populate the editor Įdit the current statement with an editor (uses the environment variable $EDITOR). The \dt commands are equivalent to running SHOW TABLES, SHOW COLUMNS FROM The optional + verbose indicator can be used to toggle whether or not the CREATE TABLE statement for the table is shown. List the tables in the default database (when used without any parameters).ĭescribe a table (when passed a parameter). This is used instead of a semicolon terminator, e.g. Send the current statement to the server and display the results vertically. Commands may be followed by an optional semicolon. Most commands have a long and short form. | | watch | watch query | Executes the query every seconds ( by default 5 ). | | use | \ u | Change to a new database. | | tee | tee filename | Append all results to an output file ( overwrite using - o ). | | tableformat | \ T | Change the table format used to output results. | | system | system | Execute a system shell commmand. | | status | \ s | Get status information from the server. | | rehash | \# | Refresh auto - completions. | | notee | notee | Stop writing results to an output file. | | nopager | \ n | Disable pager, print to stdout. | | connect | \ r | Reconnect to the database. | | \ timing | \ t | Toggle timing of commands. | | \ once | \ o filename | Append next result to an output file ( overwrite using - o ). | | \ fs | \ fs name query | Save a favorite query. | | \ fd | \ fd | Delete a favorite query. | | \ f | \ f ] | List or execute favorite queries. | | \ e | \ e | Edit command with editor ( uses $ EDITOR ). | | \ dt | \ dt | List or describe tables. This product does not contain phthalates and sulphites.Mycli > help + -+-+-+ | Command | Shortcut | Description | + -+-+-+ | \ G | \ G | Display current query results vertically. Aqua, Glycerin, Caprylic/Capric triglyceride, Squalane, Tapioca starch, Caprylyl methicone, Polymethylsilsesquioxane, Dimethicone, Butyrospermum parkii butter, Pentaerythrityl distearate, Vinyl Dimethicone/Methicone Silsesquioxane Crosspolymer, HDI/Trimethylol hexyllactone crosspolymer, Cetyl alcohol, Glyceryl stearate, Acetyl glucosamine, Dipalmitoyl hydroxyproline, Phytosteryl / Octyldodecyl Lauroyl Glutamate, Acetyl tetrapeptide-2, N-Hydroxysuccinimide, Palmitoyl oligopeptide, Palmitoyl tetrapeptide-7, Centella asiatica leaf extract, Tocotrienols, Ammonium acryloyldimethyltaurate/VP copolymer, Caprylyl glycol, Ceteth-20, Chlorphenesin, Chrysin, Citric acid, Dimethicone/Vinyl dimethicone crosspolymer, Glyceryl behenate, Glyceryl dibehenate, Mica, PEG-75 stearate, Pentaerythrityl tetra-di-t-butyl hydroxyhydrocinnamate, Phenoxyethanol, Potassium sorbate, Sodium hydroxide, Rosmarinus officinalis leaf extract, Steareth-20, Titanium dioxide, Tribehenin, Trisodium ethylenediamine disuccinate, Xanthan gum.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |