shell實現,將mysql每個預存程序匯出為單個檔案,#shell實現,將mysql中預存程序代碼直接匯出為檔案dbcn="mysql -h172.16.1.194 -uroot -p123456 ";db=BCReport_Sync_Executor;ii=0;ct=`$dbcn -N -e " select count(1) from mysql.proc as p where 1=1 and p.db='$db' and p.type
MySQL Full Join的實現,mysqljoinMySQL Full Join的實現 因為MySQL不支援FULL JOIN,下面是替代方法left join + union(可去除重複資料)+ right joinselect * from A left join B on A.id = B.id (where 條件)unionselect * from A right join B on A.id = B.id (where條件); mysql實現full
MYSQL添加遠端使用者或允許遠端存取三種方法,mysql遠端存取添加遠端使用者admin密碼為password GRANT ALL PRIVILEGES ON *.* TO admin@localhost IDENTIFIED BY \'password\' WITH GRANT OPTION GRANT ALL PRIVILEGES ON *.* TO admin@\"%\" IDENTIFIED BY \'password\' WITH GRANT
SQL執行時間,sql執行開啟SQL執行時間統計 set timing on; 查詢是否有執行時間較長的SQL存在 select a.sid, b.sql_text from v$session a, v$sqlarea b where a.sql_hash_value = b.hash_value and a.sid in (SELECT SID
rman,rman備份rman target / nocatalog LIST命令用於列出資料的備份資訊 1.列出資料檔案的備份組 list backupset of datafile '資料檔案的名字' 2.列出資料表空間的備份資訊 list backup of tablespace '資料表空間的名字' 3.列出整個資料庫的備份資訊 list backup of database
Install Oracle12cR1 on Oracle Linux 6.5 in VirtualBox,oraclevirtualboxMy Oralce Linux 6.5 is running on VirtualBox. Basic settings is 4G memory, 50G hard-disk, auto partition when install OL6.5. ** Following series of operations need root