qiita.com

// hoge.sql内のSQLを実行。出力結果をout.txtに出力。 mysql -u [user] -p[password] [database name] < hoge.sql >out.txt cat hoge.sql | mysql -u[user.name] -p[password] [dbname] -t > out.txt

qiita.com

qiita.com

ハセテツラボ » MySQLでトリガーを使う

MySQL mysql.server [start|stop|restart] mysql -u [user.name] -p show databases use [database.name] show tables show table status describe [table.name] ( = desc [table.name] ) show triggers drop trigger [trigger.name]

qiita.com