http://socialnetworks.mpi-sws.
LOAD DATA INFILE 'user.txt' INTO TABLE users;
LOAD DATA INFILE 'user.txt'
INTO TABLE users
FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
(user_id);
LOAD DATA INFILE 'links.txt'
INTO TABLE links
FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
(user1 , user2);
/var/lib/mysql/flicker/
http://stackoverflow.com/questions/14083709/mysql-load-data-infile-auto-incremented-id-value
http://stackoverflow.com/questions/5391344/insert-with-select
INSERT INTO newusers (id, user_id)
SELECT id, user_id
FROM users
WHERE users.`id` < 500001
INSERT INTO newusers (id, user_id)
SELECT id, user_id
FROM users
WHERE users.`user_id` < 1500001 AND users.`user_id` > 1400000
INSERT INTO newlinks (id, user1 , user2 )
SELECT id, user1 , user2
FROM links
WHERE links.`user1` < 1500001 AND links.`user1` > 1400000 AND links.`user2` < 1500001 AND links.`user2` > 1400000
INSERT INTO new2users (id, user_id)
SELECT id, user_id
FROM users
WHERE users.`user_id` < 200
INSERT INTO new2links (id, user1 , user2 )
SELECT id, user1 , user2
FROM links
WHERE links.`user1` < 200 AND links.`user2` < 200
