MySQLѧϰ±Ê¼Ç
mysql·þÎñÆ÷°²×°ÅäÖãº
1. sudp apt-get install mysql-server-5.0
2. ´´½¨¿âsecond_proxy, ΪsecProxyÌí¼ÓÓû§£ºgrant all privileges on second_proxy.* to secProxy@'%' identified by 'passwd';
3. ÉèÖÃmysql.user±íÈçÏ£º
+-----------+------------------+-------------------------------------------+
| Host | User | Password |
+-----------+------------------+-------------------------------------------+
| % | root | *D0CC270F9B91B4CF3D13B5D56E1E52A9F7C001B1 |
| localhost | debian-sys-maint | *F6484D4F45B78E2CE99845B5D54DED451834E427 |
| % | secProxy | *B67F64B96B21AA1CDEE83C49A6DB23837F095FD9 |
+-----------+------------------+-------------------------------------------+
ÁÙʱÊý¾Ý£ºlocalhost | root | *D0CC270F9B91B4CF3D13B5D56E1E52A9F7C001B1 |
4. sudo vim /etc/mysql/my.cnf, ÐÞ¸Äbind-address = 0.0.0.0
5. ÖØÆðsudo /etc/init.d/mysql restart
±¨±íÊÂÀý:
http://dev.mysql.com/tech-resources/articles/ddws/index.html
http://www.gizmola.com/blog/archives/63-PHPlot,-MySQL-and-the-Dark-Ages-of-Camelot.html
²éѯһÌ죺
select * from table where to_days(column_time) = to_days(now());
select * from table where date(column_time) = curdate();
²éѯһÖÜ£º
select * from table where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(column_time);
²éѯһ¸öÔ£º
select * from table where DATE_SUB(CURDATE(), INTERVAL INTERVAL 1 MONTH) <= date(column_time);
ÒÔÿʮ·ÖÖÓΪһ×é
set @t
Ïà¹ØÎĵµ£º
2009-12-08 18:53
sql½Å±¾ÊÇ°üº¬Ò»µ½¶à¸ösqlÃüÁîµÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ½«ÕâЩsql½Å±¾·ÅÔÚÒ»¸öÎı¾ÎļþÖУ¨ÎÒÃdzÆ֮Ϊ“sql½Å±¾Îļþ”£©£¬È»ºóͨ¹ýÏà¹ØµÄÃüÁîÖ´ÐÐÕâ¸ösql½Å±¾Îļþ¡£»ù±¾²½ÖèÈçÏ£º
1¡¢´´½¨°üº¬sqlÃüÁîµÄsql½Å±¾Îļþ
ÎļþÖаüº¬Ò»Ð©ÁеÄsqlÓï¾ä£¬Ã¿ÌõÓï¾ä×îºóÒÔ;½á⣬ÎļþÄÚÈÝʾÀýÈçÏ£º
--´´½ ......
mysqlÆô¶¯ºÍ¹Ø±ÕÔ¼ÊøµÄ·½·¨(FOREIGN_KEY_CHECKS)
2009-07-06 16:43
MySQL»¹ÔÊý¾Ý¿â£¬½ûÓúÍÆôÓÃÍâ¼üÔ¼ÊøµÄ·½·¨(FOREIGN_KEY_CHECKS)
ÓÐʱ»¹ÔÊý¾Ý¿âʱ£¬ÒòΪ±íÓÐÔ¼Êøµ¼ÖÂ40014´íÎ󣬿ÉÒÔͨ¹ý¹Ø±ÕÍâ¼üÔ¼Êø£¬»¹Ô³É¹¦Ê±ÔÙÆôÓÃ
½ûÓÃ
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0
ÆôÓÃ
S ......
mysqlÖÐchar¡¢varchar¡¢nvarcharÊý¾ÝÀàÐ͵ÄÓ÷¨Çø±ð:
˵Ã÷:
1¡¢char:
¹Ì¶¨³¤¶ÈµÄ·Ç Unicode ×Ö·ûÊý¾Ý£¬×î´ó³¤¶ÈΪ 8,000 ¸ö×Ö·û¡£
2¡¢varchar£º
¿É±ä³¤¶ÈµÄ·Ç Unicode Êý¾Ý£¬×Ϊ 8,000 ¸ö×Ö·û¡£
3¡¢nvarchar£º
¿É±ä³¤¶È Unicode Êý¾Ý£¬Æä×î´ó³¤¶ÈΪ 4,000 ×Ö·û¡£  ......
Êý¾Ý¿âµÄÒ»ÕűíÀïÃæ´æÁ˹ØÓÚһ̨É豸µÄ±¸·ÝÅäÖÃÐÅÏ¢£¬ÀàÐÍÊÇbit£¬Ö÷Òª¾ÍÊÇÊÇ·ñÒѾÅäÖã¬ÉèÖõÄʱºòÈ¡ÖµÊÇtrue,false,»¹ÊÇ0£¬1ÄØ£¿
¾À½áÁË°ëÌ죬¶¯Ê־ͺÃÁË£¬ÊÇ0£¬1£¬¶ø·Çtrue,false£¬
¸üÐÂÓï¾äÈçÏÂ
update table_a
set configBaked= 0
where id in (2,3,4)
......
Ê×ÏÈÈ¥MySQL¹ÙÍøÏÂÔØMySQL connector/C++
http://dev.mysql.com/downloads/connector/cpp/1.0.html
ÏÂÔصڶþ¸ö°ü£¬windows32λ·Ç°²×°°æ£¨¸öÈ˾õµÃÕâ¸ö°ü¸É¾»£©¡£Ä¿Ç°µÄ°æ±¾ÊÇConnector/C++ 1.0.5¡£
Windows (x86, 32-bit), ZIP Archive
(mysql-connector-c++-noinstall-1.0.5-win32.zip)
½«Õû¸ö°ü½âѹµ½ÏîÄ¿Îļþ¼Ðϵ ......