按照MYSQL中的说明:
如果你在'!'后增加一个版本数字,该语法将仅在MySQL版本是等于或比使用的版本数字新时才执行: 
为什么我在PHPMYADMIN中执行SQL语句:/*!40101 SHOW CHARACTER SET  */;
结果这样:
您运行的 SQL 语句已经成功运行了。我当前的MYSQL版本为:version 4.1.21-community-nt 大于 40101,应该会执行的。而执行SQL语句:SHOW CHARACTER SET ,和上面的结果完全不同,为什么:Charset  Description  Default collation  Maxlen  
big5 Big5 Traditional Chinese big5_chinese_ci 2 
dec8 DEC West European dec8_swedish_ci 1 
cp850 DOS West European cp850_general_ci 1 
hp8 HP West European hp8_english_ci 1 
koi8r KOI8-R Relcom Russian koi8r_general_ci 1 
latin1 cp1252 West European latin1_swedish_ci 1 
latin2 ISO 8859-2 Central European latin2_general_ci 1 
swe7 7bit Swedish swe7_swedish_ci 1 
ascii US ASCII ascii_general_ci 1 
ujis EUC-JP Japanese ujis_japanese_ci 3 
sjis Shift-JIS Japanese sjis_japanese_ci 2 
hebrew ISO 8859-8 Hebrew hebrew_general_ci 1 
tis620 TIS620 Thai tis620_thai_ci 1 
euckr EUC-KR Korean euckr_korean_ci 2 
koi8u KOI8-U Ukrainian koi8u_general_ci 1 
gb2312 GB2312 Simplified Chinese gb2312_chinese_ci 2 
greek ISO 8859-7 Greek greek_general_ci 1 
cp1250 Windows Central European cp1250_general_ci 1 
gbk GBK Simplified Chinese gbk_chinese_ci 2 
latin5 ISO 8859-9 Turkish latin5_turkish_ci 1 
armscii8 ARMSCII-8 Armenian armscii8_general_ci 1 
utf8 UTF-8 Unicode utf8_general_ci 3 
ucs2 UCS-2 Unicode ucs2_general_ci 2 
cp866 DOS Russian cp866_general_ci 1 
keybcs2 DOS Kamenicky Czech-Slovak keybcs2_general_ci 1 
macce Mac Central European macce_general_ci 1 
macroman Mac West European macroman_general_ci 1 
cp852 DOS Central European cp852_general_ci 1 
latin7 ISO 8859-13 Baltic latin7_general_ci 1 
cp1251 Windows Cyrillic cp1251_general_ci 1 
cp1256 Windows Arabic cp1256_general_ci 1 
cp1257 Windows Baltic cp1257_general_ci 1 
binary Binary pseudo charset binary 1 
geostd8 GEOSTD8 Georgian geostd8_general_ci 1 
cp932 SJIS for Windows Japanese cp932_japanese_ci 2 

解决方案 »

  1.   

    不要在phpMyAdmin里执行
    在命令行执行。
    这是我的执行结果:/*!40101 SHOW CHARACTER SET */;
    "big5" "Big5 Traditional Chinese" "big5_chinese_ci" "2"
    "dec8" "DEC West European" "dec8_swedish_ci" "1"
    "cp850" "DOS West European" "cp850_general_ci" "1"
    "hp8" "HP West European" "hp8_english_ci" "1"
    "koi8r" "KOI8-R Relcom Russian" "koi8r_general_ci" "1"
    "latin1" "cp1252 West European" "latin1_swedish_ci" "1"
    "latin2" "ISO 8859-2 Central European" "latin2_general_ci" "1"
    "swe7" "7bit Swedish" "swe7_swedish_ci" "1"
    "ascii" "US ASCII" "ascii_general_ci" "1"
    "ujis" "EUC-JP Japanese" "ujis_japanese_ci" "3"
    "sjis" "Shift-JIS Japanese" "sjis_japanese_ci" "2"
    "hebrew" "ISO 8859-8 Hebrew" "hebrew_general_ci" "1"
    "tis620" "TIS620 Thai" "tis620_thai_ci" "1"
    "euckr" "EUC-KR Korean" "euckr_korean_ci" "2"
    "koi8u" "KOI8-U Ukrainian" "koi8u_general_ci" "1"
    "gb2312" "GB2312 Simplified Chinese" "gb2312_chinese_ci" "2"
    "greek" "ISO 8859-7 Greek" "greek_general_ci" "1"
    "cp1250" "Windows Central European" "cp1250_general_ci" "1"
    "gbk" "GBK Simplified Chinese" "gbk_chinese_ci" "2"
    "latin5" "ISO 8859-9 Turkish" "latin5_turkish_ci" "1"
    "armscii8" "ARMSCII-8 Armenian" "armscii8_general_ci" "1"
    "utf8" "UTF-8 Unicode" "utf8_general_ci" "3"
    "ucs2" "UCS-2 Unicode" "ucs2_general_ci" "2"
    "cp866" "DOS Russian" "cp866_general_ci" "1"
    "keybcs2" "DOS Kamenicky Czech-Slovak" "keybcs2_general_ci" "1"
    "macce" "Mac Central European" "macce_general_ci" "1"
    "macroman" "Mac West European" "macroman_general_ci" "1"
    "cp852" "DOS Central European" "cp852_general_ci" "1"
    "latin7" "ISO 8859-13 Baltic" "latin7_general_ci" "1"
    "cp1251" "Windows Cyrillic" "cp1251_general_ci" "1"
    "cp1256" "Windows Arabic" "cp1256_general_ci" "1"
    "cp1257" "Windows Baltic" "cp1257_general_ci" "1"
    "binary" "Binary pseudo charset" "binary" "1"
    "geostd8" "GEOSTD8 Georgian" "geostd8_general_ci" "1"
    "cp932" "SJIS for Windows Japanese" "cp932_japanese_ci" "2"
    "eucjpms" "UJIS for Windows Japanese" "eucjpms_japanese_ci" "3"
      

  2.   

    那么在PHP代码中执行:
    mysql_query("/*!40101 SHOW CHARACTER SET */;");结果应该正常,不会当成注释不执行的吧?