木小鱼的笔记

技术之海,顺势者昌;看问题,要看思路与问题实质

SQL Learning Tip 5

1. The constraints include: NOT NULL, primary key, foreign key, Unqiue2. A check constraint restricts what values you can insert into a column. It us...

2008-07-09 03:02:00

阅读数:634

评论数:0

SQL Learning Tip 4

1. select some_column from table where column1 = (subquery)   subquery will return a column value in <>   Notice:    a. If a subquery is used a...

2008-07-08 08:55:00

阅读数:598

评论数:0

SQL Learning Tip 3

1. DataBase Schema  A representation of all the structures, such as table and columns, in your database, along with how they connect, is known  as Sc...

2008-07-08 07:28:00

阅读数:584

评论数:0

SQL Learning Tip2

1. alter table talbe_name add column column_name data_type (First/Before/Last/After/Fifth) (column_name)   Comments: set the new column in a certain ...

2008-07-02 08:52:00

阅读数:574

评论数:0

SQL Learning Tip

1.  create database; use database; 2. create table tablename(columnName columnType,...);3. desc table/drop table tablename;4. datatype:  int, dec(num...

2008-07-02 05:36:00

阅读数:569

评论数:0

提示
确定要删除当前文章?
取消 删除
关闭
关闭