SQL
来源:互联网 发布:开淘宝店计划书 编辑:程序博客网 时间:2024/06/05 11:50
SQL is not case sensitive.
SQL DML and DDL
SQL can be divided into two parts: The Data Manipulation Language (DML) and the Data Definition Language (DDL).
The query and update commands form the DML part of SQL:
- SELECT - extracts data from a database
- UPDATE - updates data in a database
- DELETE - deletes data from a database
- INSERT INTO - inserts new data into a database
The DDL part of SQL permits database tables to be created or deleted. It also define indexes (keys), specify links between tables, and impose constraints between tables. The most important DDL statements in SQL are:
- CREATE DATABASE - creates a new database
- ALTER DATABASE - modifies a database
- CREATE TABLE - creates a new table
- ALTER TABLE - modifies a table
- DROP TABLE - deletes a table
- CREATE INDEX - creates an index (search key)
- DROP INDEX - deletes an index
- SQL
- SQL
- SQL
- sql
- sql
- SQL
- sql
- SQL (-)
- sql
- SQL
- SQL
- SQL
- sql
- sql
- sql
- sql
- SQL
- sql
- 浅析流媒体列表播放(Playlist Streaming)
- JSTL标签项目中的使用
- Guy,Keep your hair on .Whatever will be ,will be.
- 用WCAT进行IIS压力测试 (转贴)
- 面向程序员的数据库访问性能优化法则
- SQL
- SQL学习
- 苦难是人生最大的财富
- WINCE FindFirstStore / FindNextStore查找存储器
- .net4.0开发支持MySql的Membership时遇到找不到MembershipProvider类的问题!
- 来了
- jsp中动态include与静态include的区别-面试题
- 内联函数 -- inline总结
- TAB放置界面底部