hm....SQL table help.

Nuke Soldier Joined: Jul 02, 2003 Posts: 29

What I need to do is this....I need to modify the existing nuke_encyclopedia table. What I want to do is simply add a text file to that table. I figured out how to do it with PHPMyAdmin, but I get an error telling me the command isn't yet implemented into MySQL. There's gotta be a relatively simple way to do it, I'm just not SQL savvy enough to figure it out. Otherwise, even with a mod Raven sent me, I'm looking at at least a couple month's work getting all these in there. Shocked

Is there a way, perhaps, to export the existing table to a txt file, add the lines I want, then export the txt file back into MySQL as a table? Or am I smoking too much?

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Not sure I understand what you're doing/needing. Do you want to add a column to the table? If so, make it TYPE TEXT.

You can use phpMyAdmin to EXPORT the table contents. Then, modify the entry(s) as desired. Then, after backing up the table, EMPTY the table. Then, using the SQL tab, INSERT the entry(s) back. Or, if you want the changes in addition to what is alread in the table, don't EMPTY the table, just INSERT the new entry(s). Clear as mud?

Nuke Soldier Joined: Jul 02, 2003 Posts: 29

heh.....about, yeah. Makes sense now, though. Guess maybe I should be more specific......

I have a text file, of all my word definitions, laid out like this:

fader - a control on a mixing board, used to control the input level for a channel.

channel - a single input section of a mixing board, or the left or right signal in a stereo recording

etc, etc, but alphabetised. Putting this info in, one definition at a time, adds the text to the nuke_encyclopedia table. So, I should be able to export that table, then just copy and paste all 2000+ definitions? Then, just re-insert the now modified text?

I'm definitely leaving your mod up, I like the idea of users being able to add definitions, especially in other languages. Just looking for a fast, relatively easy, way to get the encyclopedia up and running.

I'll try what you suggested, if it works, you'll probably hear the cries of joy all the way over there.

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

If that does not work, and I don't think it will, you could turn your text file into a tab/comma delimited file and then use phpMyAdmin to load the file and voila! You're done.

Nuke Soldier Joined: Jul 02, 2003 Posts: 29

I'll try that first, I think. The other way seems relatively easy, just alot of formatting. I'll work on it tonight, let you know how it goes.

I'm still learning the ins and outs of SQL, really, this is one of the things I put off learning, of course...... *edit* Tried doing a delimted text file, phpMyAdmin gives me an SQL syntax error. The other option, to add data from a text file, gives me an error that says that the command isn't available in my current version of SQL......argh. Gotta be something I'm doing....I used Excel to import the text file into a spreadsheet, then saved as a tab-delimted file. Also tried as comma-delimted. Guess I need a different program?