MYSQL¸ß²¢·¢¼Ü¹¹
L1¡¢HTML¾²Ì¬»¯
Æäʵ´ó¼Ò¶¼ÖªµÀ£¬Ð§ÂÊ×î¸ß¡¢ÏûºÄ×îСµÄ¾ÍÊÇ´¿¾²Ì¬»¯µÄhtmlÒ³Ãæ£¬ËùÒÔÎÒÃǾ¡¿ÉÄÜʹÎÒÃǵÄÍøÕ¾ÉϵÄÒ³Ãæ²É Óþ²Ì¬Ò³ÃæÀ´ÊµÏÖ£¬Õâ¸ö×î¼òµ¥µÄ·½·¨ÆäʵҲÊÇ×îÓÐЧµÄ·½·¨¡£µ«ÊǶÔÓÚ´óÁ¿ÄÚÈݲ¢ÇÒÆµ·±¸üеÄÍøÕ¾£¬ÎÒÃÇÎÞ·¨È«²¿ÊÖ¶¯È¥°¤¸öʵÏÖ£¬ÓÚÊdzöÏÖÁËÎÒÃdz£¼ûµÄÐÅÏ¢ ·¢²¼ÏµÍ³CMS£¬ÏñÎÒÃdz£·ÃÎʵĸ÷¸öÃÅ»§Õ¾µãµÄÐÂÎÅÆµµÀ£¬ÉõÖÁËûÃÇµÄÆäËûƵµÀ£¬¶¼ÊÇͨ¹ýÐÅÏ¢·¢²¼ÏµÍ³À´¹ÜÀíºÍʵÏֵģ¬ÐÅÏ¢·¢²¼ÏµÍ³¿ÉÒÔʵÏÖ×î¼òµ¥µÄÐÅϢ¼ Èë×Ô¶¯Éú³É¾²Ì¬Ò³Ã棬»¹Äܾ߱¸ÆµµÀ¹ÜÀí¡¢È¨ÏÞ¹ÜÀí¡¢×Ô¶¯×¥È¡µÈ¹¦ÄÜ£¬¶ÔÓÚÒ»¸ö´óÐÍÍøÕ¾À´Ëµ£¬ÓµÓÐÒ»Ì׸ßЧ¡¢¿É¹ÜÀíµÄCMSÊDZز»¿ÉÉٵġ£
³ýÁËÃÅ»§ºÍÐÅÏ¢·¢²¼ÀàÐ͵ÄÍøÕ¾£¬¶ÔÓÚ½»»¥ÐÔÒªÇóºÜ¸ßµÄÉçÇøÀàÐÍÍøÕ¾À´Ëµ£¬¾¡¿ÉÄܵľ²Ì¬»¯Ò²ÊÇÌá¸ßÐÔÄܵıØÒªÊֶΣ¬½«ÉçÇøÄÚµÄÌû×Ó¡¢ÎÄÕ½øÐÐʵʱµÄ¾²Ì¬»¯£¬ÓиüеÄʱºòÔÙÖØÐ¾²Ì¬»¯Ò²ÊÇ´óÁ¿Ê¹ÓõIJßÂÔ£¬ÏñMopµÄ´óÔÓ»â¾ÍÊÇʹÓÃÁËÕâÑùµÄ²ßÂÔ£¬ÍøÒ×ÉçÇøµÈÒ²ÊÇÈç´Ë¡£
ͬ ʱ£¬html¾²Ì¬»¯Ò²ÊÇijЩ»º´æ²ßÂÔʹÓõÄÊֶΣ¬¶ÔÓÚϵͳÖÐÆµ·±Ê¹ÓÃÊý¾Ý¿â²éѯµ«ÊÇÄÚÈݸüкÜСµÄÓ¦Ó㬿ÉÒÔ¿¼ÂÇʹÓÃhtml¾²Ì¬»¯À´ÊµÏÖ£¬±ÈÈçÂÛ̳ÖÐÂÛ Ì³µÄ¹«ÓÃÉèÖÃÐÅÏ¢£¬ÕâЩÐÅϢĿǰµÄÖ÷Á÷ÂÛ̳¶¼¿ÉÒÔ½øÐкǫ́¹ÜÀí²¢ÇÒ´æ´¢ÔÙÊý¾Ý¿âÖУ¬ÕâЩÐÅÏ¢Æäʵ´óÁ¿±»Ç°Ì¨³ÌÐòµ÷Ó㬵«ÊǸüÐÂÆµÂʺÜС£¬¿ÉÒÔ¿¼Âǽ«Õⲿ·Ö ÄÚÈݽøÐкǫ́¸üеÄʱºò½øÐо²Ì¬»¯£¬ÕâÑù±ÜÃâÁË´óÁ¿µÄÊý¾Ý¿â·ÃÎÊÇëÇó¡£
2¡¢Í¼Æ¬·þÎñÆ÷·ÖÀë
´ó¼ÒÖªµÀ£¬¶ÔÓÚWeb·þÎñÆ÷À´Ëµ£¬²»¹Ü ÊÇ Apache¡¢IIS»¹ÊÇÆäËûÈÝÆ÷£¬Í¼Æ¬ÊÇ×îÏûºÄ×ÊÔ´µÄ£¬ÓÚÊÇÎÒÃÇÓбØÒª½«Í¼Æ¬ÓëÒ³Ãæ½øÐзÖÀ룬ÕâÊÇ»ù±¾ÉÏ´óÐÍÍøÕ¾¶¼»á²ÉÓõIJßÂÔ£¬ËûÃǶ¼ÓжÀÁ¢µÄͼƬ·þ ÎñÆ÷£¬ÉõÖÁºÜ¶ą̀ͼƬ·þÎñÆ÷¡£ÕâÑùµÄ¼Ü¹¹¿ÉÒÔ½µµÍÌá¹©Ò³Ãæ·ÃÎÊÇëÇóµÄ·þÎñÆ÷ϵͳѹÁ¦£¬²¢ÇÒ¿ÉÒÔ±£Ö¤ÏµÍ³²»»áÒòΪͼƬÎÊÌâ¶ø±ÀÀ££¬ÔÚÓ¦Ó÷þÎñÆ÷ºÍͼƬ·þÎñÆ÷ ÉÏ£¬¿ÉÒÔ½øÐв»Í¬µÄÅäÖÃÓÅ»¯£¬±ÈÈçapacheÔÚÅäÖÃContentTypeµÄʱºò¿ÉÒÔ¾¡Á¿ÉÙÖ§³Ö£¬¾¡¿ÉÄÜÉÙµÄLoadModule£¬±£Ö¤¸ü¸ßµÄϵͳÏûºÄ ºÍÖ´ÐÐЧÂÊ¡£
3¡¢Êý¾Ý¿â¼¯ÈººÍ¿â±íÉ¢ÁÐ
´óÐÍÍøÕ¾¶¼Óи´ÔÓµÄÓ¦Óã¬ÕâЩӦÓñØÐëʹÓÃÊý¾Ý¿â£¬ÄÇôÔÚÃæ¶Ô´óÁ¿·ÃÎʵÄʱºò£¬Êý¾Ý¿âµÄÆ¿¾±ºÜ¿ì¾ÍÄÜÏÔÏÖ³öÀ´£¬Õâʱһ̨Êý¾Ý¿â½«ºÜ¿ìÎÞ·¨Âú×ãÓ¦Óã¬ÓÚÊÇÎÒÃÇÐèҪʹÓÃÊý¾Ý¿â¼¯Èº»òÕß¿â±íÉ¢ÁС£
ÔÚÊý¾Ý¿â¼¯Èº·½Ã棬ºÜ¶àÊý¾Ý¿â¶¼ÓÐ×Ô¼ºµÄ½â¾ö·½°¸£¬Oracle¡¢SybaseµÈ¶¼Óкܺõķ½°¸£¬³£ÓõÄMySQLÌṩµÄMaster/SlaveÒ²ÊÇÀàËÆµÄ·½°¸£¬ÄúʹÓÃÁËʲôÑùµÄDB£¬¾Í²Î¿¼ÏàÓ¦µÄ½â¾ö·½°¸À´ÊµÊ©¼´¿É¡£
ÉÏ ÃæÌáµ½µÄÊý¾Ý¿â¼¯ÈºÓ
Ïà¹ØÎĵµ£º
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
Ò».´´½¨´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
create procedure
sp_name()
begin
………
end
2.²ÎÊý´«µÝ
¶þ.µ÷Óô洢¹ý³Ì
1.»ù±¾Óï·¨£ºcall
sp_name()
×¢Ò⣺´æ´¢¹ý³ÌÃû³ÆºóÃæ±ØÐë¼ÓÀ¨ºÅ£¬ÄÄŸô洢¹ý³ÌûÓвÎÊý´«µÝ
Èý.ɾ³ý´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
drop procedure ......
mysql½Ì³Ì:¸ßÊÖÊÇÔõÑùÁ¶³ÉµÄ:¾«ÃîSQLÓï¾ä½éÉÜ
[ÈÕÆÚ£º2009-06-02] À´Ô´£º ×÷Õߣº
ÈçºÎ´Óһλ²ËÄñÍɱä³ÉΪ¸ßÊÖ£¬Áé»îʹÓõÄSQLÓï¾äÊDZز»¿ÉÉٵġ£±¾ÎÄÊÕ¼¯Á˲¿·Ö±È½Ï¾µä£¬³£ÓõÄSQLÓï¾ä¹©´ó¼Ò²Î¿¼£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
¡¡¡¡ËµÃ÷£º¸´ÖƱí(Ö»¸´Öƽṹ,Ô´±íÃû£ºa бíÃû£ºb)¡¡¡¡
¡¡¡¡SQL: select * into ......
¾³£Óõ½£¬µ«ÊÇ×ÜÊǼDz»×¡¡£
Óï·¨ÈçÏ£º
ALTER TABLE JOB ADD CONSTRAINT fk_prono
FOREIGN KEY(PRONO)
REFERENCES PROJECT(PRONO)
ON DELETE CASCADE
ON UPDATE NO ACTION;
ÎÒÔÚmysqlÖÐÌí¼ÓÁËÍâ¼üÔ¼Êø£¬ÊÔÁ˰ëÌìû³É¹¦£¬ºóÀ´°ÑÍâ¼üµÄÃû×ÖÓÉFK¸Ä³ÉFK_1¾ÍºÃÁË£¬¿ÉÄÜmysqlÖÐFKÊǸö±£Áô×Ö£¬×¢Ò⣡ ......
Ê×ÏÈÒªÉùÃ÷Ò»µã£¬´ó²¿·ÖÇé¿öÏ£¬ÐÞ¸ÄMySQLÊÇÐèÒªÓÐmysqlÀïµÄrootȨÏ޵ģ¬ ËùÒÔÒ»°ãÓû§ÎÞ·¨¸ü¸ÄÃÜÂ룬³ý·ÇÇëÇó¹ÜÀíÔ±¡£ ·½·¨Ò»Ê¹ÓÃphpmyadmin£¬ÕâÊÇ×î¼òµ¥µÄÁË£¬ÐÞ¸Ämysql¿âµÄuser±í£¬ ²»¹ý±ðÍüÁËʹÓÃPASSWORDº¯Êý¡£ ·½·¨¶þʹÓÃmysqladmin£¬ÕâÊÇÇ°ÃæÉùÃ÷µÄÒ»¸öÌØÀý¡£ mysqladmin -u root -p password mypasswd ÊäÈëÕâ¸ö ......
6
¡¢ÐÞ¸ÄÊý¾Ý¿âµÄ×Ö·û¼¯
mysql>use mydb
mysql>alter database mydb character set utf-8;
6
¡¢´´½¨Êý¾Ý¿âÖ¸¶¨Êý¾Ý¿âµÄ×Ö·û¼¯
mysql>create database mydb character set utf-8;
ͨ¹ýÅäÖÃÎļþÉèÖô´½¨Êý¾Ý¿âʱ×Ö·û¼¯:
#vi /var/lib/mysql/mydb/db.opt
default-character-set=latin1
default-col ......