You can use one of two options to insert CSV files: "Bulk Insert," a command that works from the SQL Server Management Studio, or "bcp utility," which you run from a Windows command line prompt.

Inserting a string into a MySQL table is a matter of logging into the MySQL server, then issuing an "insert" command for the table column that holds text data.

When I run the UPDATE command in PERL for inserting a new row into a database via the DBI, how do I get the new ID of that row that was inserted?Thanks!Ray.