Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Classification and summary of sql statements

2025-04-01 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Data definition language DDL

Create database db_name

Create table table_name (column_name data_type,...)

Create view view_name as select.

Create index on table_name (column_name,...)

Drop database db_name

Drop table table_name

Drop view view_name

Drop index table_name.index_name; (different sql dialects are different, this is the way sql server is written)

Alter table table_name

Add column_name data_type

Drop column_name

Change column_name new_column_name data_type,...

Modify column_name data_type,...

Data manipulation language DML

Select column_name from table_name where...

Update table_name set column_name=value where...

Insert into table_name (cloumn_name,...) Values (value1,...)

Delete from table_name where...

Data control language DCL: control permissions

Grant select,updat,insert,delete on table_name to 'user_name'@'host_name'

Revoke select,updat,insert,delete on table_name to 'user_name'@'host_name'

Transaction control language TCL: controlling transactions

Commit

Rollback

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report