Hi All,
I need some help in figuring our right query syntax for querying items from two
tables. We have two tables. One of the table has list of items. And Second
table has additional attributes.
CREATE TABLE ITEM (
ID INTEGER,
FIELD0 TEXT
FIELD1 TEXT,
FIELD3 TEXT,
FIELD4 TEXT
);
CREATE TABLE
Hi Andrew,
This is a great use case for SQLite. Did you have to use any special flags or
settings for SQLite to achieve this e.g. cache size, page size Read only etc?
Thanks,
Vikas
> On Jun 7, 2017, at 10:07 AM, Andrew Brown
> wrote:
>
> Wanted to just let you all know that I really appreci
Hi Ryan,
Thanks for the transaction suggestion. We will do that.
I provided a simplistic example for constraints, but I think I have an answer
now.
Thanks,
Vikas
On Nov 21, 2016, at 12:24 PM, R Smith wrote:
>
>
> On 2016/11/21 9:57 PM, Vikas Aditya wrote:
>> Hi everyone,
Thank You!
Vikas
On Nov 21, 2016, at 12:09 PM, Richard Hipp wrote:
> On 11/21/16, Vikas Aditya wrote:
>>
>> Currently we are using:
>>
>> sql = "INSERT INTO {} SELECT * FROM {}".format(totable, fromtable)
>> cur.execute(sql)
>>
>> So
Hi everyone,
I have a DB migration question. I have a table called "employees" and it has a
UNIQUE constraint on "employee_email". With some new features being requested,
I need to relax the constraint and have a new constraint on "employee_email" +
"employee_number". Since SQLite ALTER table c
5 matches
Mail list logo