MySQL memo

.my.cnf

[mysql]
pager='less -FX'
prompt='(\u@\h:\d) mysql> '
auto-rehash

[client]
default-character-set=utf8

create table

show create table 4catalog;
create table 4catalog like catalog;

insert data

insert 4catalog select * from catalog;

import csv

mysqlimport --ignore-lines=1 --fields-terminated-by=, --local -u un -p db 4catalog.csv

check

check table 4catalog