MySQLÊý¾Ý¿âÎļþ½éÉÜ
±¾ÎÄÁ´½Óhttp://www.chysoft.net/files/article_234.htm ¸ü¶à×ÊѶÇë½øÈëwww.chysoft.net
mysqlµÄÊý¾Ý´¢´æÄ¿Â¼ÔÚmysqlµÄÅäÖÃÎļþmy.iniÎļþÉèÖ㬸ñʽÈçÏ£º
# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = d:/cyoa/mysql_cy/
datadir = d:/cyoa/mysql_cy/data/
ÆäÖÐdatadirĿ¼¶¨ÒåÁËmysqlµÄÊý¾Ý´æ´¢Î»Öã¬MySQLµÄÿ¸öÊý¾Ý¿â¶¼¶ÔÓ¦´æ·ÅÔÚÒ»¸öÓëÊý¾Ý¿âͬÃûµÄÎļþ¼ÐÖÐ(¸ÃĿ¼ÏÂdatadir²ÎÊý¶ÔÓ¦µÄĿ¼ÏÂ)£¬MySQLÊý¾Ý¿âÎļþ°üÀ¨MySQLËù½¨Êý¾Ý¿âÎļþºÍMySQLËùÓô洢ÒýÇæ´´½¨µÄÊý¾Ý¿âÎļþ¡£
MySQLÈç¹ûʹÓÃMyISAM´æ´¢ÒýÇæ£¬Êý¾Ý¿âÎļþÀàÐ;ͰüÀ¨.frm¡¢.MYD¡¢.MYI
MySQLÈç¹ûʹÓÃInnoDB´æ´¢ÒýÇæ£¬Êý¾Ý¿âÎļþÀàÐ;ͰüÀ¨.frm¡¢ibdata1¡¢.ibd£¬´æ·ÅλÖÃÓÐÁ½¸ö£¬ibdata1¡¢.ibdÎļþĬÈÏ´æ·ÅλÖÃÊÇMySQL°²×°Ä¿Â¼ÏµÄdataÎļþ¼Ð
1¡¢MySQL´´½¨²¢¹ÜÀíµÄÊý¾Ý¿âÎļþ£º
.frmÎļþ£º´æ´¢Êý¾Ý±íµÄ¿ò¼Ü½á¹¹£¬ÎļþÃûÓë±íÃûÏàͬ£¬Ã¿¸ö±í¶ÔÓ¦Ò»¸öͬÃûfrmÎļþ£¬Óë²Ù×÷ϵͳºÍ´æ´¢ÒýÇæÎ޹أ¬¼´²»¹ÜMySQLÔËÐÐÔÚºÎÖÖ²Ù×÷ϵͳÉÏ£¬Ê¹ÓúÎÖÖ´æ´¢ÒýÇæ£¬¶¼ÓÐÕâ¸öÎļþ¡£
³ýÁ˱ØÓеÄ.frmÎļþ£¬¸ù¾ÝMySQLËùʹÓõĴ洢ÒýÇæµÄ²»Í¬£¨MySQL³£ÓõÄÁ½¸ö´æ´¢ÒýÇæÊÇMyISAMºÍInnoDB£©£¬´æ´¢ÒýÇæ»á´´½¨¸÷×Ô²»Í¬µÄÊý¾Ý¿âÎļþ¡£
.MYDÎļþ£º¼´MY Data£¬±íÊý¾ÝÎļþ
.MYIÎļþ£º¼´MY Index£¬Ë÷ÒýÎļþ
.logÎļþ£ºÈÕÖ¾Îļþ
2¡¢InnoDB²ÉÓñí¿Õ¼ä£¨tablespace£©À´¹ÜÀíÊý¾Ý£¬´æ´¢±íÊý¾ÝºÍË÷Òý£¬
InnoDBÊý¾Ý¿âÎļþ£¨¼´InnoDBÎļþ¼¯£¬ib-file set£©,¸ÃÎļþÒ»°ã´æÔÚÔÚmysqlµÄÊý¾ÝĿ¼Ï£¬È磺ibdata1¡¢ibdata2µÈϵͳ±í¿Õ¼äÎļþ£¬´æ´¢InnoDBϵͳÐÅÏ¢ºÍÓû§Êý¾Ý¿â±íÊý¾ÝºÍË÷Òý£¬ËùÓÐ±í¹²ÓÃ.ibdÎļþ£ºµ¥±í±í¿Õ¼äÎļþ£¬Ã¿¸ö±íʹÓÃÒ»¸ö±í¿Õ¼äÎļþ£¨file per table£©£¬´æ·ÅÓû§Êý¾Ý¿â±íÊý¾ÝºÍË÷Òý¡£
3¡¢ÈÕÖ¾Îļþ£º ib_logfile1¡¢ib_logfile2
¸ü¶à>>
Ïà¹ØÎĵµ£º
½ØÈ¡province×Ö·û´®ÖеÚÒ»¸ö<br>ǰµÄ×Ö·û´®¡«£¡
update lcjd
set `province` = substring_index( `province` , '<br>', '1' );
ÔÚÐèÒªÌí¼Ó‘0’µÄλÖÃÌí¼ÓÒ»¸ö‘0’
update lcjd
set lc_name2 = concat('0', lc_name2)
WHERE length(lc_name2) = 3
http://www.sqlstudy.com/s ......
·Ç³£³£Óõģº¾µäµÄMYSQLÓï¾ä…… php¿ªÔ´
ÕâÕæÊÇÒ»¸öºÃ¶«Î÷£ºÑ§Ï°ºÃÁ˺ÜÊÜÓõÄŶ……
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)php¿ªÔ´
Ê×ÏÈ,¼òÒ ......
<?php
/* vim: set expandtab tabstop=4 shiftwidth=4 foldmethod=marker: */
//===========================================
// ³ÌÐò£º mysql-Based Session Class
// ¹¦ÄÜ£º »ùÓÚmysql´æ´¢µÄ Session ¹¦ÄÜÀà
// ×÷Õß: yejr
// ÍøÕ¾: http://imysql.cn
// ʱ¼ä: 2007- ......
¸ÃÁ¬½Ó·½Ê½²ÉÓÃRPCÀ´·µ»ØÊý¾Ý¿â²éѯ½á¹û¡£
1.Ê×ÏÈÊÇ´´½¨ÆÕͨµÄGWT-EXT¹¤³Ì¡£¿ÉÒԲο¼1http://www.ibm.com/developerworks/cn/java/j-lo-gwtext1/#resources
ϵÁÐ Èë ÃÅ ½Ì³Ì¡£¾ßÌåͨѶ¹ý³Ì·þÎñÒ²¿É²Î¿¼ÉÏÊöµÄ×îºó²¿·Ö˵Ã÷¡£
2. ½ÓÏÂÀ´¾ÍÊÇÒª´´½¨GWT Remote ServiceÁË£¬ÔÚÔÓй¤³ÌÉÏnew-&g ......
Linux ±àÒë°²×° MYSQL 5.1 Óë Innodb
±àÒëmysql5
´úÂë:
./configure \
--prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock \
--with-extra-charsets=all \
--with-charset=utf8 \
- ......