Re: [sqlite] Is it possible to insert UTF-8 strings in SQLITE3.EXE?

Richard Hipp, Simon Slavin, Luuk, and Keith Metcalf Thank you for your replies to our question. Here is another way I found out how insert UTF-8 strings in SQLITE3.EXE. F:\sqlite3_6_16>sqlite3.exe mdName.dat SQLite version 3.6.16 Enter ".help" for instructions Enter SQL statements terminate

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

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: http://old.nabble.com/store-db-from-sqlite-to-online-mysql-or-online-sqlite-tp33

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

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

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

You need something like : query = "select Item1,Item2,Item3, count(*) from %s where Item55 in (%s) *group by Item1,Item2,Item3*" JG On 12 May 2012 10:24, philherna wrote: > > Hi, > > > I am using sqlite commands in my python script to output data from a sqlite > database. My problem is however

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

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 ,