473,321 Members | 1,708 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

Insert file data into text field

Rob
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.
Jul 19 '05 #1
4 10688
Rob - another possibility would be to use a sql query tool ..
I am a big fan of mySqlFront - but its not supported any more. Its still
around for download .

On the other hand - I have written some data maintenance programs in VFP for
mySql.
You could do the same thing, if you wanted to - its very straightforward.

hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Rob" <ro***@hotmail.com> wrote in message
news:18**************************@posting.google.c om...
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.

Jul 19 '05 #2
Rob - another possibility would be to use a sql query tool ..
I am a big fan of mySqlFront - but its not supported any more. Its still
around for download .

On the other hand - I have written some data maintenance programs in VFP for
mySql.
You could do the same thing, if you wanted to - its very straightforward.

hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Rob" <ro***@hotmail.com> wrote in message
news:18**************************@posting.google.c om...
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.

Jul 19 '05 #3
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:ex********@efgroup.net
mySql / VFP / MS-SQL
"Rob" <ro***@hotmail.com> wrote in message
news:18**************************@posting.google.c om...
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.

Jul 19 '05 #4
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:ex********@efgroup.net
mySql / VFP / MS-SQL
"Rob" <ro***@hotmail.com> wrote in message
news:18**************************@posting.google.c om...
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.

Jul 19 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jim Geissman | last post by:
I am trying to bulk insert a text file. The file has fixed-length fields with no field terminators. BOL says that field terminators are only needed when the data does *not* contain fixed-length...
5
by: me | last post by:
I'm also having problems getting the bulk insert to work. I don't know anything about it except what I've gleened from BOL but I'm not seeming to get anywhere...Hopefully there is some little (or...
20
by: akej via SQLMonster.com | last post by:
Hi, i have table with 15 columns CREATE TABLE . ( PRIMARY KEY , NULL , NULL , NULL , NULL , (50) NULL , NULL
6
by: pk | last post by:
Sorry for the piece-by-piece nature of this post, I moved it from a dormant group to this one and it was 3 separate posts in the other group. Anyway... I'm trying to bulk insert a text file of...
11
by: Chris Fink | last post by:
I have setup an Oracle table which contains a blob field. How do I insert data into this field using C# and ADO.net?
17
by: NuB | last post by:
I have a sql query that is doing an update of records, how can I add NULL to the field in the database if the field on my screen is blank? example: I have 5 textboxes, and a user can leave some...
11
by: Ted | last post by:
OK, I tried this: USE Alert_db; BULK INSERT funds FROM 'C:\\data\\myData.dat' WITH (FIELDTERMINATOR='\t', KEEPNULLS, ROWTERMINATOR='\r\n');
6
by: Ted | last post by:
I used bcp to produce the apended format file. How can it be modified to recognize the quotes that surround the text fields and not insert the quotes along with the text? Invariably, the first...
0
by: ozkhillscovington | last post by:
We have sp's in place that do BULK INSERTS from txt files into the tables. This works fine, however they have asked us to add a field that identifies accounting ctr. The only thing that identifies...
8
by: SaltyBoat | last post by:
Needing to import and parse data from a large PDF file into an Access 2002 table: I start by converted the PDF file to a html file. Then I read this html text file, line by line, into a table...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.