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

推荐订阅源

J
Java Code Geeks
博客园 - 司徒正美
博客园 - 【当耐特】
爱范儿
爱范儿
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
IT之家
IT之家
人人都是产品经理
人人都是产品经理
雷峰网
雷峰网
酷 壳 – CoolShell
酷 壳 – CoolShell
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
大猫的无限游戏
大猫的无限游戏
月光博客
月光博客
宝玉的分享
宝玉的分享
V
V2EX
S
SegmentFault 最新的问题
V
Visual Studio Blog
阮一峰的网络日志
阮一峰的网络日志
Martin Fowler
Martin Fowler
Jina AI
Jina AI
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
博客园_首页
L
LangChain Blog
D
Docker
腾讯CDC

博客园 - 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