Mysql5.1 for PHP
×¼±¸£ºÏÂÔØMysql5.1<mysql-essential-5.1.41-win32.msi>
°²×°£ºstep by step
²âÊÔ£º1.MySQL²âÊÔ
µã¿ªMySQL Command Line Client, ÊäÈ밲װʱ½¨Á¢µÄÃÜÂë¡£
mysql>show databases;
mysql>use <<database name>>;
mysql>show tables;
mysql>select * from <<table name>>;
2.PHP²âÊÔ
½¨Á¢php²âÊÔÒ³db.php
<?php
mysql_connect('localhost','<<user name>>','<<password>>') or die(mysql_error());
mysql_select_db("<<database name>>");
$query='select now()';
$conn=mysql_query($query) or die (mysql_error());
echo "QUERY: $query<br>";
$res=mysql_fetch_array($conn);
echo $res[0];
?>
Ïà¹ØÎĵµ£º
ÐÞ¸Ä /etc/mysql/my.cnf Îļþ£¬
ÔÚ £Ûclient£Ý ϼÓÈë default-character-set=utf8,
ÔÚ [mysqld] ϼÓÈë default-character-set=utf8,
ÔòÔÚviÀï¿ÉÒÔÕýÈ·µÄÏÔʾÖÐÎÄÁË£¨Ç°ÌáÊÇviҲʹÓÃutf8£©¡£
²»¹ýÔÚ²éѯµÄʱºò£¬½á¹ûÀïµÄÖÐÎÄÈ´»áÏÔʾ³É "?"£¬Õâ¸öÎÊÌâ±È½Ï¼òµ¥µÄ·½·¨Óм¸ÖÖ£¬·Ö±ðÊÇ£º
1.ÔÚ´´½¨Ê ......
ÀýÈ磬MySQLĬÈϵÄÊý¾ÝÎļþ´æ´¢Ä¿Â¼Îª/var/lib/mysql¡£¼ÙÈçÒª°ÑÄ¿Â¼ÒÆµ½/home/dataÏÂÐèÒª½øÐÐÏÂÃæ¼¸²½£º
1¡¢homeĿ¼Ï½¨Á¢dataĿ¼
cd /home
mkdir data
2¡¢°ÑMySQL·þÎñ½ø³ÌÍ£µô£º
......
½ñÌìºÍһλ¼Ü¹¹Ê¦ÁÄÁËһЩÎÊÌ⣬ºÜżȻµÄ˵³öÁËÒ»¸öÊÂÇ飬ÎұȽϸÐÐËȤÓÚÊǼǼһÏ£º
1£ºÎÒÃǶ¼ÖªµÀmysqlÏ µÄINNODBºÍMYISAMÁ½ÖÖÒýÇæ£¬ÆäÖÐINNODB¾ßÓÐÊÂÎï¹ÜÀí¡£ËùÒÔINNODBϲÙ×÷ºÍMYISAMϲÙ×÷£¬µ¥´¿µÄ´Ó²åÈëÊý¾Ý¿âÉÏ˵£¬INNDODBµÄ¿É¿¿£¬²éѯÉÏ˵MYISAMµÄÒª¿ì¡£
2£º»ùÓÚÉÏÃæµÄÌØÐÔ£¬ÒÔ¼°MYSQLjuyouµÄÖ÷´Ó»úÖÆ£¬ÎÒÃÇ¿ÉÒ ......
¡¡¡¡1006£ºMYSQL ´´½¨Êý¾Ý¿âʧ°Ü ......
Äã¿ÉÒÔ´´½¨Ò»¸öÎı¾Îļþ“pet.txt”£¬Ã¿Ðаüº¬Ò»¸ö¼Ç¼£¬Óö¨Î»·û(tab)°ÑÖµ·Ö¿ª£¬²¢ÇÒÒÔCREATE TABLEÓï¾äÖÐÁгöµÄÁдÎÐò¸ø³ö¡£¶ÔÓÚ¶ªÊ§µÄÖµ(ÀýÈçδ֪µÄÐԱ𣬻òÈÔÈ»»î×ŵ͝ÎïµÄËÀÍöÈÕÆÚ)£¬Äã¿ÉÒÔʹÓÃNULLÖµ¡£ÎªÁËÔÚÄãµÄÎı¾ÎļþÖбíʾÕâЩÄÚÈÝ£¬
ʹÓÃ\N£¨·´Ð±Ïߣ¬×ÖĸN£©¡£ÀýÈ磬WhistlerÄñµÄ¼Ç¼ӦΪ(ÕâÀïÖµÖ® ......