CODEWITHSUNDEEP
phpmysqldatabase
glutz
glutz

Reputation: 1959

How to insert rows into a mysql db?

I need to write a script to be used an automated test to constantly insert rows into a mysql db. Which scripting language is best suited for this?

I'm using php to read the db and create html. Does it makes sense to use PHP for this too? Or would I be better off using ruby, or some other mechanism?

Upvotes: 0

Views: 87

Answers (3)

glutz
glutz

Reputation: 1959

looks like i should just use php from cmd line, which is apparently possible.

Upvotes: 0

Nir Alfasi
Nir Alfasi

Reputation: 53525

You can use phpadmin, toad, or any other MySql IDE to run the script:

BEGIN
  LOOP
    INSERT INTO ...
  END LOOP;
END;

Upvotes: 0

rtuner
rtuner

Reputation: 2410

Learn how to use MySql Stored Procedures. And AFAIK, PHP was built to generate HTML from start. Any noticeable performance problems should probably arise from your knowledge of html.

Upvotes: 1

Related Questions