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
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
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, options)
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 May 2007 13:19
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