[Jax.PM] Re: ~9M lines of data

Abigail abigail at foad.org
Mon Oct 14 11:44:20 CDT 2002


On Mon, Oct 14, 2002 at 12:25:03PM -0400, iudicium ferat wrote:
> I am somewhat beating my head against a brick wall here - so I think "Hey!
> This sounds like a Fun With Perl project :)"
> 
> Here is the challenge -
> 
> You are presented with a MySQL Schema dump that is less than 9 million rows;
> you should read the data row by row, finding each CREATE TABLE statement,
> and displaying the next ~50 lines INCLUDING this line - do this recursively
> until end of file is reached.


    grep -A 50 'CREATE TABLE' file.sql


Abigail



More information about the Jacksonville-pm mailing list