惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
Jina AI
Jina AI
博客园 - Franky
Apple Machine Learning Research
Apple Machine Learning Research
酷 壳 – CoolShell
酷 壳 – CoolShell
阮一峰的网络日志
阮一峰的网络日志
量子位
雷峰网
雷峰网
宝玉的分享
宝玉的分享
V
Visual Studio Blog
博客园_首页
小众软件
小众软件
The Cloudflare Blog
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
大猫的无限游戏
大猫的无限游戏
博客园 - 聂微东
S
SegmentFault 最新的问题
博客园 - 【当耐特】
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
博客园 - 叶小钗
月光博客
月光博客
博客园 - 三生石上(FineUI控件)
人人都是产品经理
人人都是产品经理
WordPress大学
WordPress大学

博客园 - asdfasdf

此站点不在更新,已转至 http://zwwon.cnblogs.com 从别的地方转来的 网址 Visual Modeling 那本书没看多少 CSS Essentials(2)-How to use CSS, CSS Essentials(1)-Instruction,Syntax XHTML Essitials(3)-Attribute XHTML Essential(2)- XHTML DTD,Vaidation,Modularization XHTML Essentials(1)-Introduction The SQL SELECT,WHERE Statement The alias "LM/W3SVC/1/Root/XX" already exists. Please choose a different alias Learn this books : Visual Modeling with Rational Rose 2000 and UNL Write,Speak and Think in English from now on! 怎么现在的软件都这样!! 安装CodeSmith Gmaill和MSN 8.0备忘 实例化带来的麻烦 逻辑运算符 乔迁新喜 常用网址--转
Introduction to SQL
asdfasdf · 2006-04-07 · via 博客园 - asdfasdf

1.What is SQL SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems. SQL statements are used to retrieve and update data in a database. 2.SQL Data Manipulation Language (DML) SQL (Structured Query Language) is a syntax for executing queries. But the SQL language also includes a syntax to update, insert, and delete records. These query and update commands together form the Data Manipulation Language (DML) part of SQL: SELECT - extracts data from a database table UPDATE - updates data in a database table DELETE - deletes data from a database table INSERT INTO - inserts new data into a database table 3.SQL Data Definition Language (DDL) The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also define indexes (keys), specify links between tables, and impose constraints between database tables. The most important DDL statements in SQL are: CREATE TABLE - creates a new database table ALTER TABLE - alters (changes) a database table DROP TABLE - deletes a database table CREATE INDEX - creates an index (search key) DROP INDEX - deletes an index