How insert info SQL? Script basics?

[Feznizzle]

Hi!

I have a question about writing a script for inserting a large volume of information into a database.

Two questions:
First, can the SQL Query Executor (Admin/Tools/Install SQL Patches) be used to insert data into my store? Would it be better to somehow use phpMyAdmin?

Second, can someone please provide a BASIC demonstration that would show me how to write a script that:
- Accesses a table
- References an existing entry
- Inserts information into an associated cell

This is not what I'm doing, but for the sake of demonstration, it would be cool if you could show me how to write a script would look up an existing PRODUCT ID and then insert a PRICE. Maybe do two products so I can see how to replicate?

Thanks,
Mike

[kobra]

If you are seeking adding altering products I suggest you get the 3rd party module "easy populate" from the downloads area

There is a wiki article on it's use

[Feznizzle]

Hi Kobra,

Thanks for the input.

I have Easy Populate, it is a wonderful mod and I have gotten lots of good use out it. And you are right, I want to do something similar to that.

Can anybody show me how to write a very very simple script? Or maybe provide a link to where I could go research it?

Thanks,
Mike

[Feznizzle]

In case anybody else stumbles in here looking for the same thing, I think I found the answer HERE.

Good luck!