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

推荐订阅源

Recent Announcements
Recent Announcements
爱范儿
爱范儿
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
宝玉的分享
宝玉的分享
T
Tailwind CSS Blog
博客园_首页
IT之家
IT之家
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
博客园 - 三生石上(FineUI控件)
有赞技术团队
有赞技术团队
大猫的无限游戏
大猫的无限游戏
雷峰网
雷峰网
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
博客园 - 司徒正美
WordPress大学
WordPress大学
Last Week in AI
Last Week in AI
人人都是产品经理
人人都是产品经理
Jina AI
Jina AI
月光博客
月光博客
小众软件
小众软件
S
SegmentFault 最新的问题
量子位
阮一峰的网络日志
阮一峰的网络日志
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知

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