| re: Insert file data into text field
Another scenario for you -
if your tables have primary keys -
you can issue an update command from php ..
[following is pseudoCode]
update tablename set fieldname = textstringvalue where pkfield = 'your
selection criteria'
---
and of course - instead of some copy paste - you can use php to auto gen the
php code you want to run, with the right PK values, line by line, so you
have as many update lines as you need ..
lemme know your thoughts??
mondo regards [Will]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:excel-info@efgroup.net
mySql / VFP / MS-SQL
"Rob" <robx2@hotmail.com> wrote in message
news:18ee9096.0308091034.7cada8a8@posting.google.c om...[color=blue]
> Hey, I'm pretty new to MySQL and have a question.
>
> I've built a database locally and have inputed some information. I
> need to go back and update some records, specifically by taking long
> pieces of text and putting them into text fields.
>
> Cutting and pasting in the command prompt for windows isn't such a
> good idea. Is there a way to update an existing record by importing a
> text file into a text field?
>
> All the info I'm seeing in the MySQL manual and in these groups is for
> importing text-deliniated files.
>
> Thanks in advance.[/color]
| 
