Bosses, I have a 3 g TXT text you need to import the mysql, below the format
1 I white
2 he black
The first division has four Spaces, the second segmentation has a space, is in the Windows on the computer, this how to import things, urgent urgent

CodePudding user response:

And a big answer

CodePudding user response:

Lead into to the database using the replace function Spaces

CodePudding user response:

refer to the second floor qq_18379499 response:

the guide into the, again to the database using the replace function Spaces

But TXT file to specify delimiters I just don't know how to put this file into the MySQL, a total of three columns, 9400 w

CodePudding user response:

refer to the second floor qq_18379499 response:

the guide into the, again to the database using the replace function Spaces

I just learned how to specify a delimiter, then baidu and they said to TXT separator is unified, not only into a unified, but the file is too big

CodePudding user response:

reference 4 floor far sincere friends to add reply:

Quote: refer to the second floor qq_18379499 response:

the forerunner, again to the database using the replace function Spaces

I just learned how to specify a delimiter, then baidu and they said to TXT separator is unified, not only into a unified, but the file is too big

Can remove the separator or first into a unified format to deal with,

CodePudding user response:

Open notepad, CTRL + h, the four Spaces, three Spaces, two Spaces, are replaced with a space,