sqlite3that can either create an interactive SQL shell that you can execute statements within or simply pipe into or use the second parameter (the first being the database file).
cat dbscripts/create_channels.sql | sqlite3 databases/tv
create table channel (
select [Title],[Genre],[Year],[Name],[Date],[Start Time] from programme P INNER JOIN Channel C ON P.channelId = C.Id where [Date] >= date('now') AND Film='true' ORDER BY [Date]
This page is by me for me, if you are not me then please be aware of the following
I am not responsible for anything that works or does not work including files and pages made available at www.jumpstation.co.uk I am also not responsible for any information(or what you or others do with it) available at www.jumpstation.co.uk