Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: sadhiesh
- Order by date
-
entering "null" in empty field using LOAD DATA INFILE
hai when i use LOAD DATA INFILE for a text file delimited by tab, and if it has any field empty it enters " as default, instead i want string 'null' to be entered.This should be done without altering the text file from which data is loaded.it loads 80000+records hence using query statement... -
doubt in "mysqlimport" command
hai devnull thanks for ur response. but i have a problem using LOAD DATA because it reads only row by row, where as i have a record of 80,000 , which takes a lot of time for such operation.so i thought of going in for mysqlimport which takes file by file, so could reduce the time greatly.please... -
doubt in "mysqlimport" command
I have a text file with column delimter as '/t' and row delimter as '/n'. I used following command to import that text file into mysql DB. C:\WINNT\mysql\bin>mysqlimport -C -f --debug='d:t:o,debug.txt' -d --fields-termi nated-by='\t' --lines-terminated-by='\n' -v --local example...
