SQLÓï¾ä¸´Ï°:insert,update,delete,select
×î½üÒ»Ö±ÔÚѧϰSQL serverµÄÄÚÈÝ¡£×òÌ쿼ÁËÒ»ÏÂÊÔ¡£¸Ð¾õÕæµÄÊDz»ÈÝÒ×°¡¡£ÌرðÊÇһЩ¸´ÔӵIJéѯ¡£¸ãµÃÎÒÍ·»èÄÔÕ͵ġ£²»¹ýÒ²ÊÇÓÉÓÚ×Ô¼ºµÄÖªÊ¶ÕÆÎյϹ²»¹»Ôúʵ°¡¡£ËùÒÔ½ñÌ츴ϰÁËÒ»ÏÂT-SQlÓï¾äµÄÔöɾ¸Ä²é¡£·¢ÏÖµÄÈ·ÊÇÓкܶ඼Íü¼ÇÁË¡£ÏÖÔڰѽá¹ûд³öÀ´¡£ÒÔºó¿É²»ÒªÍüÁËѽ¡£
--SQLÓï¾ä¸´Ï° --Ò»,²åÈëinsertÓï¾ä --1,insertµ¥ÐÐÊý¾Ý insert into students(sName,sAddress,Ssex,Semail) values('ÐÕÃû','µØÖ·','ÐÔ±ð','ÓʼþµØÖ·')
--2,insert¶àÐÐÊý¾Ý£¬°ÑÆäËû±íÖÐÏÖÓеÄÊý¾Ý¾¹ýѡȡºó²åÈëµ½Êý¾Ý¿âÖÐ --°Ñ±íStudent¶ÔÓ¦µÄSname£¬Saddress£¬SemailÈýÁеÄÈ«²¿ÐУ¬ --²åÈëµ½TongXuLu±íÖеÄÐÕÃû£¬µØÖ·£¬µç×ÓÓʼþÈýÁÐÖÐ insert into students(ÐÕÃû,µØÖ·,µç×ÓÓʼþ) select Sname,Saddress,semail from students
--3,insert¶àÐÐÊý¾Ýµ½Ð½¨µÄ±íÖУ¬±í²»ÄÜÊÂÏÈ´æÔÚ --½«´´½¨TongXueLu±í£¬Í¬Ê±´´½¨Èý¸ö×Ö¶ÎSname£¬Saddress£¬Semail£¬ºÍ±êʶÁÐstudentID --²¢ÇÒ°ÑStudent±íÖеÄÕâÈýÁÐÊý¾ÝÏîÈ«²¿²åÈ뵽бíÖС£ select Students.Sname,Students.Saddress,Students.Semail,identity(int,1,1) as studentID--±êʶÁÐÁÐÃû into TongXuLu from Students
--4,ÊÖд¶àÐÐÊý¾Ýͨ¹ýUnionºÏ²¢²åÈë insert students(Sname,Sgrade,Ssex) select 'ÕÅ¿É',7,1 union select 'ÕÅÈý',4,0 union select '³Â¸Õ',4,1 union select 'Íõ¾ê¾ê',7,0
--¶þ£¬updateÊý¾Ý update students set Ssex=1,Sgrade=Sgrade+1 where Ssex=0
--Èý£¬delectÊý¾Ý --1,ɾ³ýÖ¸¶¨Êý¾Ý delete from students where Ssex=0
--2£¬É¾³ýËùÓÐÊý¾Ý --µÚÒ»ÖÖ·½·¨ delete from students --µÚ¶þÖÖ·½·¨,±ÈdeleteÖ´ÐÐËٶȿ죬ʹÓõÄϵͳ×ÊÔ´ºÍÊÂÎñÈÕÖ¾×ÊÔ´¸üÉÙ --µ«ÊDz»ÄÜÓÃÓÚÓÐÍâ¼üÔ¼ÊøµÄ±í truncate table students
--¸½¼Ó --1£¬°ÑËùÓÐÄÐͬѧµÄ³É¼¨¼Ó5·Ö update Sscore set score=score+5 where StudentID(select Scode from students where Ssex=1)
--2£¬Ö»¸´ÖÆStudentsµÄ±í½á¹¹£¬²»¸´ÖÆÊý¾Ý select identity(int 1,1) as InfoID,Sname,Saddress,Sgrade,Semail,Ssex into studnetInfo from students where (1<0)
--ËÄ£¬²éѯ --£¨Ò»£©Ò»°ãÊý¾Ý²éѯ --1£¬²éѯËùÓеÄÊý¾ÝÐкÍÁÐ select * from Students
--2,²éѯ²¿·ÖÊý¾ÝÐÐÁÐ --Ö»²éѯµØÖ·Îª'ºÓÄÏÐÂÏç'µÄѧԱ£¬²¢ÇÒÖ»ÏÔʾ±àºÅ£¬ÐÕÃûºÍµØÖ·ÁÐ select Scode,Sname,Saddress from students where Saddress='ºÓÄÏÐÂÏç'
--3,²éѯÖÐʹÓÃÁÐÃû select scode as ѧÉú±àº
Ïà¹ØÎĵµ£º
Èý¡¢Ç¶Ì×±íµÄʹÓ÷½·¨
1¡¢½«Ç¶Ì×±í¶¨ÒåΪPL/SQLµÄ³ÌÐò¹¹Ôì¿é
TYPE type_name IS TABLE OF element_type[NOT NULL];
ÈçÏÂÀýËùʾ£º
DECLARE
-- Define a nested table of variable length strings.
TYPE card_table IS TABLE OF VARCHAR2(5 CHAR);
-- Declare and initialize a n ......
ÉÏÃæÎÒÃÇÌáµ½µÄÊÇһЩ»ù±¾µÄÌá¸ß²éѯËٶȵÄ×¢ÒâÊÂÏî,µ«ÊÇÔÚ¸ü¶àµÄÇé¿öÏÂ,ÍùÍùÐèÒª·´¸´ÊÔÑé±È½Ï²»Í¬µÄÓï¾äÒԵõ½×î¼Ñ·½°¸¡£×îºÃµÄ·½·¨µ±È»ÊDzâÊÔ£¬¿´ÊµÏÖÏàͬ¹¦ÄܵÄSQLÓï¾äÄĸöÖ´ÐÐʱ¼ä×îÉÙ£¬µ«ÊÇÊý¾Ý¿âÖÐÈç¹ûÊý¾ÝÁ¿ºÜÉÙ£¬ÊDZȽϲ»³öÀ´µÄ£¬Õâʱ¿ÉÒÔÓò鿴ִÐмƻ®£¬¼´£º°ÑʵÏÖÏàͬ¹¦ÄܵĶàÌõSQLÓï¾ä¿¼µ½²éѯ·ÖÎöÆ÷£¬°´ ......
QT DataBase SQL Explorer
1¡¢°²×°MySQLµ½¹Ù·½ÍøÕ¾ÏÂÔØMySQLÊý¾Ý¿â£¬·Ç°²×°°æ£¬Ö±½ÓÔËÐÐmysqld½ø³Ìǰ̨µÄ
2¡¢Ìí¼Óϵͳ»·¾³±äÁ¿£¬Path+=':\mysql\bin'µÄpath£¬ÔÙÔÚ¿ªÊ¼ÔËÐУ¬CMD->mysql -uroot µÇ¼µ½mySQLÊý¾Ý¿â
Default passwordûÓеģ¬Óеϰ mysql -uroot -pÊäÈëÃÜÂë£»ÍøÂçµÇ¼£ºmysql -h ip ......
¸Õ¸ÕÔÚinthirtiesÀÏ´óµÄ²©¿ÍÀï¿´µ½ÕâÆªÎÄÕ£¬Ð´µÄ²»´í£¬ÕýºÃ×Ô¼º×î½üÔÚѧϰPL/SQL£¬×ª¹ýÀ´Ñ§Ï°Ñ§Ï°¡£
==================================================================================
bulk collectÊÇ¿ÉÒÔ¿´×öÊÇÒ»ÖÖÅú»ñÈ¡µÄ·½Ê½£¬ÔÚÎÒÃǵÄplsqlµÄ´úÂë¶ÎÀï¾³£×÷ΪintoµÄÀ©Õ¹À´Ê¹Ó᣶ÔÓÚselect id into v from ... ......
˵¾ä´ó·Ï»°£¬ÄǾÍÊÇ“ºÏÀíµÄƽºâ¸÷ÖÖ×ÊÔ´µÄʹÓÃ,ÄÚ´æ,cpu,io µÈµÈ”¡£ÕâÒ²ÊǺÜÓеÀÀíµÄ£¬µ«ÊÇʵ¼Ê¾Í²»ºÃ×öÁË£¬ÈçºÎƽºâÄØ£¿
¾ßÌåµãµÄô£¬Í¨¹ý±È½Ï£¬Ó¦¸ÃÊÇÏìӦʱ¼ä×öΪÖ÷ÒªµÄÆÀÅÐÒòËØÁË¡£µ«ÊÇ¿ÉÄÜÓÉÓÚһЩ²»È·¶¨µÄÒòËØ£¬¿ÉÄÜ»á³öÏÖ£ºÕâ´ÎÅܵĿ죬²»µÈÓÚÏ´ÎÒ²ÅܵĿìÁË¡£
ÄǾÍÒª¸ù¾Ý±íµÄÊý¾ÝÁ¿µÄ±ä»¯£¬È·¶¨Ò»¸ö± ......