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µÄÆô¶¯ÐÅÏ¢ÊÇÒ»¸öºÜÖµµÃÎÒÃÇÈ¥ºÃºÃÑо¿µÄ¶«Î÷£¬ËüÄܽ«Ò»·ùËõӰͼ³ÊÏÖÔÚÎÒà ......
LinuxÖ§³Ö¶àÖÖÎļþϵͳ£¬°üÀ¨ext2¡¢ext3¡¢vfat¡¢ntfs¡¢iso9660¡¢jffs¡¢romfsºÍnfsµÈ£¬ÎªÁ˶Ը÷ÀàÎļþϵͳ½øÐÐͳһ¹ÜÀí£¬LinuxÒýÈëÁËÐéÄâÎļþϵͳVFS(Virtual File System)£¬Îª¸÷ÀàÎļþϵͳÌṩһ¸öͳһµÄ²Ù×÷½çÃæºÍÓ¦Óñà³Ì½Ó¿Ú¡£
LinuxϵÄÎļþϵͳ½á¹¹ÈçÏ£º
LinuxÆô¶¯Ê ......
LinuxÄÚºËÔ´Âë·ÖÎö-Á´±í´úÂë·ÖÎö
·ÖÎöÈË£ºÓàÐñ
·ÖÎöʱ¼ä£º2005Äê11ÔÂ17ÈÕÐÇÆÚËÄ 11:40:10 AM
Óê ζȣº10-11¶È
±àºÅ£º1-4 Àà±ð£º×¼±¸¹¤×÷
Email£ºyuxu9710108@163.com
ʱ´ú±³¾°£º¿ªÊ¼ÔÚwww.linuxforum.net LinuxÄں˼¼ÊõÂÛ̳ÉÏÃæ·¢Ìù£¬ÔÚÍøÓѵİïæÏ£¬
½â¾öÁËһЩÎÊÌâ¡£
°æÈ¨ÉùÃ÷£º°æÈ¨±£Áô¡£±¾ÎÄÓÃ×÷ÆäËûÓà ......
ÔÚWindowsÏ£¬Îļþϵͳ½á¹¹ÊÇÒ»¸öÔÙÆÕͨ²»¹ýµÄÃû´ÊÁË¡£²»¹ý£¬ÔÚLinuxÏ£¬ÎļþϵͳÓÐÐ©Çø±ð¡£ Îļþ½á¹¹ÊÇÎļþ´æ·ÅÔÚ´ÅÅ̵ȴ洢É豸ÉϵÄ×éÖ¯·½·¨¡£Ò»¸öÎļþϵͳµÄºÃ»µÖ÷ÒªÌåÏÖÔÚ¶ÔÎļþºÍĿ¼µÄ×éÖ¯ÉÏ¡£Ä¿Â¼ÌṩÁ˹ÜÀíÎļþµÄÒ»¸ö·½±ã¶øÓÐЧµÄ;¾¶¡£ÎÒÃÇÄܹ»´ÓÒ»¸öĿ¼Çл»µ½ÁíÒ»¸öĿ¼ ......