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
Ïà¹ØÎĵµ£º
Ò».ÏÈ¿´Ò»Ð©×î¼òµ¥µÄÀý×Ó
Àý×Ó
Table A
aid adate
1 a1
2 a2
3 a3
TableB
bid bdate
1 b1
2 b2
4 b4
Á½¸ö±ía,bÏàÁ¬½Ó,Ҫȡ ......
ÍêÕûµÄʵÏÖÁËPHP½«Í¼Æ¬´æÈëMYSQL
ǰÌ᣺
1 Ê×ÏȱØÐëÓµÓÐPHPµÄÔËÐл·¾³£¬ÁíÍ⻹µÃÓÐMYSQLÊý¾Ý¿â
2 Èç¹ûÎļþ²»ÄÜÉÏ´«³É¹¦Çë¼ì²épicsÊÇ·ñÊÇ¿ÉдµÄȨÏÞ
Ê×ÏÈÏȰÑpic2db.rarÎļþ½âѹµ½PHP¿ÉÒÔÔËÐÐĿ¼Ï¡£
Æä´ÎÔÚMYSQLÖн¨Á¢Ò»¸öÊý¾Ý¿â:pic2db,È»ºóÔÚ¸ÃÊý¾Ý¿âϽ¨Á¢Ò»¸ö±í£¬±í½á¹¹Îª£º
CREATE TABLE `pi ......
ÎÒÔÚд´úÂëµÄʱºòϲ»¶Ê¹Óú꣬²»½öʹ´úÂë¿´ÆðÀ´Õû½à£¬¶øÇÒÓúÃÁË»¹Äܼ«´óµÄ¼õÇá±àÂëµÄ¹¤×÷Á¿£¬µ«ÊÇÈç¹ûʹÓò»µ±µÄ»°£¬³öÁËÎÊÌâ²éÕÒÆðÀ´¾Í¾Í·Ç³£µÄÄÑÁË£¬ÏÂÃæµÄ×ܽá´ó²¿·ÖÊÇ´ÓÍøÉÏ¿´µ½µÄ£¬Ò²ÓÐһЩÊÇÎÒ×Ô¼ºÔÚ¹¤×÷ÖÐ×ܽá³öÀ´µÄ¡£
ºêʹÓÃÖеij£¼ûµÄ»ù´¡ÎÊÌâ
1. ·ÀÖ¹Ò»¸öÍ·Îļþ±»Öظ´°üº¬
#ifndef BOD ......
Êý¾Ý¿â²Ù×÷ÀࣺDBCommon.class.php
//---------------------------------------------------------------------
// MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà
//
// ¿ª·¢×÷Õß: heiyeluren
// °æ±¾ÀúÊ·:
// 2006-09-20 »ù±¾µ¥Êý¾Ý¿â²Ù×÷¹¦ÄÜ, 25 ¸ö½Ó¿Ú
// 2007-07-30 Ö§³Öµ ......
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°²×°³ÌÐòÒ»Ñù£¬Ê×ÏȳöÏÖµÄÊǰ²×°Ïòµ¼»¶Ó½çÃæ
Ö ......