Re: Need script to populate data.

2007-05-25 Thread SRM SRM
title_clean, " . "description, description_clean, options) VALUES\n"; print "($i, 888, 'title $i', 'clean title $i', 'description $i', " . "'clean description $i', 999);\n" } so: perl newfile.pl > test_records.sql mysql -p mydatabas

Need script to populate data.

2007-05-25 Thread SRM SRM
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

Need script to populate data.

2007-05-25 Thread SRM SRM
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