mysql ´æ´¢¹ý³Ì
ÔÚmysqlµÄ´æ´¢¹ý³ÌÖУ¬ÔõôÅжÏÒ»¸ö±íÐèÒªÐÞ±í£¿£¿£¿£¿£¿£¿£¿
×î½üдÁËÒ»¸ö´æ´¢£¬Ã¿Ìì×Ô¶¯Ö´ÐÐʱ³öÏÖ¹ýÒòΪһ¸ö±íÐèÒªÐÞ¸´£¬¶øÎÞ·¨Ö´ÐеÄÎÊÌâ¡£
ÒòΪ±í±È½Ï´ó£¬ÐÞ±íÐèÒª½Ï³¤Ê±¼ä£¬Òò´Ë²»ÏëÿÌì¶¼ÐÞ±í£¬Ïë¼Ó¸öÅжϣ¬Èç¹û±í»µÁË£¬ÔòÐÞ±í¡£²»ÐèÒªÐÞ±íÔòÌø¹ýÖ´ÐÐÏÂÒ»¾ä¡£
ά»¤¼Æ»®?............
·¹ý.........
ÄÇλ¸ßÊÖ°ïÖúһϣ¬»¹ÊÇÕæÔÚ´æ´¢¹ý³ÌÀïû·¨ÊµÏÖÁË
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
ÈçºÎÓÃsql²é¿´±íµÄÁ㤶È
show create table xxx;
¿ÉÒÔ»ñµÃ½¨±íÃüÁÔÙ½øÐзÖÎö£¬Ó¦¸ÃÄܵõ½ÏëÒªµÄÐÅÏ¢
MySQL 5 ÒÔÉÏ£¬Äã¿ÉÒÔ´ÓÊý¾Ý×ÖµäÖв鵽
select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,DATA_TYPE,CHAR ......