MySql连接字符串

<add key="ConnectionString" value="server=远程数据库IP;database=数据库名;PORT=端口; uid=用户;pwd=密码;charset=gb2312" />

<add key="ConnectionString" value="data source=远程数据库IP;database=数据库名; uid=用户;pwd=密码;" />

 

查看数据库使用大小

 use information_schema;
 select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES where table_schema='a0412124842';

指定数据库

select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES; 所有库