MySQL Forums
Forum List  »  Stored Procedures

Any idea about this procedure?
Posted by: Borja Ruiz
Date: July 02, 2007 03:00AM

Hi people,

I have an undefined number of rows (with two columns: name and surname) in a table.
I want to do the following:

Get the first two strings of each name and create a text file with the contents of all the names that start with these two strings.

For instance, if I have:

NAME SURNAME
Joe Smith
Mike Johnson
John Street
Jonathan Roberts

It should create two text files, one called jo.txt with Joe,John and Jonathan inside, and another text file called mi.txt with Mike inside.

Any clue on how to do this? Any help would be really appreciated.

Thanks,

Borja

Options: ReplyQuote


Subject
Views
Written By
Posted
Any idea about this procedure?
1622
July 02, 2007 03:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.