Posted by rhaazy on 08/15/07 14:42

I have to create a script to install a database, and one of the tables
has about 200 rows of static data... I dont want to have to manually
type in 200 insert statements, so is there a better way to do this? I
thought about maybe exporting the data into a CSV file and using some
sort of procedure to insert the records that way... Any advise?

• Next in forum: Re: standard and easy way to do schema design
• Prev in forum: Re: Limit query execution time
• Thread view: Create script to insert 200 rows into table

[Reply to this message]