Possible to open a text file in a MYSQL stored procedure?
Posted
by futureelite7
on Stack Overflow
See other posts from Stack Overflow
or by futureelite7
Published on 2010-03-16T04:51:57Z
Indexed on
2010/03/16
12:46 UTC
Read the original article
Hit count: 504
Is it possible to open and read from a text file in a MYSQL stored procedure? I have a text file with a list of about 50k telephone numbers, and want to write a stored procedure that will open the file, read the 50k lines and store it as rows in a table. I cannot load the file directly using LOAD IN FILE as the table has additional columns that I have to set.
Thanks!
© Stack Overflow or respective owner