Kettle experiment (III)

1. utilize kettle Establishment and database MySQL Link to

2. by kettle Create a MySQL database

3. Pass the data through what we have learned Excel Table method to import database

4. Put the data in KETTLE Row to column transfer （ The two methods ）

 

Formal experiment

(1) stay my A database that holds the database data 

 (1) stay mysql Create a database to store the database data

 

(2). stay kettle in , Click on connect

 

(2). stay kettle in , Click on connect

 

 (2). stay kettle in , Click on connect

 

 

  Connect to database , And the test was successful

 

Notice the User name and password All are admin

  stay mysql Import excel file ：

 

 

Formal experiment （ Two ） 1. stay mysql Import excel file ：

 

1. stay mysql Import excel file ：

 

 

Import data succeeded

 

use Excel Import data

 

 

 

Table output

 

 

Output to database

 

 

 

 

perform

 

The database shows

Row to column MySQL The following code is used to implement

 Row to column MySQL The following code is used in the 


SELECT
    date,
   max(case when name=' A novel '  then scount else 0 end)  A novel ,
   max(case when name=' WeChat '  then scount else 0 end)  WeChat 
from hang
group by date