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);
?>
Ïà¹ØÎĵµ£º
¡¡¡¡
¡¡¡¡±¾ÎÄÖ÷Òª½éÉÜmysqlÊý¾Ý¿âÏÂshowÃüÁîµÄÖ÷ÒªÓ÷¨£º
¡¡¡¡a. show tables»òshow tables from database_name; -- ÏÔʾµ±Ç°Êý¾Ý¿âÖÐËùÓбíµÄÃû³Æ¡£
¡¡¡¡b. show databases; -- ÏÔʾmysqlÖÐËùÓÐÊý¾Ý¿âµÄÃû³Æ¡£
¡¡¡¡c. show columns from table_name from database_name; »òshow columns from database_name.table_n ......
ÕâÊÇÒÔ¶ÁΪÖ÷µÄÏßÉÏ¿â
root@read 02:28:07>show status like ‘Handler_read%’;
+———————–+——-+
| Variable_name | Value |
+————&m ......
ÔÚÎÒÃÇ»ú·¿ÉϿεÄʱºò£¬ÀÏʦÈÃ×Ô¼º×ö ͼͼƬ ³ö¿â ºÍÈë¿â £¬°¥ £¬ ×ø×Å×ø×Å £¬½¨±íMYSQL ÃüÁîÐÐģʽ£¬Óиö´æ´¢ ͼƬµÄ×Ö¶Î ×Ô¼º²»ÊìϤ£¬ÓÐûÓÐMysql µÄAPIÎĵµ£¬ ÈçºÎ°ì ÎÊͬѧ ͬѧҲ²»ÖªµÀ¡£
ºÇºÇ ÏëÆðÁË DOSµÄ°ïÖú ´òÁËÒ»¸ö Help ºÇºÇ ³öÏÖÁË ºÃ¶à¶«Î÷
ÔÙ°´ÕÕÌáʾ £ºhelp create table ºÇºÇ Ï ......
sessionÎļþ±£´æÔÚ·þÎñÆ÷£¬¶Ôÿ¸ösession¶¼»áËæ»úÉú³ÉÒ»¸öΨһµÄsessionIdÀ´½øÐбêʶ£¬Ò»°ãÈç¹ûûÓÐÉèÖÃsessionµÄÉú´æÖÜÆÚ£¬Ôòsession»á±£´æÔÚÄÚ´æÖУ¬¹Ø±Õä¯ÀÀÆ÷£¬¸Ãsessionid»á×Ô¶¯×¢Ïú£¬ÖØÐÂÇëÇóʱÔò×Ô¶¯ÖØÐ·ÖÅä¡£
Èç¹û¿Í»§¶ËûÓнûÓÃcookie£¬ÔòÔÚʹÓÃsessionʱ£¬cookie»á°èÑÝ´æ´¢sessionIdºÍsessionÉú´æÖÜÆÚµÄ½ÇÉ«¡£¡ ......