sql語(yǔ)句分類(lèi)總結(jié)

發(fā)布時(shí)間：2020-07-25 04:19:48 來(lái)源：網(wǎng)絡(luò) 閱讀：423 作者：不死戰(zhàn)魂欄目：數(shù)據(jù)庫(kù)

數(shù)據(jù)定義語(yǔ)言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;（不同sql方言不同，這是sql server的寫(xiě)法）

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,...

數(shù)據(jù)操縱語(yǔ)言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 ...

數(shù)據(jù)控制語(yǔ)言DCL：控制權(quán)限

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';

事務(wù)控制語(yǔ)言TCL：控制事務(wù)

commit

rollback

向AI問(wèn)一下細(xì)節(jié)

猜你喜歡