mysql命令笔记

建库

# 建库
CREATE DATABASE IF NOT EXISTS pythonspider DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

DEFAULT CHARACTER SET utf8设置数据库utf8字符集；
COLLATE utf8_general_ci设置数据库排序规则。

建表

CREATE TABLE jokeji(
id INT AUTO_INCREMENT PRIMARY KEY COMMENT '数据编号',
title VARCHAR(200) COMMENT '标题',
url VARCHAR(200) COMMENT '链接',
content text COMMENT '内容',
publish_time DATETIME COMMENT '发布时间',
view_num VARCHAR(200) COMMENT '浏览数',
crawled_time DATETIME COMMENT '爬取时间',
data_from VARCHAR(200) COMMENT '数据来源'
)DEFAULT CHARSET 'utf8';

导入数据

txt

load data local infile “c:/data.tsv” 
into table capice_snvs(chr, pos, ref, alt, score) 
IGNORE 1 LINES 
character set utf-8 
fields terminated by '\t' 
lines terminated by'\n';

IGNORE 1 LINES 忽略第一行数据
fields terminated by '\t’指定数据列分隔符
lines terminated by '\n’指定数据行分隔符

---