Structured Query Language (Structured Query Language) is referred to as SQL. Structured Query Language is a database query and programming language used to access data, query, update and manage relationships. Database system;
sql statement is a language used to operate the database.
Program functions:
1. Create database
CREATE DATABASE database-name
2. Delete database
drop database dbname
3. Create new Table
create table tabname(col1 type1 [not null] [primary key],col2 type2 [not null],..)
4. Delete new table
drop table tabname
5. Add a column
Alter table tabname add column col type
6. Add primary key
Alter table tabname add primary key(col)
7. Delete primary key
Alter table tabname drop primary key(col)
8. Create index
create [unique] index idxname on tabname(col….)
9. Delete index
drop index idxname
10. Create view
create view viewname as select statement
11. Delete view
drop view viewname
The above is the detailed content of What is the function of sql statement?. For more information, please follow other related articles on the PHP Chinese website!