Sharing of commonly used MySQL commands

This article mainly introduces the knowledge points of MySQL for the Computer Level 2 Examination, and introduces commonly used MYSQL commands in detail, which has certain reference value. Interested friends can refer to

Computer Level 2 Examination MySQL Basics of knowledge points, commonly used MYSQL commands, as follows

Commonly used MYSQL commands (add computer secondary sites to favorites)

Start:

net start mySql;

Enter:

mysql -u root -p/mysql -h localhost -u root -p databaseName;

List database:

show databases;

Select database:

use databaseName;

List table:

show tables；

Create data table:

mysql> CREATE TABLE mytable (name VARCHAR(20), sex CHAR(1), 
　　-> birth DATE, birthaddr VARCHAR(20));

Display the attributes of the table columns:

show columns from tableName；

Modify the structure of the table:

DESCRIBE mytable;

Create the database:

source fileName.txt;

Match characters: You can use the wildcard character _ to represent any character, and % to represent any String;

Add a field:

alter table tabelName add column fieldName dateType;

Add multiple fields:

alter table tabelName add column fieldName1 dateType,add columns fieldName2 dateType;

Multi-line command input: Be careful not to break words; when inserting or changing data , the field string cannot be expanded into multiple lines, otherwise the hard return will be stored in the data;

Add an administrator account:

grant all on *.* to user@localhost identified by "password";

After each statement is entered, Add a semicolon ';' at the end, or add '\g';

Query time:

select now(　);

Query current user:

select user(　);

Query database version :

select version(　);

Query the currently used database:

select database(　);

The above is the detailed content of Sharing of commonly used MySQL commands. For more information, please follow other related articles on the PHP Chinese website!