1.将本地文件读入数据库
load data local infile 'E:\\s.txt' into table data fields terminated by '\t';
2.计算网络中节点度的时候的sql语句
SELECT a.uid as username,SUM(a.money) as userflow from testdata a GROUP BY a.uid
1.将本地文件读入数据库
load data local infile 'E:\\s.txt' into table data fields terminated by '\t';
2.计算网络中节点度的时候的sql语句
SELECT a.uid as username,SUM(a.money) as userflow from testdata a GROUP BY a.uid