按照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
如果你在'!'后增加一个版本数字,该语法将仅在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
在命令行执行。
这是我的执行结果:/*!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"
mysql_query("/*!40101 SHOW CHARACTER SET */;");结果应该正常,不会当成注释不执行的吧?