1.CREATE
INDEX Index-name
ON
table-name(attribute-name1,….)
ex.
CREATE INDEX PRO_INDEX
ON PRODUCT(PRODUCT_NAME);
2.DROP
INDEX Index-name
ex.
DROP INDEX PRO_INDEX ;
3.ADD
Attribute name
ex. ALTER TABLE Employee
ADD Tel CHAR( 10) ;
4.MODIFY Structure
ex. ALTER TABLE Employee
MODIFY ( EName
CHAR(35) );
5.DROP Attribute name
ex.
ALTER TABLE Employee
DROP Tel CHAR( 10) ;
6.SELECT
column_name /*
[column_name …]
FROM
table_name
WHERE expression เงื่อนไขเปรียบเทียบ expression
7.SELECT
column_name /*
[ , column_name …]
FROM
table_name
WHERE เงื่อนไขปฏิเสธ condition
8.SELECT
column_name /*
[ , column_name …]
FROM
table_name
WHERE expression IS [ NOT ] NULL
9.INSERT
INTO <table_name>
[( column 1 , column 2 , …)]
VALUES ( value 1 , value 2 , …
) ;
10.UPDATE <table_name>
SET < column1> [ , column 2 , …] =
<expression | sub query>
[WHERE
< condition> ] ;
ไม่มีความคิดเห็น:
แสดงความคิดเห็น