mkdir-p $GOPATH/src/golang.org/x/
cd $GOPATH/src/golang.org/x/
git clone https://github.com/golang/net.git net
go install net
mkdir-p $GOPATH/src/golang.org/x/
cd $GOPATH/src/golang.org/x/
git clone https://github.com/golang/net.git net
go install net
SELECT table_schema AS "Database Name", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size in (MB)" FROM information_schema.TABLES GROUP BY table_schema;
查看全部
SELECT table_schema AS "Database Name", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size in (MB)" FROM information_schema.TABLES WHERE table_schema = "YOUR_DB_NAME";
查看一个
SELECT table_name AS "Table Name", ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size in (MB)" FROM information_schema.TABLES WHERE table_schema = "YOUR_DB_NAME" ORDER BY (data_length + index_length) DESC;
查询表
由于项目历史原因,需要同步MSSQL数据库到MYSQL数据库中。
工具:Navicat
首先 添加 MSSQL 和 MYSQL 到 Navicat中
然后在工具中 找到数据传输。
最后就是在高级选项中,记得勾上或者勾去 插入数据。
最简单的方便。
直接在Navicat里面 拖动 table就好了。