How to use mysql database

This article explains some basic operations of the MySQL database. I hope it will be useful to everyone.

Recommended courses: MySQL Tutorial.

1. Starting and shutting down the MySQL server

1. Start the MySQL server

Start-> Run Enter "cmd" and then enter the "net start MySQL" command at the command prompt.

2. Connect to the MySQL server

Enter the command: MySQL -uroot -h127.0.0.1 -p111 (-h127.0.0.1 depends on personal circumstances)

Note: The user name is "root", the MySQL database server address is "127.0.0.1", and the password is "111". There must be a space between the three.

3. Shut down the MySQL server

Start -> Run Enter "cmd", and then enter the "net stop MySQL" command at the command prompt.

2. Operating MySQL database

1. Create a database

create database 数据库名;

2. View the database

show databases;

3. Select the specified database

use 数据库名;

4. Delete the database

drop database 数据库名;

Note: Automatically delete the "C:/AppServ/MySQL/data" folder in the MySQL installation directory.

3. Operation of MySQL data table

1. Create table

create table 表名 （column_name column_type not null,...）;

Attribute description of create table statement

##column_name Field name Primary key Whether the column is the primary keycolumn_type Field type AUTO_INCREMNTWhether the column is automatically numberedNot null | null Whether the column is allowed to be empty ## After creating the data table, the corresponding table files ("table name.frm", "table name.MYD", "C:\AppServ\MySQL\data\database name\" are automatically created. "Table name.MYI")

Attribute	Description	Attribute	Description

2. View the tables in the database

show tables;

3. View all tables in the database

show tables;（前提是使用use database 数据库；）

4. View the data table structure

describe 表名;

5. Modify the data table structure

alter table 表名
　　add [column] create_definition [first | after column_name]　　//添加新字段
　　add primary key （index_col_name,...）　　//添加主码名称
　　alter [column] col_name {set default literal |rop default}　　//修改字段名称
　　change [column] old_col_name create_definition　　//修改字段名及类型
　　modify [column] create_definition　　//修改字段类型
　　drop [column] col_name　　//删除字段
　　drop primary key　　//删除主码
　　rename [as] new_tablename　　//更改表名
eg：alter table Admin_Info
　　　　drop A_Pwd,
　　　　rename as Admin_Info2;

6. Delete the specified data table

drop table 表名；

4. Manipulate MySQL data

1. Add table data

语法1：insert into 表名 values（值1，值2，...）（自增长的列应写null）
语法2：insert into 表名（字段1，字段2，...） values （值1，值2，...）
语法3：insert into 表名 set 字段1=值1，字段2=值2，...

2. Update table data

update 表名 set 字段1=值1 where 查询条件

If there are no query conditions, all data rows in the table will be modified.

3. Delete table data

delete from 表名 where 查询条件

If there are no query conditions, all data rows in the table will be deleted.

4. Query table data

select * from 表名；

5. Limit the number of query records

select * from 表名 limit[start] length

start: indicates which row of records to start outputting, 0 indicates the first row

The above is the detailed content of How to use mysql database. For more information, please follow other related articles on the PHP Chinese website!