mysql command

mysql.sql

// login to mysql
mysql -u {user_name} -p

// export database to dump
mysqldump --single-transaction -u {user_name} -p {database_name} > /tmp/{file_name}.dump

// import database from dump
mysql -u {user_name} -p {database_name} < /tmp/{file_name}.dump

// show databases
show databases;

// use database change
use {database_name}

// show tables of use database
show tables;

// show columns of table
show columns from {table_name};

// get max value of id
select max(id) from {table_name};

// change column name
alter table {table_name} change {current_column_name} {new_colunm_name} {type_info}

// check foreign key constraints
show create table {table_name}

// delete foreign key constraint
alter table {table_name} drop foreign key {constraint_name}