ΪʲôÎÒ´æÔÚmysqlÖеÄijһÁеÄֵȫÊÇMEMO
ΪʲôÎÒ´æÔÚmysqlÖеÄijһÁеÄֵȫÊÇMEMO
ÄÄλ´ó¸ç°ïÎÒ½²Ã÷°×Ò»µã°¡
Ïêϸ˵Ã÷Çé¿ö£¬ÁÐÀàÐÍÊÇʲô £¿
DESC TT
ÄãÔÚʲô¹¤¾ßÖп´µÄ£¿
¹ÊÕÏÅųýʱ£¬Äã¿ÉÒÔÓãͣ٣ӣѣ̵ÄÃüÁ¾ß±È½ÏÖ±¹Û¡£
mysql-front
¸Ã×ֶεÄֵΪ text¡£
ÊDz»ÊÇÓëtextµÄ´æ´¢ÓÐʲô¹ØÏµ°¡
Â¥ÉϵĴó¸ç ÄÇÔõÑù²ÅÄÜ¿´µ½¾ßÌåÖµ°¡£¿£¿
¶¥
Ïà¹ØÎÊ´ð£º
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......
ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏÂ
Ö±½ÓÓÃMYSQLDUMP±¸·Ý
OR
ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý
Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£
http://dev.mysql.com/doc/re ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:
<?php
$str="select * from product wh ......