Common commands for MySQL terminal operations

This article mainly talks about the most commonly used terminal operation commands in database use. Let’s learn and understand them together!

1. Database command
1. Connect to the database
mysql -uroot -p password

2. Create database
create database library name;

3. Switch to the specified database
use library name;

4. Display the database list
show databases;

5. Display the database creation statement
show create database library name ;

6. Modify the database
alter database database name option;

7.Delete database
drop database database name;

2. Data table command
1. Create data table
create table data table name (field name 1 type modifier, field name 2 type modifier, field name 3 type modifier,...);
create table news(id int primary key auto_increment,
title varchar(50),author varchar(20),content text);

2. View the data table list
show tables;

3. View the data Table structure
desc data table name;

4. View data table creation table statement
show create table data table name;

5.Delete data table
drop table Data table name;

6. Modify data table
alter table data table name option;

7.Add new field
alter table data table nameadd column field name type modification Statement position;
alter table news add column newstime timestamp default current_timestamp after content;

8. Modify field definition
alter table data table name modify column new definition of field name;
alter table news modify column content longtext;

9. Modify field name and definition
alter table data table name change column old field name new field name new definition;

10. Delete field
alter table data table name drop column field name;

3. Record operation command
1. New record
insert into data table name (field 1, field 2,..., field n ) values(value 1, value 2,..., value n);
Note: The number and type of values ​​must be consistent with the number and type definition of the field list

2. View the record
select field list from data table name where condition order by field name desc limit m,n;
select * from news;
select * from news where id=10;
select * from news order by id desc limit 10;
Note: The select statement is the most powerful and complex query statement in SQL. It has seven clauses. Each clause can be omitted.
If it appears, it must appear in the correct position and order, and the order cannot be swapped. Sequence

3. Modify records
update data table name set field 1=value 1 and field 2=value 2 where condition;
update news set title='xxxxx' where id=1;

4. Delete records
delete from data table name where condition;
delete from news where id=10;

[Recommended course: mysql video tutorial 】

The above is the detailed content of Common commands for MySQL terminal operations. For more information, please follow other related articles on the PHP Chinese website!