Auto generate MySQL schema based on a text file?

[Andrew Braithwaite]

Hi,

Does anyone know of a perl module or other code that can look at a text file
(CSV, tab-delim etc..) of data and determine a MySQL table definition from
it?

The data may or may not have a set of column headers as the first line.

I would appreciate it greatly if anyone could give me any pointers to
existing stuff as I have to implement this function (and I don't
particularly like spending my time painfully churning out regexps if it's
not absolutely necessary!! :)

Cheers,

Andrew

SQL, Query