Re^3: perl mysql - INSERT INTO, 157 columns

[graff]

Given that the OP specifically mentioned mysql, I would not have posted the approach using "describe" if it didn't work in mysql.

As for your alternative (for cases where "describe" doesn't work), I would hope that any type of database covered by DBD would at least support "select * from foo limit 1", and this would be a prudent usage for the task at hand, whether or not you actually need to execute the query in order to get field names.

(BTW, thanks for the reminder about $")

[choroba]

any type of database covered by DBD would at least support "select * from foo limit 1"

Unfortunately, MS SQL Server throws an error:

Incorrect syntax near '1'

What works, though, is

SELECT TOP 1 * FROM table

[gsiems]

One would hope. However, last time I looked (v 11R2), Oracle still didn't support either limit or offset (you can fake it with rownum, but that's ugly).