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

²»ÖØÆô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ÈÃÍâµØ»úÆ÷·ÃÎÊ ²»Óÿª·½·À»ðÇ¿


ºÜ¼òµ¥¡£×¨ÃŸãÒ»¸öʱ¼ä·þÎñÆ÷£¬¶¨Ê±Í¬²½¸÷¸ö»úÆ÷µÄʱ¼ä¾ÍÐÐÁË¡£

Â¥ÉÏÂ¥ÉÏ...ÄǸöÌû×ÓÒѾ­½â¾ö


Ïà¹ØÎÊ´ð£º

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ 
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£

mysqlÃüÁîÐÐģʽÏÂ: ......

mysqlÖÐÎÄÂÒÂë - C/C++ / C++ ÓïÑÔ

mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......

vc++ ÓÃmysql¹Ù·½ connector ³ö´í - VC/MFC / Êý¾Ý¿â

try
{
sql::Driver *driver;
sql::Connection *con;
//´´½¨Á¬½Ó
driver = get_driver_instance();
con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ