- 博客(5)
- 收藏
- 关注
原创 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 uses the same conditional as a where clause. SQL
2008-07-09 03:02:00 876
原创 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 as a column expression in a select statement, it can
2008-07-08 08:55:00 859
原创 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 Schema2. Foreign key a column in a table tha
2008-07-08 07:28:00 805
原创 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 position compared with "assigned column"2. alte
2008-07-02 08:52:00 837
原创 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,num), varchar(), char, blob, date, datetime.5. ins
2008-07-02 05:36:00 918
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人