Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ò»¸öMYsqlÀà

<?php
class mysql {
 /*+++++++++++++++Êý¾Ý¿â·ÃÎÊÀà++++++++++++++++++++++++++
 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 */
   //=================================================
        //Á¬½ÓÊý¾Ý
 private $Host        = "localhost";  //·þÎñÆ÷µØÖ·
 private $Database    = "sansu";       //Êý¾Ý¿âÃû³Æ
 private $User        = "root";       //Óû§Ãû
 private $Password    = "czq339403229";           //Óû§ÃÜÂë
 private $Char_Set    = "utf8";       //ÉèÖÃÊý¾Ý¿â×Ö·û¼¯
       //½á¹ûÊý¾Ý
 public $Link_ID      = 0;            //Êý¾Ý¿âÁ¬½Ó
 public $Query_ID     = 0;            //²éѯ½á¹û
 public $Row_Result   = array();     //½á¹û½Ú×é³ÉµÄÊý×é
 public $Field_Result = array();     //½á¹û¼¯×Ö¶Î×é³ÉµÄÊý×é
// public $Affected_Rows=null;         //Ó°ÏìµÄÐÐÊý
// public $Rows         = null;        //½á¹û¼¯ÐÐÊý
// public $Fields       = null;        //½á¹û¼¯×Ö¶ÎÊý
// public $Row_Position = null;        //¼Ç¼ָÕëλÖÃË÷Òý
 //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
// _______________________________________________________________
  /*
     +++++++++++¹¹Ô캯Êý++++++++++++++++
  +++++++++++++++


Ïà¹ØÎĵµ£º

MYSQLÍâ¼ü(Foreign Key)µÄʹÓÃ


ÔÚMySQL 3.23.44°æ±¾ºó£¬InnoDBÒýÇæÀàÐ͵ıíÖ§³ÖÁËÍâ¼üÔ¼Êø¡£
Íâ¼üµÄʹÓÃÌõ¼þ£º
1.Á½¸ö±í±ØÐëÊÇ
InnoDB±í£¬MyISAM±íÔÝʱ²»Ö§³ÖÍâ¼ü£¨¾Ý˵ÒÔºóµÄ°æ±¾ÓпÉÄÜÖ§³Ö£¬µ«ÖÁÉÙĿǰ²»Ö§³Ö£©£»
2.Íâ¼üÁбØÐ뽨Á¢ÁËË÷Òý£¬MySQL
4.1.2ÒÔºóµÄ°æ±¾ÔÚ½¨Á¢Íâ¼üʱ»á×Ô¶¯´´½¨Ë÷Òý£¬µ«Èç¹ûÔÚ½ÏÔçµÄ°æ±¾ÔòÐèÒªÏÔʾ½¨Á¢£»
3.Íâ¼ü¹ØÏµµ ......

СÌâ´ó×öÖ®MySQL 5.0´æ´¢¹ý³Ì±à³ÌÈëÃÅ

MySQL °æ±¾£º5.0.45    phpMyAdmin°æ±¾£º2.11.3
 
Ê×ÏÈ¿´MySQL 5.0²Î¿¼ÊÖ²áÖйØÓÚ´´½¨´æ´¢¹ý³ÌµÄÓ﷨˵Ã÷£º
 
CREATE
    [DEFINER = { user | CURRENT_USER }]
    PROCEDURE sp_name ([proc_parameter[,...]])
    [characteristic ...] r ......

MysqlÖÐcount(*),DISTINCTµÄʹÓ÷½·¨ºÍЧÂÊÑо¿

ÔÚ´¦ÀíÒ»¸ö´óÊý¾ÝÁ¿Êý¾Ý¿âµÄʱºò
ͻȻ·¢ÏÖmysql¶ÔÓÚcount(*)µÄ²»Í¬´¦Àí»áÔì³É²»Í¬µÄ½á¹û
±ÈÈçÖ´ÐÐ
SELECT count(*) from tablename
¼´Ê¹¶ÔÓÚǧÍò¼¶±ðµÄÊý¾ÝmysqlÒ²Äܷdz£Ñ¸Ëٵķµ»Ø½á¹û
¶ø¶ÔÓÚ
SELECT count(*) from tablename WHERE…..
mysqlµÄ²éѯʱ¼ä¿ªÊ¼ÅÊÉý
×Ðϸ²éÔÄÀÛÏÂÊÖ²á,·¢ÏÖµ±Ã»ÓÐWHEREÓï¾ä¶ÔÓÚÕ ......

ÕÒ»ØMysQLÃÜÂë

ÓÉÓÚǰ¶Îʱ¼äÒªÓÃpowerdesignerÉè¼ÆÊý¾Ý¿â£¬¿ÉÊý¾Ý¿âÉè¼ÆºÃºóºÃµ¼ÈëMysQLʱÐèÒªODBCÁ¬½Ó£¬¶øMysQL5.0ÒÔÉϵľùÒªÐÞ¸ÄÃÜÂ루ÎÒÔÚÍøÉϲé¹ý£©£¬°´ËûÃǵÄÒâ˼ÐÞ¸ÄÁËrootÃÜÂ룬½á¹ûÊÇÖ±½Ó½ø²»ÁËMysQLÁË£¬ÎÒÄǸöÓôÃÆ£¬ÔÚÍøÉϲéÕÒ×ÊÁÏ£¬Ò²°´ËûÃǵķ½·¨×öÁË£¬¿É»¹ÊDz»ÐУ¨±¾È˶Ôdos²»Ê죩¡£µ«×îÖÕ»¹ÊÇ¿ÉÒÔÁË£¬ÏÂÃæËµÏ¾ßÌå·½·¨
1¡¢w ......

ÉîÈëÑо¿Mysql×Ö·û¼¯ÉèÖÃÒÔ¼°ÅÅÐò·½Ê½

¸ù¾ÝChaos WangµÄPPTÕûÀí¶ø³É£¬ ÔÚ´ËÔٴθÐлChaos WangµÄ´Ë´ÎTechTalk
»ù±¾¸ÅÄî
• ×Ö·û(Character)ÊÇÖ¸ÈËÀàÓïÑÔÖÐ×îСµÄ±íÒå·ûºÅ¡£ÀýÈç'A'¡¢'B'µÈ£»
• ¸ø¶¨Ò»ÏµÁÐ×Ö·û£¬¶Ôÿ¸ö×Ö·û¸³ÓèÒ»¸öÊýÖµ£¬ÓÃÊýÖµÀ´´ú±í¶ÔÓ¦µÄ×Ö·û£¬ÕâÒ»ÊýÖµ¾ÍÊÇ×Ö·ûµÄ±àÂë(Encoding)¡£ÀýÈ磬ÎÒÃǸø×Ö·û'A'¸³ÓèÊýÖµ0£¬¸ø×Ö·û'B'¸³ÓèÊýÖµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ