Jump to content

Archived

This topic is now archived and is closed to further replies.

mATOK

mediumtxt

Recommended Posts

Hello out there!

I have a DB that I am going to be populationg via a form that I am going to create in html/php.

I have 4 fields in my DB that are of type mediumtxt. When I use MySQL consol manager i am prompted to save and name my txt files and then to apply so that the record is loaded from the file.

How do I go about doing this via a form? I have a naming convention so I'm hoping that I can submit some mysql command...

please help 

Share this post


Link to post
Share on other sites
You mean uploading files to mysql?

Share this post


Link to post
Share on other sites
Perhaps, I don't know.

I have an empty table with fields of type Medium txt. I just want to be able to populate these fields via a form.

If I do it using the MySQL control center I create a txt file, name it and apply it.

I'm just wondering how to do all this via a form and action script

Share this post


Link to post
Share on other sites
Populate these fields with the contents of the "txt file"?  I don't understand.

Share this post


Link to post
Share on other sites
can I do a straight "UPDATE table SET lotzoftxt='$data';

If lotzoftxt is of type mediumtext? Or do I need to specify anything else?

Share this post


Link to post
Share on other sites
Yes, you can issue the statement you described -- just beware of quoting issues.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.