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

±È½Ï²»´íµÄmysql²Ù×÷Àà

<?php
/*
 * by:lenush
 * qicq:707207845
 * email:lenus-h@163.com
 * site:www.hackthiswebsite.cn
 * that's all
 *
 */ 
class mysql{
 
 private $db_host;  //Êý¾Ý¿âÖ÷»ú
 private $db_user;  //Êý¾Ý¿âÓû§Ãû
 private $db_pwd;   //Êý¾Ý¿âÓû§ÃûÃÜÂë
 private $db_database;    //Êý¾Ý¿âÃû
 private $conn;           //Êý¾Ý¿âÁ¬½Ó±êʶ;
 private $result;         //Ö´ÐÐqueryÃüÁîµÄ½á¹û×ÊÔ´±êʶ
 private $sql;   //sqlÖ´ÐÐÓï¾ä
 private $row;     //·µ»ØµÄÌõÄ¿Êý
 private $coding;  //Êý¾Ý¿â±àÂ룬GBK,UTF8,gb2312
 private $bulletin = true;    //ÊÇ·ñ¿ªÆô´íÎó¼Ç¼
 private $show_error = true;  //²âÊԽ׶Σ¬ÏÔʾËùÓдíÎó,¾ßÓа²È«Òþ»¼,ĬÈϹرÕ
 private $is_error = false;   //·¢ÏÖ´íÎóÊÇ·ñÁ¢¼´ÖÕÖ¹,ĬÈÏtrue,½¨Òé²»ÆôÓã¬ÒòΪµ±ÓÐÎÊÌâʱÓû§Ê²Ã´Ò²¿´²»µ½ÊǺܿàÄÕµÄ
  
 /*¹¹Ô캯Êý*/
 public function __construct($db_host,$db_user,$db_pwd,$db_database,$conn,$coding){
      $this->db_host=$db_host;
      $this->db_user=$db_user;
      $this->db_pwd = $db_pwd;
      $this->db_database=$db_database;
      $this->conn=$conn;
      $this->coding=$coding;
      $this->connect();
    }
 /*Êý¾Ý¿âÁ¬½Ó*/                
 public function connect()
 {
  if($this->conn=="pconn"){
   //ÓÀ¾ÃÁ´½Ó
      $this->conn=mysql_pconnect($this->db_host,$this->db_user,$this->db_pwd);
  }else{
  &


Ïà¹ØÎĵµ£º

mysql µÄ×Ö·û±àÂë

 === ÉÔºóÔÙÕûÀí
mysql
4.0µ½mysql
5.0µÄÊý¾Ýµ¼Èë³öÏÖÂÒÂëµÄ½â¾ö·½°¸
×ÖÌå´óС£º´ó
| ÖÐ
| С
2007-02-08 17:09 -
ÔĶÁ£º485 - ÆÀÂÛ
£º0
×î½ü×ömysql
4.0µ½mysql
5.0µÄÊý¾Ýת»¯¹¤×÷£¬·¢ÏÖÂÒÂë
ÎÞÊý£¬¹Û²©¿ÍÎÞÊýÐĵÃÈçÏ£º
£ªmysql
ÖÐÎÄ亂碼µÄÔ­Òò
mysql
會³ö現ÖÐÎÄ ......

ÔÚSQLÖÐʹÓÃnow()µ¼ÖµÄÐÔÄÜϽµ(MySQL)

×öÊý¾Ý¿âµ÷ÓÅ£¬Ò»¸ö¼òµ¥µÄtip¾ÍʹÐÔÄÜÌáÉýÒ»´ó¿éʱ£¬±»°ïÖúµÄÈË×ÔÈ»ÊǸßÐ˶øÇҸм¤£¬ÎÒÒ²ÊÇÂúÐÄ»¶Ï²¡£ÓÃËùѧ°ïÖúÁËËûÈË£¬Ò²ËµÃ÷»¹ÊÇÓÐÒ»¼¼Ö®³¤µÄ£¬ÓÐÒ»ÃÅÄܹ»Ñø»î×Ô¼ºµÄÊÖÒÕ¡£Ò²ËãÊÇÊÖÒÕÈË°¡¡£
ͬÊÂÈÃÎÒ°ïÖúÓÅ»¯£¬ÔÚslow query logÀï·¢ÏÖÓÐÁ½¸öSQLÖ´ÐеĴÎÊý×î¶à£¬²¢ÇÒÿ´Î¶¼ÔÚÁ½ÃëÒÔÉÏ¡£ÓÃexplain¿´ÁË£¬Ò²Î´·¢ÏÖË÷ÒýʹÓ÷ ......

MySQL 5.0´æ´¢¹ý³Ì

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

MySQL 5.4µÄÐÂÌØÐÔ½âÎö

Author: Ivan@mysqlab.net/Ì·¿¡Çà תÔØÇë×¢Ã÷À´Ô´URIÁ´½Ó:
http://www.mysqlab.net/blog/2009/04/mysql-54µÄÐÂÌØÐÔ½âÎö/
MySQL 5.4 Ö®ËùÒÔÃüÃûΪ5.4£¬¶ø²»ÊÇ5.2 ÊÇÒòΪ֮ǰµÄ5.2°æ±¾±»ÃüÃûΪ6.0ÁË£¨Õâ¸öÓ¦¸ÃÊÇÉÌÒµÉϵÄÔ­Òò£¬¾ÍÏñjava1.6±»ÃüÃûΪ6.0£©¡£ÏÖÔÚµÄ5.4 preview release ÊÇÔÚµ±Ç°MySQL5.1µÄ»ù´¡ÉÏ£¬¶Ô Innodb ½ø ......

MySQL Êý¾Ý¿â InnoDBÒýÇæµÄ²åÖµÎÊÌâ

InnoDBÊÇmysqlÊý¾Ý¿âÖÐΨһһ¸öÖ§³ÖÍâ¼üµÄÒýÇ棬µ«ÊDzîÖµµÄʱºòÈ´µÃ×¢ÒâÒ»ÏÂ
±ÈÈçÓÐÁ½ÕÅ±í£¬album(id,name,path) £¬picture(id,name,path,parent_album)£¬ÆäÖбí2ÖÐparent_albumÊÇÍâ¼ü
´Ëʱ²îÖµinsert into picture (name,path,parent_album) values ("pic","path",68) (68ÊÇÒ»¸öÏà²áµÄid)
mysql»á±¨´í"Failed to read a ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ