공부/DB
2012. 2. 22. 09:55
CREATE TABLE customer
(First_Name char(50),
Last_Name char(50),
Address char(50),
City char(50),
Country char(25),
Birth_Date date)
INSERT INTO Store_Information (store_name, Sales, Date)
SELECT store_name, Sales, Date
FROM Sales_Information
WHERE Year(Date) = 1998
http://sql.1keydata.com/kr/sql-create-table.php
(First_Name char(50),
Last_Name char(50),
Address char(50),
City char(50),
Country char(25),
Birth_Date date)
INSERT INTO Store_Information (store_name, Sales, Date)
SELECT store_name, Sales, Date
FROM Sales_Information
WHERE Year(Date) = 1998
http://sql.1keydata.com/kr/sql-create-table.php
'공부 > DB' 카테고리의 다른 글
| sql 문자열 정리 홈페이지 (0) | 2012.01.31 |
|---|---|
| 집합 쿼리(UNION, INTERSECT, MINUS) (0) | 2012.01.25 |
| [MYSQL] Identity - 오라클 시퀀스 (0) | 2012.01.05 |
| 각각 디비 시퀀스 생성 (0) | 2012.01.05 |
| [오라클 db]시퀀스 (0) | 2012.01.04 |