Generate INSERT SCRIPT from Tab-Delimited Text File

[JStrummer]

Any recommendations on how to generate an INSERT SQL script for the
records in a tab-delimietd text file? The limitation is that, while I
do have command-line mySQL access locally, I do not at my remote host,
so I will need to come up with a solution that I can run via something
like phpmyadmin, mysqlcc, or TOAD for mySQL. Any help would be
appreciated.

[steve]

"JStrummer" wrote:

Any recommendations on how to generate an INSERT SQL script for the
records in a tab-delimietd text file? The limitation is that, while I do have command-line mySQL access locally, I do not at my remote host, so I will need to come up with a solution that I can run via something like phpmyadmin, mysqlcc, or TOAD for mySQL. Any help would be
appreciated.

But phpmyadmin can import tab delimited files, so I don’t see the need
for what you asking for.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-Genera...ict139568.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=466918