Mysql ²»Ã÷ÔÒò¾³£ÖØÆô£¬Ôì³ÉÎÞ·¨·ÃÎÊ
ÄÄλÈÊÐÖ°ïæ¸ø¿´¿´ÏÂÃæÊ²Ã´ÔÒò£¿£¿£¿
090918 16:50:09 [Note] /usr/sbin/mysqld-max: Normal shutdown
090918 16:50:11 InnoDB: Starting shutdown...
090918 16:50:15 InnoDB: Shutdown completed; log sequence number 0 1179760410
090918 16:50:15 [Note] /usr/sbin/mysqld-max: Shutdown complete
090918 16:50:15 mysqld ended
090918 16:50:15 mysqld started
090918 16:50:15 [Warning] Could not increase number of max_open_files to more than 65535 (request: 1049086)
090918 16:50:16 InnoDB: Started; log sequence number 0 1179760410
090918 16:50:16 [Warning] 'user' entry 'root@demo' ignored in --skip-name-resolve mode.
090918 16:50:16 [Warning] 'user' entry '(null)@demo' ignored in --skip-name-resolve mode.
090918 16:50:16 [Warning] 'user' entry 'root@demo' ignored in --skip-name-resolve mode.
090918 16:50:16 [Warning] 'db' entry 'demo root@demo' ignored in --skip-name-resolve mode.
090918 16:50:16 [Warning] 'db' entry 'demo root@demo' ignored in --skip-name-resolve mode.
090918 16:50:16 [Note] /usr/sbin/mysqld-max: ready for connections.
Version: '5.1.7-beta-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Max (GPL)
090918 16:50:09 [Note] /usr/sbin/mysqld-max: Normal shutdown <
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿
¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......