The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
.
google unix.com




Thread: hell and sqlite
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 05-20-2008
ogoy ogoy is offline
Registered User
  
 

Join Date: May 2008
Posts: 7
hell and sqlite

Hi everyone,

I have a requirement that requires me to fill an sqlite database with 100,000 entries (no duplicates).

I will start out by giving the command that will insert the values necessary to populate the database:

# sqlite /var/local/database/dblist "insert into list (owner_id,behavior,entry)

values(0,0,'newblacklistentry.com') "

The challenge would be to get a different output for the entry value 100,000 times!

We can start with newurl.com and maybe append a numerical character to the string e.g.

newurl1.com
newurl2.com
newurl3.com

* I'm running on Linux

Your thoughts?

Thanks for looking

Carlo