Hello.
I am trying to import data to MySQL. I have made some changes and now I have a one big text file where is:
INSERT INTO noze (cislo,jmeno,soucast1,soucast2,soucast3,soucast4,soucast5,datum,zalozil,poznamka,typ,poloha) VALUES (8610057,"Nuz na hrub 45? pol 3",8516230,0,0,0,0,"2000-10-03","Novotn?R."," ","N","N");
INSERT INTO noze
(cislo,jmeno,soucast1,soucast2,soucast3,soucast4,soucast5,datum,zalozil,poznamka,typ,poloha) VALUES (8610058,"N鶠na æÂÂicht 45?pol 5",8516230,0,0,0,0,"2000-10-03","Novotn?R."," ","N","N");
INSERT INTO noze (cislo,jmeno,soucast1,soucast2,soucast3,soucast4,soucast5,datum,zalozil,poznamka,typ,poloha) VALUES (8610059,"N鶠na hrub pol3",8516504,0,0,0,0,"2000-10-03","Novotn?R."," ","N","N");
etc.
How can I add more than one row into table? When I put the commands into MySQL admin one by one, everything is OK. When I try to insert more than one command, it ends with an error. What can I use to upload the data?
Thank you
Jan
I am trying to import data to MySQL. I have made some changes and now I have a one big text file where is:
INSERT INTO noze (cislo,jmeno,soucast1,soucast2,soucast3,soucast4,soucast5,datum,zalozil,poznamka,typ,poloha) VALUES (8610057,"Nuz na hrub 45? pol 3",8516230,0,0,0,0,"2000-10-03","Novotn?R."," ","N","N");
INSERT INTO noze
(cislo,jmeno,soucast1,soucast2,soucast3,soucast4,soucast5,datum,zalozil,poznamka,typ,poloha) VALUES (8610058,"N鶠na æÂÂicht 45?pol 5",8516230,0,0,0,0,"2000-10-03","Novotn?R."," ","N","N");
INSERT INTO noze (cislo,jmeno,soucast1,soucast2,soucast3,soucast4,soucast5,datum,zalozil,poznamka,typ,poloha) VALUES (8610059,"N鶠na hrub pol3",8516504,0,0,0,0,"2000-10-03","Novotn?R."," ","N","N");
etc.
How can I add more than one row into table? When I put the commands into MySQL admin one by one, everything is OK. When I try to insert more than one command, it ends with an error. What can I use to upload the data?
Thank you
Jan