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

²é¿´mysql°æ±¾µÄËÄÖÖ·½·¨

ת×Ô£ºhttp://www.yayu.org/look.php?id=113
1£ºÔÚÖÕ¶ËÏ£ºmysql -V¡£
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
[shengting@login ~]$ mysql -V
mysql  Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686)
    2£ºÔÚmysqlÖУºmysql> status;
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
mysql> status;
--------------
mysql  Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686)
Connection id:          416
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         3.23.56-log
Protocol version:       10
Connection:             Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX socket:            /tmp/mysql_3311.sock
Uptime:                 62 days 21 hours 21 min 57 sec
Threads: 1  Questions: 584402560  Slow queries: 424  Opens: 59664208  Flush tables: 1  Open tables: 64 Queries per second avg: 107.551
    3£ºÔÚhelpÀïÃæ²éÕÒ
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
[shengting@login ~]$ mysql --help | grep Distrib
mysql  Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686)
    4£ºÊ¹ÓÃmysqlµÄº¯Êý
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
mysql> select version();
+-------------+
| version()   |
+-------------+
| 3.23.56-log |
+-------------+
1 row in set (0.00 sec)


Ïà¹ØÎĵµ£º

MYSQLѧϰ

MYSQLÓжàÖÖ´æ´¢ÒýÇæºÍ±íÀàÐÍ£¬InnoDBºÍBDBÖ§³ÖÊÂÎñ£¬Èç¹ûҪʹÓÃÊÂÎñ£¬±íµÄÀàÐ;ÍÓ¦¸ÃÊÇInnoDB.
Ìá¸ß±íµÄÐÔÄÜ£º
1¡¢ÓÃ×îСµÄÊý¾ÝÀàÐÍ¡£Õ¼ÓÿռäС£¬½ÚÊ¡´ÅÅ̿ռäºÍÄÚ´æ¡£
2¡¢±í¸ñµÄÖ÷Ë÷ÒýÒª¾¡¿ÉÄܵĶ̣¬ÒÔÃ÷ÏÔÌá¸ßЧÂÊ¡£
3¡¢Ë÷Òý×îºÃ½¨ÔÚΨһµÄÁÐÉÏ£¬Ë÷ÒýÔ½¶Ì£¬ËÙ¶ÈÔ½¿ì¡£
4¡¢¶àÁÐË÷Òý±ØÐë°üº¬×î×ó±ßµÄǰ׺²ÅÓÐЧ¡£ ......

sqliteºÍpdo mysqlµÄÊý¾Ý¿â²Ù×÷

½ñÌìµÄѧϰÄÚÈÝÊÇsqliteºÍPDO mysql¡£
ÓÃ×Ô¼ºµÄ»°ËµËµÁ½¸ö¶«Î÷°É£º
sqliteËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......

php+mysql±àÂëÎÊÌâ×ܽá

Òª²»³öÏÖÂÒÂ룬¾ÍÒª±£³ÖÊý¾Ý¿âºÍÒ³ÃæµÄ±àÂë¸ñʽһÖÂ.ÎÒÈ«²¿Ê¹ÓÃutf-8µÄ±àÂë.
Ê×ÏÈÒ³Ãæ:
 1. ½«ÎļþÓÃUE´ò¿ª,½«ÎļþÁí´æÎªUTF-8ÎÞBOM¸ñʽ.ºÜ¶à±à¼­Æ÷¶¼¿ÉÓÃ.
 2.ʹÓà header("content-type:text/html;¡¡charset=utf-8"); Ç¿ÖÆ×ª»»³Éutf-8µÄ±àÂë.
   Ò²¿ÉÒÔн¨Ò»¸öhead.php,ÈçÏÂ,ÔÚÒ³ÃæÖÐÓÃinclude( ......

mysqlÖ÷´ÓÊý¾Ý¿âͬ²½ºÍ×Ö·û¼¯ÎÊÌâ

1.mysqlÖ÷´ÓÊý¾Ý¿âͬ²½ÎÊÌâ
 
ÔÚʹÓÃmysql 5.0 Ö÷´ÓÊý¾Ý¿âͬ²½Ê±Óöµ½ÎÊÌâһЩÎÊÌ⣺
ÔÚÖ÷´ÓÊý¾Ý¿âͬ²½Ê±£¬ÎÒÃÇ¿ÉÄÜ»áÑ¡ÔñÄÄЩÊý¾Ý¿âÒªÇóͬ²½£¬¶øÄÇЩÊý¾Ý¿âºöÊÓ£¬ÕâÁ½¸ö¹¦ÄÜÊÇ¿¿/etc/my.cnfÎļþÖеÄÁ½¸ö¼üÃû binlog_do_db ºÍ binlog_ignore_db À´ÊµÏÖµÄ
binlog_do_db = ÌîдÐèҪͬ²½µÄÊý¾Ý¿â£¬¶à¸öÊý¾Ý¿âÔòÓÃ&lsqu ......

MysqlÂÒÂë

PHP ´æÈ¡ MySQL ÂÒÂëÎÊÌâ
ÉÏһƪ / ÏÂһƪ  2007-06-04 03:33:50 / ¸öÈË·ÖÀࣺPHPѧϰ
²é¿´( 239 ) / ÆÀÂÛ( 0 ) / ÆÀ·Ö( 0 / 0 )
MySQL µÄ×Ö·û¼¯Ö§³Ö(Character Set Support)ÓÐÁ½¸ö·½Ã棺×Ö·û¼¯(Character set)ºÍÅÅÐò·½Ê½(Collation)¡£¶ÔÓÚ×Ö·û¼¯µÄÖ§³Öϸ»¯µ½Ëĸö²ã´Î: ·þÎñÆ÷(server)£¬Êý¾Ý¿â(database)£¬Êý¾Ý±í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ