How to insert rows into a mysql db?

Question

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?

how should i execute the php. right now, i only use php to generate html. is there a more generic command line use of it. (sorry just started php on sunday). Thanks! — glutz
– glutz, Commented Aug 15, 2012 at 2:43

rtuner · Accepted Answer · 2012-08-15 02:35:24Z

1

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.

answered Aug 15, 2012 at 2:35

rtuner

2,4203 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

glutz Over a year ago

this is helpful in general but it doesn't answer the question. Thanks though.

Nir Alfasi · Accepted Answer · 2012-08-15 02:35:41Z

0

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

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

answered Aug 15, 2012 at 2:35

Nir Alfasi

53.6k11 gold badges94 silver badges138 bronze badges

Comments

glutz · Accepted Answer · 2012-08-15 14:41:46Z

0

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

answered Aug 15, 2012 at 14:41

glutz

1,9599 gold badges29 silver badges46 bronze badges

Collectives™ on Stack Overflow

How to insert rows into a mysql db?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related