MYSQL basic Commands

A MySQL command line tool (view Help---, or-? )

1) MySQL

MySQL is a simple SQL shell (with the GNU ReadLine feature). It supports both interactive and non-interactive use. When used interactively, the query results are in the ASCII table format. When non-interactive (for example, as a filter) mode is used, the result is tab-break format. You can change the output format using command-line options. Use the--quick option if you experience problems due to large results and low memory. This forces MySQL to search for results from the server one line at a time, rather than retrieving the entire result set and having to save it to memory before it is displayed.
(MySQLD)

2) mysqladmin

Mysqladmin is a client program that performs administrative operations. You can use it to check the configuration and current state of the server, create and delete databases, and so on.

3) Mysqlbinlog

The binary log file generated by the server is written in binary format. To check these text-formatted files, you should use the Mysqlbinlog utility.

4) MySQLDump

The mysqldump client can be used to dump a database or collect a database for backup or to transfer data to another SQL Server. The dump contains SQL statements that create tables and/or Mount tables.

5) Mysqlimport

The Mysqlimport utility is a bulk loader that reads the contents of a text file into an existing table.

6) Mysqlshow

Mysqlshow, customers can be used to quickly find out which databases exist, the tables in the database, the columns in the table, or the indexes.

7) perror

Perror prints its descriptive information for the system error code or the storage engine (table handling) error code.

8) Replace

The Replace utility can change the string in a file or standard input in a timely manner. It first uses a finite state machine to match long strings. The tool can be used to swap strings.

Two MySQL basic operations

1) MySQL51 Service stop and enable

net stop mysql51

net start mysql51

2) log in to MySQL management tool + CREATE DATABASE + Show all databases + DELETE database + launch MySQL management tool

3) Add user + display user + Change password + DELETE user

4) go to database + CREATE TABLE + Show database all tables + display table definition + Insert data into table + Show all contents of table + Delete all contents of table + DELETE table definition

5) Follow the value of a new record + add a column to the table + delete a column from the table

Finish!

MYSQL Basic Command