sql´óÈ«³¬Ïêϸ
SQL ÃüÁî
Õⲿ·Ö°üº¬ÄÇЩ PostgreSQL Ö§³ÖµÄ SQL ÃüÁîµÄÐÅÏ¢£®ÕâÀïµÄ "SQL" ¾ÍÊǸÃÓïÑÔͨ³£µÄº¬Ò壻 ÿÌõÃüÁîµÄÓë±ê×¼ÓйصļæÈÝÐÔµÄÐÅÏ¢¿ÉÒÔÔÚÏà¹ØµÄ²Î¿¼Ò³ÖÐÕÒµ½£®
Table of Contents
ABORT -- Í˳öµ±Ç°ÊÂÎñ
ALTER GROUP -- Ïò×éÖÐÔö¼ÓÓû§»ò´Ó×éÖÐɾ³ýÓû§
ALTER USER -- ¸Ä±äÊý¾Ý¿âÓû§Õʺţ®
ANALYZE -- ÊÕ¼¯ÓëÊý¾Ý¿âÓйصÄͳ¼Æ
BEGIN -- ¿ªÊ¼Ò»¸öÊÂÎñ¿é
CHECKPOINT -- Ç¿ÖÆÒ»¸öÊÂÎñÈÕÖ¾¼ì²éµã
CLOSE -- ¹Ø±ÕÒ»¸öÓαê
CLUSTER -- ¸ù¾ÝÒ»¸öË÷Òý¶Ôij¸ö±í¼¯´Ø
COMMENT -- ¶¨Òå»òÕ߸ıäÒ»¸ö¶ÔÏóµÄÆÀ×¢
COMMIT -- Ìá½»µ±Ç°ÊÂÎñ
COPY -- ÔÚ±íºÍÎļþÖ®¼ä¿½±´Êý¾Ý
CREATE AGGREGATE -- ¶¨ÒåÒ»¸öеľۼ¯º¯Êý
CREATE CONSTRAINT TRIGGER -- ¶¨ÒåÒ»¸öеÄÔ¼Êø´¥·¢Æ÷
CREATE DATABASE -- ´´½¨ÐÂÊý¾Ý¿â
CREATE FUNCTION -- ¶¨ÒåÒ»¸öк¯Êý
CREATE GROUP -- ¶¨ÒåÒ»¸öеÄÓû§×é
CREATE INDEX -- ¶¨ÒåÒ»¸öÐÂË÷Òý
CREATE LANGUAGE -- ¶¨ÒåÒ»ÖÖеĹý³ÌÓïÑÔ
CREATE OPERATOR -- ¶¨ÒåÒ»¸öеIJÙ×÷·û
CREATE RULE -- ¶¨ÒåÒ»¸öеÄÖØÐ´¹æÔò
CREATE SEQUENCE -- ´´½¨Ò»¸öеÄÐòÁз¢ÉúÆ÷
CREATE TABLE -- ¶¨ÒåÒ»¸öбí
CREATE TABLE AS -- ´ÓÒ»Ìõ²éѯµÄ½á¹ûÖд´½¨Ò»¸öбí
CREATE TRIGGER -- ¶¨ÒåÒ»¸öеĴ¥·¢Æ÷
CREATE TYPE -- ¶¨ÒåÒ»¸öеÄÊý¾ÝÀàÐÍ
CREATE USER -- ´´½¨Ò»¸öеÄÊý¾Ý¿âÓû§ÕÊ»§
CREATE VIEW -- ¶¨ÒåÒ»¸öÊÓͼ
DECLARE -- ¶¨ÒåÒ»¸öÓαê
DELETE -- ɾ³ýÒ»¸ö±íÖеÄÐÐ
DROP AGGREGATE -- ɾ³ýÒ»¸öÓû§¶¨ÒåµÄ¾Û¼¯º¯Êý
DROP DATABASE -- ɾ³ýÒ»¸öÊý¾Ý¿â£®
DROP FUNCTION -- ɾ³ýÒ»¸öÓû§¶¨ÒåµÄº¯Êý
DROP GROUP -- ɾ³ýÒ»¸öÓû§×é
DROP INDEX -- ɾ³ýÒ»¸öË÷Òý
DROP LANGUAGE -- ɾ³ýÒ»¸öÓû§¶¨ÒåµÄ¹ý³ÌÓïÑÔ
DROP OPERATOR -- ɾ³ýÒ»¸öÓû§¶¨Òå²Ù×÷·û
DROP RULE -- ɾ³ýÒ»¸öÖØÐ´¹æÔò
DROP SEQUENCE -- ɾ³ýÒ»¸öÐòÁÐ
DROP TABLE -- ɾ³ýÒ»¸ö±í
DROP TRIGGER -- ɾ³ýÒ»¸ö´¥·¢Æ÷¶¨Ò壮
DROP TYPE -- ɾ³ýÒ»¸öÓû§¶¨ÒåÊý¾ÝÀàÐÍ
DROP USER -- ɾ³ýÒ»¸öÊý¾Ý¿âÓû§ÕʺÅ
DROP VIEW -- ɾ³ýÒ»¸öÊÓͼ
END -- Ìá½»µ±Ç°µÄÊÂÎñ
EXPLAIN --&nb
Ïà¹ØÎĵµ£º
1. SQLÓÅ»¯µÄÔÔòÊÇ£º
½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ,¼´ÔÚ×î¶ÌµÄʱ¼ä´ïµ½×î´óµÄÊý¾ÝÍÌÍÂÁ¿¡£
µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺
¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ
¼ì²é×Ó²éѯ ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ ......
Ö´ÐÐ˳Ðò:´Ó×óµ½ÓÒ,±äÁ¿ÓÅÏÈ,ÖðÐиüÐÂ
Õª×ÔCSDNµÄÀý×Ó(http://topic.csdn.net/u/20091030/16/7fd75fa6-bdb9-4516-9b27-48aef69703ba.html
http://topic.csdn.net/u/20090904/16/e5dad9c7-fb59-41b9-b28d-e3b71c3e8420.html)
1.±äÁ¿ÓÅÏÈ
create table #t (field1 varchar(10),field2 varchar(10))
insert #t sel ......
ËÄ¡¢ÁªºÏÊý×éµÄʹÓ÷½·¨
ÁªºÏÊý×éÒÔǰ±»³ÆÎªPL/SQL±í¡£ÔÚ±íÖв»ÄÜʹÓÃÁªºÏÊý×飬ֻÄܽ«ËüÃÇÓÃ×÷³ÌÐòÉè¼ÆµÄ½á¹¹Ìå¡£Ö»ÄÜÔÚPL/SQLÖзÃÎÊÁªºÏÊý×é¡£
×¢Òâµ½ÁªºÏÊý×é´øÀ´µÄһЩ¹Ø¼üÎÊÌâÊǷdz£ÖØÒªµÄ¡£ÕâЩÎÊÌâʹÎÒÃǽéÉÜËüÃǵÄÓ÷¨Ê±£¬ÐèÒª²ÉÈ¡Ò»Ð©ÌØ±ðµÄ·½·¨¡£ÕâЩÎÊÌâ°üÀ¨£º
ÁªºÏÊý×é²»ÐèÒª³õʼ»¯£¬Ò²Ã»Óй¹Ô캯ÊýÓï·¨¡£ÔÚ ......
Êý¾Ý¿âÖÐÖ÷¼üºÍÍâ¼ü
(1)×÷ÓÃ
¼òµ¥ÃèÊö£º
Ö÷¼üÊǶԱíµÄÔ¼Êø£¬±£Ö¤Êý¾ÝµÄΨһÐÔ£¡
Íâ¼üÊǽ¨Á¢±íÓÚ±íÖ®¼äµÄÁªÏµ£¬·½±ã³ÌÐòµÄ±àд£¡
(2)Éè¼ÆÔÔò
Ö÷¼üºÍÍâ¼üÊǰѶà¸ö±í×é֯Ϊһ¸öÓÐЧµÄ¹ØÏµÊý¾Ý¿âµÄÕ³ºÏ¼Á¡£Ö÷¼üºÍÍâ¼üµÄÉè¼Æ¶ÔÎïÀíÊý¾Ý¿âµÄÐÔÄܺͿÉÓÃÐÔ¶¼ÓÐמö¶¨ÐÔµÄÓ°Ïì¡£
±ØÐ뽫Êý¾Ý¿âÄ£Ê ......
CREATE DATABASE
´´½¨Ò»¸öÐÂÊý¾Ý¿â¼°´æ´¢¸ÃÊý¾Ý¿âµÄÎļþ£¬»ò´ÓÏÈǰ´´½¨µÄÊý¾Ý¿âµÄÎļþÖи½¼ÓÊý¾Ý¿â¡£
˵Ã÷ ÓйØÓë DISK INIT Ïòºó¼æÈÝÐԵĸü¶àÐÅÏ¢£¬Çë²Î¼û"Microsoft® SQL Server™ Ïòºó¼æÈÝÐÔÏêϸÐÅÏ¢"ÖеÄÉ豸£¨¼¶±ð 3£©¡£
Óï·¨
CREATE DATABASE database_name
[ ON
[ < filespec > ......