1. 安装
2. 配置
3. 数据库操作
show databases;
create database mydatabase;
use mydatabase
4. 数据表操作
show tables;
create table mytable(column1 varchar(20), column2 char(1), column3 date, column4 date);
describe mytable;
load data local infile '/path/table.txt' into table mytable;
load data local infile '/path/table.txt' into table mytable
->lines terminated by '\r\n';
insert into mytable values('value1','v2','2000-01-01',NULL);
5.