请帮忙!mysql安装 show character set;显示可用字符集,看看有没有gbk 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mysql>show character set;ERROR 1064: You have an error in your SQL syntax near 'character set' at line 1 在我下载的源码里share\mysql\charsets 里没有gb2312.conf或gbk.conf文件是不是源码有问题? 应该是高版本的mysql才支持show character set;命令。你可以打开mysql\share\charsets目录下的index文件,查找gbk字符串。 在index文件里有gbk 28可没有gbk.conf文件 这是我的那个表的描述:MyISAM file: nameRecord format: Fixed lengthCharacter set: gb2312 (24)File-version: 1Creation time: 2005-01-08 10:37:02Recover time: 2005-01-08 11:23:22Status: checkedData records: 13367 Deleted blocks: 0Datafile parts: 13367 Deleted data: 0Datafile pointer (bytes): 4 Keyfile pointer (bytes): 3Datafile length: 12150603 Keyfile length: 1024Max datafile length: 3904125272062 Max keyfile length: 17179868159Recordlength: 909table description:Key Start Len Index Type Rec/key Root BlocksizeField Start Length Nullpos Nullbit Type1 1 22 3 4 1 23 7 4 1 44 11 5 1 85 16 200 1 166 216 200 1 327 416 8 1 648 424 100 1 1289 524 4 2 110 528 100 2 211 628 4 2 412 632 4 2 813 636 20 2 1614 656 4 2 3215 660 250 2 64 msql在redhat5.5中如何配置3306的端口? MySQL的命令行程序就是控制台吧? 创建表时如果有两列都是datetime类型,并且都设置默认值,要怎么解决呢? 请教一个mysql查询优化方法 Mysql中锁表遇到的问题 新建表时能不能这样指定字段的缺省值 请教膏人MYSQL的安装问题 inner join + split 的简单问题 ! insert into 插入文字值就提示错误! mysql分区表如何实现类似全文索引的效果 mysql front version3.1 (build12.1)版本的注册码 mysql字符集问题
ERROR 1064: You have an error in your SQL syntax near 'character set' at line 1
MyISAM file: name
Record format: Fixed length
Character set: gb2312 (24)
File-version: 1
Creation time: 2005-01-08 10:37:02
Recover time: 2005-01-08 11:23:22
Status: checked
Data records: 13367 Deleted blocks: 0
Datafile parts: 13367 Deleted data: 0
Datafile pointer (bytes): 4 Keyfile pointer (bytes): 3
Datafile length: 12150603 Keyfile length: 1024
Max datafile length: 3904125272062 Max keyfile length: 17179868159
Recordlength: 909table description:
Key Start Len Index Type Rec/key Root BlocksizeField Start Length Nullpos Nullbit Type
1 1 2
2 3 4 1 2
3 7 4 1 4
4 11 5 1 8
5 16 200 1 16
6 216 200 1 32
7 416 8 1 64
8 424 100 1 128
9 524 4 2 1
10 528 100 2 2
11 628 4 2 4
12 632 4 2 8
13 636 20 2 16
14 656 4 2 32
15 660 250 2 64