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

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];
?>


Ïà¹ØÎĵµ£º

MySQLµÄ¼¸¸öÖØÒªÄ¿Â¼½éÉÜ

     MySQL°²×°Íê³Éºó²»ÏóSQL ServerĬÈϰ²×°ÔÚÒ»¸öĿ¼£¬ËüµÄÊý¾Ý¿âÎļþ¡¢ÅäÖÃÎļþºÍÃüÁîÎļþ·Ö±ðÔÚ²»Í¬µÄĿ¼£¬Á˽âÕâЩĿ¼·Ç³£ÖØÒª£¬ÓÈÆä¶ÔÓÚLinuxµÄ³õѧÕߣ¬ÒòΪ Linux±¾ÉíµÄĿ¼½á¹¹¾Í±È½Ï¸´ÔÓ£¬Èç¹û¸ã²»Çå³þMySQLµÄ°²×°Ä¿Â¼ÄǾÍÎÞ´Ó̸ÆðÉîÈëѧϰ¡£ÏÂÃæ¾Í½éÉÜÒ»ÏÂÕ⼸¸öĿ¼¡£
£¨1£©Êý¾Ý¿âĿ¼ ......

MySQLµÄ³£ÓòÙ×÷½éÉÜ

   ×¢Ò⣺MySQLÖÐÿ¸öÃüÁîºó¶¼ÒªÒԷֺţ»½áβ¡£
£¨1£©ÏÔʾÊý¾Ý¿â
mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.04 sec)
   Mysql¸Õ°²×°ÍêÓÐÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£ÆäÖУ¬mysql¿â·Ç³£ÖØÒª£¬ËüÀïÃæÓÐMyS ......

CentOSÏÂMysqlʵÏÖÊý¾Ý¿âÖ÷´Óͬ²½

http://www.ej38.com/showinfo/mysql-130795.html

CentOSÏÂMysqlʵÏÖÊý¾Ý¿âÖ÷´Óͬ²½
Ò»¡¢»·¾³
¡¡¡¡A·þÎñÆ÷£º 192.168.10.42    Ö÷·þÎñÆ÷master¡¡¡¡CentOS 5¡¡¡¡Mysql 5.1.34
¡¡¡¡B·þÎñÆ÷£º 192.168.10.68    ¸±·þÎñÆ÷slave¡¡¡¡¡¡CentOS 5¡¡¡¡Mysql 5.0.56
¶þ¡¢ÉèÖÃMas ......

Mysql ReplicationʵÏÖmysqlÖ÷´Ó¿â×Ô¶¯Í¬²½°²×°Ö¸ÄÏ

http://blog.csdn.net/zhangwenzhe/archive/2008/05/22/2470529.aspx
ÔÚ
MySQL 3.23.15
°æ±¾Ö®ºó
,MySQL
ÌṩÁËÊý¾Ý¿â¸´ÖƵŦÄÜ
,
¿ÉÒÔʵÏÖÁ½¸öÊý¾Ý¿âʵʱͬ²½
,
ÔöÇ¿ÁË
MySQL
Êý¾Ý¿âµÄÎȶ¨ÐÔ£¬¶øÇÒ¿ÉÒÔÔÚÆóÒµ¼¶Ó¦ÓõÄÊý¾Ý¿â²ãʵÏÖ
Cluster
£¬²»½ö´ó´óÌá¸ßÁË
mysql
µÄ°²È«ÐÔ£¬Í¬Ê±»¹¼õÇáÁË
DBA
´óÁ¿µÄ¹¤× ......

ÆäËûÊý¾Ý¿âÄ£ÄâʵÏÖmysqlµÄlimitÓï·¨

¼ÙÈçÎÒÓиöuser±í,ÎÒÏë²éѯ·ûºÏijЩÌõ¼þµÄµÚ50¸öÓû§¿ªÊ¼µÄ10¸öÓû§,ÇÒ²»ÄÜʹÓÃidºÅbetween andÄÇÑù²éѯ,Ó¦¸ÃÔõôдSQLÓï¾ä?
¡¡¡¡ÔÚmysqlÊý¾Ý¿âÖÐÓÐlimit,offsetÓï¾ä¿ÉÒÔ·½±ãµÄʵÏÖ,ÄÇôÔÚSQL serverÖÐÄØ?SQL ServerÊÇ·ñÖ§³ÖlimitºÍoffsetÓï¾äÄØ?
select top 10 * from
(select top 60 * from [user] order by userid) a ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ