In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.