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

CÓïÑÔÁ¬½ÓmysqlÊý¾Ý¿â£¬¶ÁÈ¡mysqlÄÚÈÝ

 //linuxϱàÒëg++ $(mysql_config --cflags)  ***.cpp  $(mysql_config --libs)
/*mysqlÊý¾Ý¿âÖбíµÄÄÚÈÝ
mysql> select * from maindb;
+------------------+---------+-------------+---------+----------+---------------------+---------------------+---------------------+--------------------+
| id               | leixing | wenjianming | zhanhao | zhanming | scsj                | clsj                | sxsj                | baowen             |
+------------------+---------+-------------+---------+----------+---------------------+---------------------+---------------------+--------------------+
| 0000000000003215 | sp      | sp321654    |      12 | fuzhou   | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | oiyhjkghjdgfskdjfh |
| 0000000000003216 | NULL    | pet.txt     |     256 | ¸£ÖÝ            | 1970-01-01 08:04:16 | NULL                | 1970-01-01 08:09:08 |$
                                                                               &n


Ïà¹ØÎĵµ£º

mysql²Ù×÷ Left join , Right Join, Inner Join


Ò».ÏÈ¿´Ò»Ð©×î¼òµ¥µÄÀý×Ó
Àý×Ó
Table A
aid   adate
1      a1
2      a2
3      a3
TableB
bid bdate
1    b1
2   b2
4    b4
Á½¸ö±ía,bÏàÁ¬½Ó,Ҫȡ ......

PHP½«Í¼Æ¬´æÈëMYSQL

 ÍêÕûµÄʵÏÖÁËPHP½«Í¼Æ¬´æÈëMYSQL
ǰÌ᣺
 1 Ê×ÏȱØÐëÓµÓÐPHPµÄÔËÐл·¾³£¬ÁíÍ⻹µÃÓÐMYSQLÊý¾Ý¿â
 2 Èç¹ûÎļþ²»ÄÜÉÏ´«³É¹¦Çë¼ì²épicsÊÇ·ñÊÇ¿ÉдµÄȨÏÞ
Ê×ÏÈÏȰÑpic2db.rarÎļþ½âѹµ½PHP¿ÉÒÔÔËÐÐĿ¼Ï¡£
Æä´ÎÔÚMYSQLÖн¨Á¢Ò»¸öÊý¾Ý¿â:pic2db,È»ºóÔÚ¸ÃÊý¾Ý¿âϽ¨Á¢Ò»¸ö±í£¬±í½á¹¹Îª£º
CREATE TABLE `pi ......

C ºê¶¨ÒåµÄ¼òµ¥×ܽá

 
ÎÒÔÚд´úÂëµÄʱºòϲ»¶Ê¹Óú꣬²»½öʹ´úÂë¿´ÆðÀ´Õû½à£¬¶øÇÒÓúÃÁË»¹Äܼ«´óµÄ¼õÇá±àÂëµÄ¹¤×÷Á¿£¬µ«ÊÇÈç¹ûʹÓò»µ±µÄ»°£¬³öÁËÎÊÌâ²éÕÒÆðÀ´¾Í¾Í·Ç³£µÄÄÑÁË£¬ÏÂÃæµÄ×ܽá´ó²¿·ÖÊÇ´ÓÍøÉÏ¿´µ½µÄ£¬Ò²ÓÐһЩÊÇÎÒ×Ô¼ºÔÚ¹¤×÷ÖÐ×ܽá³öÀ´µÄ¡£
ºêʹÓÃÖеij£¼ûµÄ»ù´¡ÎÊÌâ
1. ·ÀÖ¹Ò»¸öÍ·Îļþ±»Öظ´°üº¬
   #ifndef BOD ......

MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà

Êý¾Ý¿â²Ù×÷ÀࣺDBCommon.class.php
//---------------------------------------------------------------------
// MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà
//
// ¿ª·¢×÷Õß: heiyeluren
// °æ±¾ÀúÊ·:
// 2006-09-20 »ù±¾µ¥Êý¾Ý¿â²Ù×÷¹¦ÄÜ, 25 ¸ö½Ó¿Ú
// 2007-07-30 Ö§³Öµ ......

mysql°²×°Í¼½â½Ì³Ì 5.1(ת)

mysql°²×°Í¼½â½Ì³Ì 5.1
2009Äê03ÔÂ01ÈÕ ÐÇÆÚÈÕ 23:51
×ªÔØÇë×¢Ã÷³ö´¦:http://hi.baidu.com/herdff/blog/item/6e6b4bcf6132f90b93457e14.html
±¾½Ì³ÌÒÔMysql 5.1°æ±¾ÎªÀý£¬¸ü¸ß°æ±¾°²×°¹ý³ÌÓë´ËÀàËÆ¡£ÔĶÁǰ£¬ÇëÏÂÔØ5.1£¬ÏÂÔØµØÖ·£ºwww.mysql.com
°²×°¹ý³ÌÓëÆäËüWindows°²×°³ÌÐòÒ»Ñù£¬Ê×ÏȳöÏÖµÄÊǰ²×°Ïòµ¼»¶Ó­½çÃæ
Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ