In the last episode (May 25), SRM SRM said:
> Thanks for your help. I'm not able to ssh into this box - how can I
> run this script, basically all I have to work with is MySQL Query
> Broswer.
You can generate data by using a stroed procedure, too. I prefer this
method because it doesn't requ
Ryan,
Thanks for your help. I'm not able to ssh into this box - how can I run
this script, basically all I have to work with is MySQL Query Broswer.
TIA
From: Ryan Stille <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: Re: Need script to populate data.
Date: Fri, 25
This should do it. Save it in a file then run it like "perl newfile.pl".
Save the output into a text file, then run it against your database.
$records = 100;
for ($i=1;$i<=$records;$i++) {
print "INSERT INTO MyTable (forumid, styleid, title, title_clean, " .
"description, description_clean, opti
Group,
I'm an oracle dba and new to mysql. I've just recieved responsiblity to
work on a mysql project. Basically I have 1 table:
forumid smallint(5) unsignedNO (null) 0 (null)
styleid smallint(5) unsignedNO (null) 0 (null)
title varchar(100)NO (n
Group,
I'm an oracle dba and new to mysql. I've just recieved responsiblity to
work on a mysql project. Basically I have 1 table:
forumid smallint(5) unsignedNO (null) 0 (null)
styleid smallint(5) unsignedNO (null) 0 (null)
title varchar(100)NO (n