Connecting Tech Pros Worldwide Forums | Help | Site Map

Generate INSERT SCRIPT from Tab-Delimited Text File

JStrummer
Guest
 
Posts: n/a
#1: Jul 20 '05
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
Guest
 
Posts: n/a
#2: Jul 20 '05

re: Generate INSERT SCRIPT from Tab-Delimited Text File


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

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
Closed Thread


Similar MySQL Database bytes