Member Avatar for srpa01red

i want to insert into table some dummy data so as to large my database
is there any script or procedure in mysql to execute a insert statement about some thousands times

  • 2 Contributors
  • 1 Reply
  • 33 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Fest3er
Member Avatar for Fest3er

Of course there is. Don't be ridiculous. :) :)

#! /bin/sh

typeset -i i
typeset -i imax

i=0
imax=1000
while [ $i -lt $imax ]; do
  mysql -e 'insert into mytable set mycol='myval'
  i=i+1
done

Adapting it and making it work for you is your job. :) :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.