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

MySQL¹ØÓÚÏÔʾʱ¼äµÄÎÊÌâ

¸÷λǰ±²£¬ÔõÑùÄܵõ½ÏµÍ³Ê±¼ä¾ßÌ嵽΢Ã룿

ÏÂÃæµÄÕâЩ¶¼²»Ðа¡...
mysql> SELECT CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP;

+--------------+--------------+---------------------+

| CURRENT_DATE | CURRENT_TIME | CURRENT_TIMESTAMP  |

+--------------+--------------+---------------------+

| 2005-05-31  | 21:40:18    | 2005-05-31 21:40:18 |

+--------------+--------------+---------------------+


now()ºÃÏñÒ²²»ÐУ¿

ÔõÑùÄܵõ½ÀÛËÆÓÚ 2009-11-12 11:24:38.324122µÄʱ¼äÄØ?

ûÓÐÕâ¸öµÄº¯Êý£¬ÔÚÓ¦Óòã½â¾ö°É

ÒýÓÃ
ûÓÐÕâ¸öµÄº¯Êý£¬ÔÚÓ¦Óòã½â¾ö°É

ûÓÐÓ¦Óã¬ÎÒ×Ô¼º´Ó²Î¿¼ÊÖ²áÀïҲûÕÒµ½¡£ÏÖÔÚ¾ÍÊÇÏëÖ´ÐÐÓï¾ä£¬½¨Ò»¸ö±í£¬ÆäÖÐÁ½¸ö×Ö¶ÎÊÇÖ´ÐÐÓï¾äµÄ¿ªÊ¼Ê±¼äºÍ½áÊøÊ±¼ä¡£×îºóÓÃtimediffËãÒ»ÏÂÓÃʱ£¬updateµ½±íµÄ×îºóÒ»¸ö×Ö¶ÎÀïÈ¥¡£ÎªÊ²Ã´timediff¶¼¿ÉÒÔË㵽΢Ã룿

ÕæµÄÏñstoryxsj˵µÄÕâÑùô£¿

ÒýÓÃ
ÕæµÄÏñstoryxsj˵µÄÕâÑùô£¿


ȷʵûÓÐÕâÑùµÄº¯Êý

ÒýÓÃ
ÒýÓà 4 Â¥ lanix µÄ»Ø¸´:
ÕæµÄÏñstoryxsj˵µÄÕâÑùô£¿


ȷʵûÓÐÕâÑùµÄº¯Êý

ºÃ°É£¬Ð»Ð»Á½Î»~ ÎÒÔÙÏëÏë±ðµÄ°ì·¨...

mysql ÖÐÖ»µ½ Ãë¼¶¡£

ÒýÓÃ
mysql ÖÐÖ»µ½ Ãë¼¶¡£


лл~ OSÓ¦¸Ã¿ÉÒÔ°É~
{{----}


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ÉÊÇÎÒÕÒ ......

MYSQL ÈçºÎÐÞ¸ÄBLOBÀàÐ͵ÄÊý¾Ý?

ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿

¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......

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

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

mysqlÃüÁîÐÐģʽÏÂ: ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ