Linux»·¾³ÏÂMySQLÊý¾Ý¿â´óÐ¡Ð´Çø·ÖÎÊÌâ
1¡¢LinuxÏÂmysql°²×°ÍêºóÊÇĬÈÏ£ºÇø·Ö±íÃûµÄ´óСд£¬²»Çø·ÖÁÐÃûµÄ´óСд£»
2¡¢ÓÃrootÕʺŵǼºó£¬ÔÚ/etc/my.cnf ÖеÄ[mysqld]ºóÌí¼ÓÌí¼Ólower_case_table_names=1£¬ÖØÆôMYSQL·þÎñ£¬ÕâʱÒÑÉèÖóɹ¦£º²»Çø·Ö±íÃûµÄ´óСд£»
lower_case_table_names²ÎÊýÏê½â£º
lower_case_table_names = 0
ÆäÖÐ 0£ºÇø·Ö´óСд£¬1£º²»Çø·Ö´óСд
MySQLÔÚLinuxÏÂÊý¾Ý¿âÃû¡¢±íÃû¡¢ÁÐÃû¡¢±ðÃû´óСд¹æÔòÊÇÕâÑùµÄ£º
1¡¢Êý¾Ý¿âÃûÓë±íÃûÊÇÑϸñÇø·Ö´óСдµÄ£»
2¡¢±íµÄ±ðÃûÊÇÑϸñÇø·Ö´óСдµÄ£»
3¡¢ÁÐÃûÓëÁеıðÃûÔÚËùÓеÄÇé¿öϾùÊǺöÂÔ´óСдµÄ£»
4¡¢±äÁ¿ÃûÒ²ÊÇÑϸñÇø·Ö´óСдµÄ£»
MySQLÔÚWindows϶¼²»Çø·Ö´óСд¡£
3¡¢Èç¹ûÏëÔÚ²éÑ¯Ê±Çø·Ö×Ö¶ÎÖµµÄ´óСд£¬Ôò£º×Ö¶ÎÖµÐèÒªÉèÖÃBINARYÊôÐÔ£¬ÉèÖõķ½·¨ÓжàÖÖ£º
A¡¢´´½¨Ê±ÉèÖãº
CREATE TABLE T(
A VARCHAR(10) BINARY
);
B¡¢Ê¹ÓÃalterÐ޸ģº
ALTER TABLE `tablename` MODIFY COLUMN `cloname` VARCHAR(45) BINARY;
C¡¢mysql table editorÖÐÖ±½Ó¹´Ñ¡BINARYÏî¡£
±¾ÎÄ×ªÔØ×Ô£ºhttp://www.oklinux.cn/html/sql/other/20080426/52340.html
Ïà¹ØÎĵµ£º
ÕªÒª
ÎÒÃÇÔÚÕâÀïÌÖÂÛµÄÊǶÔǶÈëʽlinuxϵͳµÄÆô¶¯¹ý³ÌµÄÊä³öÐÅÏ¢µÄ×¢ÊÍ£¬Í¨¹ýÎÒÃǵÄÌÖÂÛ£¬´ó¼Ò»á¶ÔǶÈëʽlinuxÆô¶¯¹ý³ÌÖгöÏֵġ¢ÒÔǰ¸Ð¾õÊìϤµÄ¡¢µ«È´ÓÖËÆÊǶø·ÇµÄ¶«Î÷ÓÐÒ»¸öÈ·ÇеÄÁ˽⣬²¢ÇÒÄÜÁ˽⵽ÕâЩÊä³öÐÅÏ¢µÄÀ´ÁúÈ¥Âö¡£
ǶÈëʽlinuxµÄÆô¶¯ÐÅÏ¢ÊÇÒ»¸öºÜÖµµÃÎÒÃÇÈ¥ºÃºÃÑо¿µÄ¶«Î÷£¬ËüÄܽ«Ò»·ùËõӰͼ³ÊÏÖÔÚÎÒà ......
ÔÚWindowsÏ£¬Îļþϵͳ½á¹¹ÊÇÒ»¸öÔÙÆÕͨ²»¹ýµÄÃû´ÊÁË¡£²»¹ý£¬ÔÚLinuxÏ£¬ÎļþϵͳÓÐÐ©Çø±ð¡£ Îļþ½á¹¹ÊÇÎļþ´æ·ÅÔÚ´ÅÅ̵ȴ洢É豸ÉϵÄ×éÖ¯·½·¨¡£Ò»¸öÎļþϵͳµÄºÃ»µÖ÷ÒªÌåÏÖÔÚ¶ÔÎļþºÍĿ¼µÄ×éÖ¯ÉÏ¡£Ä¿Â¼ÌṩÁ˹ÜÀíÎļþµÄÒ»¸ö·½±ã¶øÓÐЧµÄ;¾¶¡£ÎÒÃÇÄܹ»´ÓÒ»¸öĿ¼Çл»µ½ÁíÒ»¸öĿ¼ ......
I/OÖØ¶¨ÏòÏê½â¼°Ó¦ÓÃʵÀý
1¡¢ »ù±¾¸ÅÄÕâÊÇÀí½âºóÃæµÄ֪ʶµÄǰÌᣬÇëÎñ±ØÀí½â£©
a¡¢ I/OÖØ¶¨Ïòͨ³£Óë FDÓйأ¬shellµÄFDͨ³£Îª10¸ö£¬¼´ 0¡«9£»
b¡¢ ³£ÓÃFDÓÐ3¸ö£¬Îª0£¨stdin£¬±ê×¼ÊäÈ룩¡¢1£¨stdout£¬±ê×¼Êä³ö£©¡¢2£¨stderr£¬±ê×¼´íÎóÊä³ö£©£¬Ä¬ÈÏÓëkeyboard¡¢monitor¡¢monitorÓйأ»
c¡¢ Óà < À´¸Ä±ä¶Á½øµÄ ......
1¡¢/etc/modules.confÎļþ£º
ÔÚDebian/UbuntuÅÉϵÖÐÃûΪ/etc/modules£¬ÔÚÓÐЩLinuxϵͳÖÐÒ²ÓÃÃû/etc/conf.modules¡£¸ÃÅäÖÃÎļþ¶¨ÒåÁ˸÷ÖÖÐèÒªÔÚÆô¶¯Ê±¼ÓÔØµÄÄ£¿éµÄ²ÎÊýÐÅÏ¢¡£ÕâÀïÖ÷Òª×ÅÖØÌÖÂÛ¹ØÓÚÍø¿¨µÄÅäÖá£ÔÚʹÓÃLinux×öÍø¹ØµÄÇé¿öÏ£¬Linux·þÎñÆ÷ÖÁÉÙÐèÒªÅäÖÃÁ½¿éÍø¿¨¡£ÎªÁ˼õÉÙÆô¶¯Ê±¿ÉÄܳö ......