1. 匯出資料庫

mysqldump --database mysql > mysql.sql

use mysql source /mysql.sql

mysql -h 10.0.0.111 -P 3306 -u -p123456

##　4. 將時間戳轉換成北京時間

select st,packagename,from_unixtime(starttime) from task where packagename like '%WINDOWS%' limit 1\G; ** 使用from_unixtime,其中(starttime)是時間戳 **

select st,packagename,from_unixtime(starttime) from task where packagename like '%WINDOWS%' into o utfile '/tmp/windows'

alter table task add password varchar(255); **預設就是該欄位可以為空**

query="select count(*) from packagedownloadcount where insert_date='$my_date'"count_result=$(mysql -u"root" -p"passwd" -D  "db" -s  -e "$query") #對資料庫進行操作#count_result可以直接得出結果,-s 就是去掉返回的頭

insert="insert into package("insert_date","name","dname","pname","psize","pcount") values('$my_date','com','www.baidu.com','aaa',1930,'$count')"update="update packageset pt='$count' where insert_date='$my_date'"

drop database app1

show grants for 'username'@'%';

CREATE DATABASE sqlite_convert CHARACTER SET utf8 COLLATE utf8_general_ci;

mysql> USE my_database;mysql> show variables like "character_set_database";