控制台创建本地数据库

(1)

mysql -u root -p   #进入mysql
enter password:1234
create database immunencr character set gbk;#创建数据库
use immunencr;#使用数据库

#创建表
create table functiondata (number int,
category varchar(255),
ncRNA varchar(255),
disease varchar(255),
cell varchar(255),
immune_events varchar(255),
species varchar(255),
gene varchar(255),
expression varchar(255),
tissue varchar(255),
method varchar(255),
description varchar(255),
year int,
PMID int,
title varchar(255),
immune_type varchar(255),
pathway varchar(255));

#显示表
show tables;

load data local infile 'D:/CH-JAVA/tomcat6/webapps/immunencr/functiondata.txt' into table functiondata fields terminated by '\t';

select * from functiondata;