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 -- ÏÔʾÓï¾äÖ´Ð
Ïà¹ØÎĵµ£º
GROUP BY ʵÀý
±í "Sales":
Company Amount
W3Course 6500
IBM 5500
W3Course 7300
SQL:
SELECT Company, SUM(Amount) from Sales
½á¹û:
Company SUM(Amount)
W3Course 19300
IBM 19300
W3Course 19300
ÉÏÃæµÄ´úÂëÊÇÎÞЧµÄ£¬ÕâÊÇÓÉÓÚ±»·µ»ØµÄÁÐûÓнøÐв¿·ÖºÏ¼Æ¡£GROUP BY ×Ó¾äÄܽâ¾öÕâ¸öÎÊÌ⣺
SELE ......
mysql : ½«Ò»¸ö±íµÄÊý¾Ý²åÈëµ½newT ÖÐ
£¨newT ±íÐë´æÔÚ£¬ÇҽṹÓëselect Óï¾ä¶ÔÓ¦µÄ½á¹¹Í¬ £¬×îºÃ²»ÓÃ* ¶øÊǾßÌå×ֶΣ©
insert into newT select * from t1 where ...
Ò²¿ÉÒÔcreate table newT select f1,f2 from t1; (select into µÄÌæ´ú·½·¨£¬my ......
ÏÖÏó£º
ÔÚʹÓÃMicrosoft SQL Server 2005ʱ£¬Òª´´½¨Ò»¸öµÇ¼Ãû£¬²¢Îª¸ÃµÇ¼Ãû¹ØÁªÁËÒ»¸öÊý¾Ý¿â£¬µ«ÊÇÔÚÑ¡Ôñ“°²È«¶ÔÏó”Ñ¡Ïîʱ£¬È´³öÏÖÁËÈçÌâËùʾµÄ´íÎó¡£ÆäËûÐÅÏ¢ÏÔʾΪ£ºÖ´ÐÐTransact-SQLÓï¾ä»òÅú´¦Àíʱ·¢ÉúÁËÒì³£(Microsoft.SqlServer.ConnectionInfo)¡£ÎÞ·¨½â¾ö ......
Select CONVERT(varchar(100), GETDATE(), 0) as 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1) as 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2) as 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3) as 16/05/06
Select CONVERT(varchar(100), GETDATE(), 4) as 16.05.06
Select CON ......
SQL Server 2005 hashÁª½ÓËã·¨
Èç¹ûÁ½¸öÁª½ÓÊäÈ붼ºÜ´ó£¬¶øÇÒÕâÁ½¸öÊäÈëµÄ´óС²î²»¶à£¬ÔòÔ¤ÏÈÅÅÐòµÄºÏ²¢Áª½ÓÌṩµÄÐÔÄÜÓë¹þÏ£Áª½ÓÏà½ü¡£µ«ÊÇ£¬Èç¹ûÕâÁ½¸öÊäÈëµÄ´óСÏà²îºÜ´ó£¬Ôò¹þÏ£Áª½Ó²Ù×÷ͨ³£¿ìµÃ¶à¡£
¹þÏ£Áª½Ó¿ÉÒÔÓÐЧ´¦ÀíδÅÅÐòµÄ´óÐÍ·ÇË÷ÒýÊäÈë¡£ËüÃǶԸ´ÔÓ²éѯµÄÖмä½á¹ûºÜÓÐÓã¬ÒòΪ£º
&nbs ......