²»ÖØÆômysqlʵÏÖÓëosµÄʱ¼ä±£³ÖÒ»ÖÂ
×öjava¿ª·¢ ÓÃlinuxµÄmysql ÓÉÓÚÉæ¼°¶à¹úµÄÊ±ÇøÉèÖà £¬ÓÐʱºò±ØÐëÐ޸ĻúÆ÷µÄÊ±Çø£¬ Õâʱ±ØÐëÍ¬Ê±ÖØÆômysql £¨±¾ÏîĿҪÇómysqlµÄʱ¼ä±ØÐëºÍos±£³ÖÒ»Ö£© ÎÊÓÐûÓÐÆäËû·½·¨±ÜÃâÕâ¸ö·½·¨ £¨²»ÈÃmysqlÖØÆô java¹¤³Ìÿ´ÎÖØÆô»¨Ê±¼ä¹ý³¤ £¬ÐèÒª20·Ö ¡£ Ï£ÍûÄÜÓÐÆäËû·½·¨ ²»ÖØÆômysqlʵÏÖÓëosµÄʱ¼ä±£³ÖÒ»Ö£¬ ±ÈÈçÔËÐÐÒ»¸öÃüÁ£¿£¿ £©
ÄǸöÌû×Ó½ö½öÊÇ·ÖÎö ûÓÐÌá³öÈçºÎ½â¾öÒýÓà ÄǸöÌû×Ó½ö½öÊÇ·ÖÎö ûÓÐÌá³öÈçºÎ½â¾öÒýÓà ͨ¹ýϵͳ±äÁ¿ time_zone ¿ÉÒԵõ½µ±Ç°Êý¾Ý¿âµÄÊ±ÇøÉèÖᣠmysql> select @@time_zone; +-------------+ | @@time_zone | +-------------+ | SYSTEM | +-------------+ 1 row in set (0.00 sec) mysql> »¹ÓÐ#8Â¥µÄ²âÊÔ¡£ ÄãµÄÒâ˼ set global time_zone='CST';£¿£¿£¿£¿ ²»ÖªµÀcstÈçºÎÌæ»» ÎҼǵà gtk-7£º00 ¿ÉÒÔ±ð±»ÕâÑùÌæ»» set global time_zone='gtk-7£º00'; ÄãÓÐûÓп´8Â¥µÄÀý×Ó£¿£¡ mysql> set @@global.time_zone, = '+0:00'; Query OK, 0 rows affected (0.00 sec) Ö»ÄÜÓà set @@session.time_zone = '+3:00'; ÉÏÃæµÄʧ°ÜµÄ ·´¸´²âÊÔÂ¥ÉÏ·½·¨Êdzɹ¦µÄŶ windowsÐèÒª¿ª·À»ðǽÀýÍâµÄ¶Ë¿Ú linuxÐèÒª¹Ø±Õ·À»ðǽ £¨ÄÚÍø£©---------²»ÖªµÀÓÐûÓÐʲô·½·¨¿ÉÒÔÈÃlinuxÒ²¿ª3306ÈÃÍâµØ»úÆ÷·ÃÎÊ ²»Óÿª·½·À»ðÇ¿ ºÜ¼òµ¥¡£×¨ÃŸãÒ»¸öʱ¼ä·þÎñÆ÷£¬¶¨Ê±Í¬²½¸÷¸ö»úÆ÷µÄʱ¼ä¾ÍÐÐÁË¡£ Â¥ÉÏÂ¥ÉÏ...ÄǸöÌû×ÓÒѾ½â¾ö
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8 ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
try { sql::Driver *driver; sql::Connection *con; //´´½¨Á¬½Ó driver = get_driver_instance(); con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......