Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Basic Knowledge

MySQL°æ±¾: Server version: 5.1.44 Source distribution
ÐÞ¸ÄrootÃÜÂë
Èç¹ûûÓÐÃÜÂëʹÓÃÏÂÃæµÄÃüÁî, ½«ÃÜÂëÉèΪ"123456"
$ mysqladmin -u root password 123456
Èç¹ûÓÐÃÜÂëʹÓÃÏÂÃæµÄÃüÁî, ½«ÃÜÂë¸ÄΪ"123456"
$ mysqladmin -u root -p password 123456
Enter password:
Óû§ÕË»§¹ÜÀí
Ìí¼ÓÕË» ......

mysql µ¼Èëµ¼³öÊý¾Ý·½·¨

1:>;create databases newname(ÔÚеÄserverÉϽ¨Á¢¿ÕµÄÊý¾Ý¿â)
2:#/usr/local/mysql/bin/mysqldump databasename >;*.sql(ÔھɵķþÎñÆ÷Éϵ¼³öÊý¾Ý¿â)
3:#/usr/local/mysql/bin/mysql databasename < *.sql(ÔÚеķþÎñÆ÷Éϵ¼Èë*.sql) ......

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

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

Mysql Êý¾Ý¿â×Ö·û¼¯×ª»»¼°°æ±¾Éý¼¶/½µ¼¶µÄÏêϸ½Ì³Ì

¿´µ½²»ÉÙÓû§·´Ó³×ª»»ÍêÒÔºóÊÇÂÒÂëµÄÇé¿ö,³öÏÖÕâÖÖÏÖÏóµÄÖ÷ÒªÔ­ÒòÊÇÕâÀàÓû§Ê¹ÓõͼÊÇmysql4.1ÒÔÉϵİ汾.ÏÂÃæ×÷Ò»¸ö˵Ã÷,Ï£Íû³öÏÖÕâ¸öÎÊÌâµÄÅóÓѶ¼ÄÜÄÍÐĵİÑÕâ¸öÎĵµ¿´Íê!!!
MySQL 4.1¿ªÊ¼£¬¶Ô¶àÓïÑÔµÄÖ§³ÖÓÐÁ˺ܴó±ä»¯ (Õâµ¼ÖÂÁËÎÊÌâµÄ³öÏÖ)¡£¾¡¹Ü´ó²¿·ÖµÄµØ·½ (°üÀ¨¸öÈËʹÓúÍÖ÷»úÌṩÉÌ)£¬MySQL 3¡¢4.0 ÈÔȻռÖ÷µ¼µØ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ