mysqlの最近のブログ記事

select
CURDATE(),
DATE_FORMAT(birth,'%Y-%m-%d') as birth,
YEAR(CURDATE()),
(YEAR(CURDATE())-YEAR(birth)),
DATE_FORMAT(birth,'%Y-%m-%d'),
RIGHT(CURDATE(),5) < RIGHT(DATE_FORMAT(birth,'%Y-%m-%d'),5) as date_chk ,
(YEAR(CURDATE())-YEAR(birth)) - ( RIGHT(CURDATE(),5) < RIGHT(DATE_FORMAT(birth,'%Y-%m-%d'),5) ) as age
from m_user;

mysqldump -uhoge -phoge hoge > mysqldump`date +\%Y\%m\%d`.sql

# 全部ダンプ

mysqldump -uhoge -phoge hoge > dump_all_`date +\%Y\%m\%d`.sql

# クリエート文のみ

mysqldump --add-drop-table --no-data -uhoge -phoge hoge > create_`/bin/date +%Y%m%d`.sql

# insert作成

mysqldump --no-create-info --no-create-db -uhoge -phoge hoge > dump_`/bin/date +%Y%m%d`.sql