lqxue

常用链接

统计

book

tools

最新评论

查看mysql 表结构的一些sql

/*this can see the table information*/
show table status from `fortioa`;

/*this can see all the fields detail information of a table including  the character set*/
show full fields from `account`


/*change the table column`s character set to utf8*/
ALTER TABLE `purchaserequest` CHANGE `justification` `justification` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL



posted on 2007-12-17 17:30 lqx 阅读(1543) 评论(0)  编辑  收藏 所属分类: database


只有注册用户登录后才能发表评论。


网站导航: