Hi All,
I'm attempting to make a windows batch file that reads a text file and
inserts a new record for each entry:
sqlite3.exe dropped.db "INSERT INTO
`DropDB_log`(`date`,`ip_address`,`status`) VALUES
(%DATE%,readfile('machinelist.txt'),'%STATUS%');"
Right now, it does this:
date,ip_address,status20160926,128.10.10.1
128.10.10.3
128.10.10.4
128.10.10.5,up
I'd like this:
20160926,128.10.10.1,up
20160926,128.10.10.3,up
20160926,128.10.10.4,down
20160926,128.10.10.5,up
Will the readfile + the separator command allow this kind of hackery
in windows batch files?
Thanks!
--
-------
inum: 883510009027723
sip: [email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
