[sqlite] store db from sqlite to online mysql or online sqlite

2012-05-12 Thread rebornishard
i browse but didn't find it there is 5 apps running sqlite and they will export it intoonline mysql or online sqlite database search from doc but still didn't get anything thanks -- View this message in context:

Re: [sqlite] don't understand what "query" returns...

2012-05-12 Thread David Bicking
I don't know python, but because you have count(*) and no group by, it will only return one row, with the total rows that matched your where clause. The Item1, Item2, Item3 are arbitrary values that were in the two rows of your data. You can either remove the count(*) and get both rows, or as

[sqlite] don't understand what "query" returns...

2012-05-12 Thread philherna
Hi, I am using sqlite commands in my python script to output data from a sqlite database. My problem is however a Sqlite coding one. I can open, and select simple elements from the database easily but I have trouble for one specific issue. For example, to select the content of the rows Item1 ,