当前位置：网站首页>Use of MySQL command line client and common commands

Use of MySQL command line client and common commands

2022-04-23 02:57:00 【Senior agent of Sarkozy】

Mysql Command Line Client It's an official client . I've been using it directly before Windows In the command prompt window, enter Mysql sentence , There seems to be no difference . But I reinstalled one and tried it .

install

MYSQL The folder comes with Installer, Select the corresponding computer version Mysql Server Download it .

To configure

Due to the installation directory and Mysql atypism , Missing configuration file my.ini Lead to Mysql Command Line Client Can't use at first . Put... Directly Mysql Inside my.ini Copied to the Mysql Server It's just in the directory .

Common commands

Actually in cmd Log in... In the window mysql The corresponding command prompt will also be given , But I didn't study it carefully at that time . Just borrow Mysql Command Line Client Take a chance to learn about common commands .

There are two different... In the start menu Mysql Command Line Client window , One of them supports Unicode , One does not support . After opening, you will be prompted to enter the login password , Log in and cmd The operations in the window are basically the same .

command effect
\h, ?, ? get help
\c Clear the previous input （ Use when the content is input incorrectly ）
\R modify The prompt style on the left before each command input （ Default ：‘mysql>’）
? Commands that need help ; Displays help for this command （ Such as ：? show）
show databases; View all databases
use ‘ Database name ’; Select a database
（ After selecting a database ）show tables; View all tables in the current database
exit / quit sign out

版权声明
本文为[Senior agent of Sarkozy]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220647385118.html

边栏推荐

猜你喜欢

随机推荐