There are two files, A.txt and B.txt.

there are two files, A.txt and B.txt.
there are 3000w rows of data in A.txt. The contents separated by spaces between id and username are as follows:

id   usernmae
1    zhangsan
2    lisi
......

there are 3000w rows of data in B.txt. The contents separated by spaces between id and realname are as follows:

id    realname
1     
2     
.....

how to extract the username from A.txt and append it to B.txt through id matching, and calculate the time complexity.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b347f1-2bf0f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b347f1-2bf0f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?