MySQL
MySQL原本是一個開放原始碼的關聯式資料庫管理系統，原開發者為瑞典的MySQL AB公司，該公司於2008年被昇陽微系統收購。2009年，甲骨文公司收購昇陽微系統公司，MySQL成為Oracle旗下產品。
DB Admin Tips
Initial DB Setup /usr/bin/mysql_secure_installation Change the root's password ALTER USER 'roo...
SQL
Online Tutorials MySQL Cheat Sheet WHERE SELECT name, wins FROM golfers WHERE wins = 1; ...
Learning MySQL
MySQL Backup How to Backup/Restore MySQL/MariaDB and PostgreSQL Using ‘Automysqlbackup’ and ‘A...
Installation
Install on CentOS 7 URL: https://downloads.mariadb.org/mariadb/repositories/#mirror=mephi&di...
Backup & Restore
Backup Script#1: #!/bin/bash # 以下配置資訊請自己修改 mysql_user="USER" #MySQL 備份使用者 mysql_password="...
Partition Table
Check if partition is supported > show plugins; Create partition table create table mm_tx_n...