Analyze small-scale data with MySQL

1 Getting data

Example: (/home/work/data/1.data)

123457,chenli,70

123458,liuyang,71

2 CREATE TABLE

CREATE TABLE Score (

user_id bigint () unsigned not NULL,
User_name char ("DEFAULT"),
Score int DEFAULT 0,
PRIMARY KEY (article_id)
) Engine=innodb DEFAULT Charset=utf8

3 Load Data infile

Go to MySQL execution:

Load data infile '/home/work/data/1.data ' into table score fields terminated by ', ';

Load Data infile command More details can be referred to Baidu Google.

Command execution may run into problems and slowly solve it. For example, the data source of the load command must be specified in the directory again, and this needs to be changed in the config file.

Analyze small-scale data with MySQL