phpÁ¬½ÓmysqlÏê½â
Èç¹ûÖ»ÊÇÒ»¸öÊý¾Ý¿âµÄ»°£¬ÎÒÃÇÒ»°ãϰ¹ßÕâÑùд£ºmysql_select_db("guestbook")£»
mysql_query('select * from users');
µ«ÊÇÈç¹ûÊÇÁ¬½Ó¶à¸ömysql£¬ÓпÉÄܳöÏÖͬÃûµÄÊý¾Ý¿â£¬»òÕßÊý¾Ý¿âÖгöÏÖͬÃûµÄ±í£¬ËùÒԾͱØÐëÓÃÍêÕûµÄÐÎʽÁË£¬ÈçÏ´úÂ룺
<?php
$link1 = mysql_connect('localhost1','root','root');
mysql_select_db('test',$link1);
mysql_query('select * from users', $link1);
$link2 = mysql_connect('localhost2','root','root');
mysql_select_db('test',$link2);
mysql_query('select * from users', $link2);
?>
Ïà¹ØÎĵµ£º
×¢Ò⣺֮ǰÎÒÔÚÍøÉÏÕÒÁ˺öàµÄ×ÊÁÏ NND¶¼²»ÄÜÕý³£ÅäÖóɹ¦ ¸ãµÃÎÒÊǷdz£µØÓôÃÆ£¡
ÕÒµ½ÕâÆªÎÄÕÂÖ®ºóÎÒÖÕÓÚÅäÖóɹ¦ÁË£¡ÍÛºÃˬѽ£¡Ö»Òª°´ÕÕ ÉÏÃæµÄ²½Öè¾ÍÒ»¶¨Äܹ»³É¹¦µÄ£¡
´ËÎÄյݲװ·½·¨ÊÊÓÃÓÚWindows XPϵÄApache+PHP+MySQL°²×°£¬Í¬Ê±Ò²ÊÊÓÃÓÚWindows 2003ϵͳϵݲװºÍÅäÖá£
1. °²×°»·¾³
²Ù×÷ϵͳÊÇ Window ......
Àý×Ó£º½«cdb_pms±ísubject×Ö¶ÎÖеÄWelcom toÌæ»»³É »¶Ó¹âÁÙ
UPDATE `cdb_pms`
SET `subject` = REPLACE(`subject`, ¡®Welcome to¡¯, ¡®»¶Ó¹âÁÙ¡¯)
WHERE INSTR(`subject`,¡¯Welcome to¡¯) < 0 Ìæ»»cdb_posts±íµÄmessage×ֶΣ¬½«¡°viewthread.php?tid=3989¡±Ìæ»»³É¡°viewthread.php?tid=16546¡± U ......
MySQLµÄmysqldump¹¤¾ßµ¼Èëµ¼³öÊý¾Ý¿â£¡
1.µ¼³öÕû¸öÊý¾Ý¿â(DosÏÂ)
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
mysqldump -u chai -p smgp_apps_wcnc > chai.sql
2.µ¼³öÒ»¸ö±í
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
mysqldump -u chai -p smgp_apps_wcnc users>c ......
ÔÚÎÒÃÇ»ú·¿ÉϿεÄʱºò£¬ÀÏʦÈÃ×Ô¼º×ö ͼͼƬ ³ö¿â ºÍÈë¿â £¬°¥ £¬ ×ø×Å×ø×Å £¬½¨±íMYSQL ÃüÁîÐÐģʽ£¬Óиö´æ´¢ ͼƬµÄ×Ö¶Î ×Ô¼º²»ÊìϤ£¬ÓÐûÓÐMysql µÄAPIÎĵµ£¬ ÈçºÎ°ì ÎÊͬѧ ͬѧҲ²»ÖªµÀ¡£
ºÇºÇ ÏëÆðÁË DOSµÄ°ïÖú ´òÁËÒ»¸ö Help ºÇºÇ ³öÏÖÁË ºÃ¶à¶«Î÷
ÔÙ°´ÕÕÌáʾ £ºhelp create table ºÇºÇ Ï ......