Re: HOW DO U SPLIT UP LARGE STRINGS?

well, it must be big as it says 'mysql server gone away' i cant open the file from mysql, i need to edit a few things each line. i suppose i could open it, then save it to disk and then run that mysql command "Jabber@Raditha.Com" <jabber@raditha.com> wrote in message news:3F3D957D.8000002@raditha.com... > hello, > you can use the split() method to break this up into pieces. Unless you > are doing a large number of inserts on tables with several keys mysql > will not be troubled too much by the number of queries you run. > > > John Ryan wrote: > > >I've a string with a huge mySQL query, seperated by a semi-colon and then > >line-break. You can't run this query staright to mySQL (and i dont want to > >try), so Im trying to split up the query into, say, 100 mysql commands at a > >time. > > > >Is it possible to split up a string every 100 semi-colons it finds?? > > > >I input this string from a text file through fopen while(fgets)? Is it > >easier to just read 100 lines at a time, run a query, and then read another > >100 lines from the text file? > > > >TIA > > > > > > > > > > > > > -- > > Raditha Dissanayake > ------------------------------------------------------------- > http://www.radinks.com/sftp/ > Lean and mean Secure FTP applet with Graphical User Inteface. > just 150 Kilo Bytes > >