MySql²éÑ¯È¥ÖØ
ÌâÍâ»°,¶ÔÄãÃÇÀ´ËµºÜ¼òµ¥,¿ÉÊǶÔÎÒÀ´ËµºÜÖØÒª,ËùÒÔ100·Ö,лл!²âÊÔͨ¹ý¾Í½áÌù¸ø·Ö
ÎÊÌâÊÇÕâÑùµÄ:
±ít_user
user_mobile //Óû§ÊÖ»úºÅ
service_id //·þÎñ±àºÅ 1-¸ß¼¶Óû§,2ÆÕͨÓû§
//ÓÉÓÚÀúÊ·ÔÒò,»áÔ±¿ÉÒÔ¼ÈÊǸ߼¶Ò²ÊÇÆÕͨ,Êý¾Ý²»¿ÉÒÔɾ³ý»ò¸ü¸Ä.
//±íµÄÊý¾Ý
+-------------+------------+
| user_mobile | service_id |
+-------------+------------+
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 1 | 2 |
| 2 | 2 |
| 3 | 2 |
| 4 | 2 |
| 5 | 2 |
| 6 | 1 |
| 6 | 2 |
+-------------+------------+
//ÏëµÃµ½µÄÊý¾Ý
+-------------+------------+
| user_mobile | service_id |
+-------------+------------+
| 1 &n
Ïà¹ØÎÊ´ð£º
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
ÎÒÐèÒª½«Êý¾Ý¿âµÄ±íµ¼³öÀ´£¬ÏÖÔÚ¿âÀïµÄ×Ö·û¼¯ÊÇÂҵģ¬ÎÒÏëÏÈÉèÖÃlatin1¸ñʽµ¼³öÀ´£¬Äܲ»ÄܸæËßÎÒÔõô½øÈëmysqlÃüÁî·ûÏ£¿ºÃÏñÊDZØÐë½øÈëmysqlÃüÁî·ûϲÅÐУ¬ÎÒµÄϵͳÊÇlinux£¬ÎÒÓÃlocate mysql ²éµ½Á˺öàĿ¼£¬²»Öª ......