摘要:
一般在安装目录下的data文件夹下,或者在C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data(你的可能是C:\Documents and Settings\All Users\Applica... 阅读全文
摘要:
1、查询某数据库大小语句: SELECT CONCAT(ROUND(SUM(DATA_LENGTH/1024/1024),2),'MB') AS DATA FROM TABLES WHERE table_schema='yxl'; --table_schema等于数据库。2、查询某数据库某表大小语句... 阅读全文
摘要:
类型是可变长度的字符串,最多65535个字符; 可以把字段类型改成MEDIUMTEXT(最多存放16777215个字符)或者LONGTEXT(最多存放4294967295个字符). MySQL supports 4 TEXT field types (TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT) and this post looks at the maximum length of each of these field types. MyISAM tables in MySQL have a maximum size of a row of 65,53. 阅读全文