How to insert multiple rows in SQLite Dbase

afandi afandimscit at gmail.com
Fri Mar 28 17:05:29 EDT 2008


Hi,

Generally, it involves SQL statement such as
 follow

 INSERT INTO <tablename>(field1,field2,.......fieldn) VALUES
 ('abc','def'...........)

 If I have data taken from Apache Server Log,let say 100 lines which
is printed output of 8 fields such
 as:

data 1
IP: 61.5.65.101
Date: 26/Sep/2007
Time: 20:43:25
GMT: +0900
Requestt: GET /index.php?option=com_content&task=view&id=55&Itemid=19
HTTP/1.1
ErrorCode: 200
Bytes: 6458
Referel:http://www.joomla.org/index.php?
option=com_content&task=view&id=35&Itemid=19
Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.4)
Gecko/20070515 Firefox/2.0.0.4

data 2
IP: 21.5.65.101
Date: 26/Sep/2007
Time: 20:43:25
GMT: +0900
Requestt: GET /index.php?option=com_content&task=view&id=55&Itemid=19
HTTP/1.1
ErrorCode: 200
Bytes: 6458
Referel:http://www.joomla.org/index.php?
option=com_content&task=view&id=35&Itemid=19
Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.4)
Gecko/20070515 Firefox/2.0.0.4
.
.
.
.
until the 100 data

How toI insert into SQLite database? by using SQL statement.TQ



More information about the Python-list mailing list