Text field city number opentime logo fee table fields is also same,

Through the load data local infile 'D:/datafile T1126. TXT into table orderform fields terminated by' \ t 'lines terminated by' \ n '; Import success

But performs the select city, count (1) the from orderform where logo='B' the result is 0

Actual should conclude the result is 6966.

Please teach a great god, I am using mysql 5.5.58 Windows version

CodePudding user response:

A great god advice please,,,

CodePudding user response:

Check the data directly, if there is no new data, explain you import yes problem

CodePudding user response:

refer to the second floor ZJCXC response:

directly to check the data, if there is no new data, explain you import problem of

Format of the number of the data import and didn't find there are problems? Is the TAB delimited text, is the end there is a problem? Please give directions, thank you.

CodePudding user response:

There is no any data to import, or import some of the data, there are still import the data but not the right
Situation is not clear, only said not found the problem,,,,,,,