Mysql experts where are you

download this csv
http://www.bseindia.com/bhavcopy/EQ070307.CSV

table name bse all column can coontain null value

'code' ‘varchar(45)'
'name' 'varchar(45)'
'kind' 'varchar(45)'
'type' 'varchar(45)'
'open' 'varchar(45)'
'high' 'varchar(45)'
'low' 'varchar(45)'
'close' 'varchar(45)'
'last' 'varchar(45)'
'prevclose' 'varchar(45)'
'trades' 'varchar(45)'
'qty' 'varchar(45)'
'vol' 'varchar(45)'
'corp' 'varchar(45)'


now download the file from the link above and load it in this table.

also give me the load data infile command

 

some politeness may help...

 

ya sure i need it shall be really polite next time

 

XD This is just hilarious..

 

friend kindly let me know a solution

 

masked with nice words... but somehow, can still detect an irritated tone.

 

load data local infile ' EQ070307.CSV' into table bse fields terminated by ',' enclosed by '"'

you may need to play with the terminated by and and enclosed by. MySQL online manual reading strongly recommended. It would take you less time to type the command than to post a message for help in the forum once you get the hang of it.

 

i did a lot of effort in this i get a strange error each time i excute the command error no 1261 :row 2625 doesn`t contain data for all columns.
no this error occurs typically on the last or second last line of each different file also. the data is complete and well upto the the mark.

is there any software like navicat for mysql which does all the work by the wizard and show us the command also

 

Title: Mysql experts where are you
Post: I'm a turd burgler, but figure out this solution for me... but faster!

 

yes the solution is quite tough i broke my head a lot with this

 

Mysql experts where are you... I am right here... I charge $50 p/h but for you I will make it $75 p/h... get some manners man, sheesh!