ʹÓÃSQLÓï¾ä
ʹÓÃSQLÓï¾ä
SQLÓïÑÔ°üÀ¨Êý¾Ý²éѯÓïÑÔ(SELECT)¡¢Êý¾Ý²Ù×ÝÓïÑÔ(INSERT¡¢UPDATE¡¢DELETE)¡¢ÊÂÎñ¿ØÖÆÓïÑÔ(COMMIT¡¢ROLLBACK¡¢SAVEPOINT)¡¢Êý¾Ý¶¨ÒåÓïÑÔ(CREATE TABLE¡¢ALTER TABLE¡¢DROP)¡¢Êý¾Ý¿ØÖÆÓïÑÔ(GRANT¡¢REVOKE)µÈÎå¸ö²¿·Ö¡£
µ±±àдPL/SQLÓ¦ÓóÌÐòʱ£¬Ö»ÄÜÖ±½ÓǶÈëSELECT...INTO...Óï¾ä¡¢DMLÓï¾äºÍÊÂÎñ¿ØÖÆÓï¾ä¡£
(Ò»)ʹÓûù±¾²éѯ
¢Ù¼òµ¥²éѯÓï¾ä
(1) Óï·¨£ºSELECT <*,column [±ðÃû],...> from TABLE|VIEW;
ÆäÖУº*±íʾ¼ìË÷ËùÓÐÁУ¬columnÓÃÓÚÖ¸¶¨Òª¼ìË÷µÄÁлò±í´ïʽ*£¨¶àÁлò¶à±í´ïʽ֮¼äÓöººÅ·Ö¸ô£©£¬±ðÃûÓÃÓÚÖ¸¶¨Áлò±í´ïʽµÄ±ðÃû£¬fromÓÃÓÚÖ¸¶¨Òª¼ìË÷µÄ±í»òÊÓͼ¡£
×¢£º*ºÍcolumn²»ÄÜ»ìºÏʹÓÃ
(2)DESC(describe) ±íÃû³Æ --ÓÃÓÚÈ·¶¨±í½á¹¹
(3)¼ìË÷ÈÕÆÚÁÐʱ£¬ÈÕÆÚĬÈÏÏÔʾ¸ñʽΪ'dd-mon-yy',Èç¹ûÒªÏëʹÓÃ'yyyy-mon-dd'¸ñʽ£¬Ôò±ØÐëʹÓÃTO_CHARº¯Êý½øÐÐת»»¡£
Àý£º
SQL> select ename,job,hiredate from emp where deptno=10; --ĬÈÏ
ENAME JOB HIREDATE
---------- --------- --------------
CLARK MANAGER 09-6ÔÂ -81
KING PRESIDENT 17-11ÔÂ-81
MILLER CLERK 23-1ÔÂ -82
SQL> select ename,job,to_char(hiredate,'yyyy-mon-dd') from emp where deptno=10; --ʹÓÃto_charº¯Êý
ENAME JOB TO_CHAR(HIREDATE
---------- --------- ----------------
CLARK MANAGER 1981-6ÔÂ -09
KING PRESIDENT 1981-11ÔÂ-17
MILLER CLERK &n
Ïà¹ØÎĵµ£º
¸Õ×°ÍêÊý¾Ý¿â¾Í±»ÈË·è¿ñɨÃèsa£¬ÎÞ±ÈÓôÃÆ¡£
¸ÄsaÃû³Æ£¬1433¶Ë¿ÚºÅ£¬ÒòΪ¿ª·¢ÐèÒª»¹±ØÐë´ò¿ªÔ¶³ÌÁ¬½Ó£¬½á¹ûÔÚ¿Í»§¶ËÎÞÂÛÈçºÎ¶¼²»ÄÜÁ¬½ÓÉÏ·þÎñÆ÷¡£
¿ñº¹Çë°Ù¶È´óÉñ³öÂí£¬°Ñ¸÷ÖÖÅäÖÃÁ·Á˸öÊ죬½á¹û»¹ÊÇû½â¾ö¡£
¸ãЦµÄÊÇ×îºóÎÞÒâÖÐÔÚMicrosoftÂÛ̳ÉÏ¿´µ½Õâôһ¾ä£¬ÐÞ¸ÄÍê¶Ë¿ÚºÅ£¬ÔÚ¿Í»§¶ËµÇ¼µÄʱºòÒªÔÚIPºóÃ棫¶ººÅ£«¶Ë¿Úº ......
SQL³£ÓÃÃüÁîʹÓ÷½·¨£º
(1) Êý¾Ý¼Ç¼ɸѡ£º
sql="select * from Êý¾Ý±í where ×Ö¶ÎÃû=×Ö¶ÎÖµ order by ×Ö¶ÎÃû [desc]"
sq ......
selectÓï¾äÇ°¼Ó£º
declare @d datetime
set @d=getdate()
²¢ÔÚselectÓï¾äºó¼Ó£º
select [Óï¾äÖ´Ðл¨·Ñʱ¼ä(ºÁÃë)]=datediff(ms,@d,getdate())
ת×Ô£º¶¯Ì¬ÍøÖÆ×÷Ö¸ÄÏ www.knowsky.com
ÕâÊǼòÒ׵IJ鿴ִÐÐʱ¼äµÄ·½·¨¡£
===========================================£¨Ò»ÏÂÄÚÈÝת×Ô£º£Ã£Ó£Ä£Î£©
MSSQL ServerÖÐͨ¹ý²é ......
¼Ü¹¹£¨Schema£©¡£Î¢ÈíµÄ¹Ù·½ËµÃ÷£¨MSDN£©£º
"Êý¾Ý¿â¼Ü¹¹ÊÇÒ»¸ö¶ÀÁ¢ÓÚÊý¾Ý¿âÓû§µÄ·ÇÖظ´ÃüÃû¿Õ¼ä£¬Äú¿ÉÒÔ½«¼Ü¹¹ÊÓΪ¶ÔÏóµÄÈÝÆ÷"£¬Ïêϸ²Î¿¼
http://technet.microsoft.com/zh-cn/library/ms190387.aspx.ÎÒÃÇÖªµÀ£¬ÔÚJAVAÖУ¬ÃüÃû¿Õ
¼äÃûÆäʵ¾ÍÊÇÎļþ¼ÐÃû¡£Òò´ËÎÒÃǷdz£Ã÷È·Ò»µã£ºÒ»¸ö¶ÔÏóÖ»ÄÜÊôÓÚÒ»¸ö¼Ü¹¹£¬¾ÍÏ ......