SQLÓïÑÔ»ù±¾Óï¾ä½éÉÜ
±íµÄ½¨Á¢
¹ØϵÊý¾Ý¿âµÄÖ÷ÒªÌصãÖ®Ò»¾ÍÊÇÓñíµÄ·½Ê½×éÖ¯Êý¾Ý¡£±íÊÇSQLÓïÑÔ´æ·ÅÊý¾Ý¡¢²éÕÒÊý¾ÝÒÔ¼°¸üÐÂÊý¾ÝµÄ»ù±¾Êý¾Ý½á¹¹¡£ÔÚSQLÓïÑÔÖУ¬±íÓÐÑϸñµÄ¶¨Ò壬ËüÊÇÒ»ÖÖ¶þά±í£¬¶ÔÓÚÕâÖÖ±íÓÐÈçϹ涨£º
1)ÿһÕÅ±í¶¼ÓÐÒ»¸öÃû×Ö£¬Í¨³£³ÆΪ±íÃû»ò¹ØϵÃû¡£±íÃû±ØÐëÒÔ×Öĸ¿ªÍ·£¬×î´ó³¤¶ÈΪ30¸ö×Ö·û¡£
2)Ò»Õűí¿ÉÒÔÓÉÈô¸ÉÁÐ×é³É£¬ÁÐÃûΨһ£¬ÁÐÃûÒ²³Æ×÷ÊôÐÔÃû¡£
3)±íÖеÄÒ»ÐгÆΪһ¸öÔª×飬ËüÏ൱ÓÚÒ»Ìõ¼Ç¼¡£
4)ͬһÁеÄÊý¾Ý±ØÐë¾ßÓÐÏàͬµÄÊý¾ÝÀàÐÍ¡£
5)±íÖеÄÿһ¸öÁÐÖµ±ØÐëÊDz»¿É·Ö¸îµÄ»ù±¾Êý¾ÝÏî¡£
×¢Ò⣺µ±Óû§ÐèҪеÄÊý¾Ý½á¹¹»ò±í´æ·ÅÊý¾Ýʱ£¬Ê×ÏÈÒªÉú³ÉÒ»¸ö±í¡£
Óï·¨£º
CREATE TABLE ±íÃû [±íÔ¼Êø]
(ÁÐÃû1 Êý¾ÝÀàÐÍ [ȱʡֵ1£¬ÁÐÔ¼Êø1]
(ÁÐÃû2 Êý¾ÝÀàÐÍ [ȱʡֵ2£¬ÁÐÔ¼Êø2]
…
ÁÐÃûn Êý¾ÝÀàÐÍ [ȱʡֵn£¬ÁÐÔ¼Êøn]
[TABLESPACE ±í¿Õ¼äÃû³Æ]
[STORAGE (´æÖüµÄ×Ӿ䣩]
[ENABLE Ô¼ÊøÃû]
[DISABLE Ô¼ÊøÃû]
¡¡
²åÈëÊý¾Ý
¡¡
µ±Ò»¸ö±íн¨³Éʱ£¬ËüÀïÃæûÓÐÊý¾Ý£¬Í¨¹ýÏò±íÖÐǤÈëÊý¾Ý£¬½¨³É±íµÄʵÀý¡£
Óï¾ä¾ä·¨£º
INSERT INTO ±íÃû[(ÁÐÃû1,…)]
VALUES(Öµ1£¬Öµ2£¬…,Öµn)
[×Ó²éѯ]£»
¼ÙÉèÓÐÒ»ÕűíStudentÈçÏÂËùʾ£º
NO
NAME
AGE
1001
A
12
1002
B
14
½«ÐÂѧÉúEÔö¼Óµ½ÉϱíÖУ¬²¢°´ÕÕ±íµÄ½á¹¹½«ÐÅÏ¢Ìí¼ÓÍêÕû£¬ÐèÒªÈçÏÂÓï¾ä£º
INSERT INTO STUDENT VALUSE(1003, 'E',12);
¡¡
ÐÞ¸ÄÊý¾Ý
¶Ô±íÖÐÒÑÓÐÊý¾Ý½øÐÐÐ޸ģ¬Óï¾ä¾ä·¨£º
UPDATE ±íÃûSET ÁÐÃû1£½±í´ïʽ1£¬ÁÐÃû2£½±í´ïʽ2£¬…
WHERE Ìõ¼þ£»
ÀýÈ磺¶ÔϱíStudent
NO
NAME
AGE
1001
A
12
1002
B
14
½«BµÄÄê¼Í¸ÄΪ18£»Ó¦¸ÃÖ´ÐÐÒÔÏÂÓï¾ä£º
UPDATE STUDENT SET AGE=18 WHERE NAME='B';
¡¡
ɾ³ýÊý¾Ý
ɾ³ý±íÖÐÒÑÓÐÊý¾Ý£¬²»ÄÜɾ³ý²»´æÔÚµÄÊý¾Ý¡£
Óï¾ä¾ä·¨:
DELETE from ±íÃû WHERE Ìõ¼þ£»
ÀýÈ磺
¶ÔÏÂÃæStudent±í½øÐÐɾ³ý£¬ÒªÉ¾³ýÆäÖÐÄê¼ÍΪ12µÄѧÉú£»
NO
NAME
AGE
1001
A
12
1002
B
14
DELETE from STUDENT WHERE AGE£½12£»
±í½á¹¹µÄÐÞ¸Ä
ÔÚÒÑ´æÔڵıíÖÐÔö¼ÓÐÂÁУ¬Óï¾ä¾ä·¨£º
ALTER TABLE ±íÃû ADD(ÐÂÁÐÃû Êý¾ÝÀàÐÍ(³¤¶È))£»
ÀýÈ磺
ALTER TABLE STUDENT ADD (DEPARTMENT CHAR(8));
b.Ôö¼ÓÒÑÓÐÁеÄÊý¾ÝÀàÐÍ¡£
ÀýÈ磺
ALTER TABLE STUDENT MODIFY(NAME VARCHAR2(25));
¡¡
±íµÄɾ³ý
½«ÒѾ´æÔڵıíɾ³ý£¬Óï¾ä¾ä·¨:
&nb
Ïà¹ØÎĵµ£º
½«b±íÖÐcallerÁеÄÖµ²åÈëa±íÖÐcallÁÐÖС£
create table a
(
fid int,
call varchar(20),
age int
)
create table b
(
fid int,
caller varchar(20),
parentId int
)
select * from a
select * from b
insert into a values(1,null,19)
insert into a values(2,n ......
Ç°¶Îʱ¼ä×öÁËÒ»¸öÐéÄâ×éÖ¯µÄ´´½¨¡£Õâ¸öÐéÄâ×éÖ¯µÄ´´½¨ÊÇ´ÓÏÖÓеÄ×éÖ¯ÖжÁÈ¡Êý¾ÝÈ»ºó½øÐзÖÎö±£´æµ½ÐéÄâ×éÖ¯±íÖС£±£´æÖ®ºóдÈÕÖ¾·½±ãͬ²½µ½ÆäËüϵͳÖС£¹«Ë¾Ê¹ÓõÄÖ÷Òª¼¼ÊõÊÇSSH¡£ÓÉÓÚÊÇÐÂÈËûÓÐʲô¾Ñ飬¼Ó֮ʱ¼ä±È½Ï½ôÆÈ£¬×îºóʹÓÃÒ»°ãµÄÂ߼˼Ïëͨ¹ýµÝ¹éÔÚhibernateÏÂ˳Àû´´½¨ÁË¡£¿ÉÊÇ´ÓÏÖÓеÄ×éÖ¯Ö ......
¸Õ¸Õ°²×°µÄÊý¾Ý¿âϵͳ£¬°´ÕÕĬÈÏ°²×°µÄ»°£¬ºÜ¿ÉÄÜÔÚ½øÐÐÔ¶³ÌÁ¬½Óʱ±¨´í£¬Í¨³£ÊÇ´íÎó:"ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó) "ËÑMSDN£¬ÉÏÃæÓÐһƪ»úÆ÷·ÒëµÄÎÄÕ£¬ÊµÔÚÈÃÈËÄÑÒÔÃ÷°×£¬ÏÖÔÚ ......
1. ˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ£¬Ô´±íÃû£ºa£¬Ð±íÃû£ºb)
SQL: select * into b from a where 1<>1;
2. ˵Ã÷£º¿½±´±í(¿½±´Êý¾Ý£¬Ô´±íÃû£ºa£¬Ä¿±ê±íÃû£ºb)
SQL: insert into b(a, b, c) select d, e, f from b;
&nb ......