MySQL database basic commands (favorites), mysql commands

MySQL database basic commands (favorites), mysql commands

I sorted out the basic mysql commands and shared them.

# Start, stop, and restart MySql service mysql start | stop | restart/etc/init. d/mysql restart | start | restart # connect to MySQL database mysql-h127.0.0.1-uroot-p123456 # view MySQL version select version () # display database show databases # use database use [database] # select database () currently selected database () # show All tables show tablesshow tables like '% tableName %' # view the table structure show create table [tableName] # view the field desc [tableName] show columns from [tableName] # create database [db name]; # delete database drop database [db name] # view the user's current connection show processlist; # exit # Change password mysqladmin-u username-p old password new password # mysql backup mysqldump-u [username]-p [password] database> file # import source file

The above is a summary of the basic MySQL database commands provided by the mini-editor. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!