programming - sqlite - operationsWhat links here?
Create index on column 'fruit' of the fruitsforsale table:
CREATE INDEX idx1 ON fruitsforsale(fruit);
Create index on two columns of the fruitsforsale table:
CREATE INDEX Idx3 ON FruitsForSale(fruit, state);
Select with output ordered by specific column:
SELECT * FROM fruitsforsale ORDER BY fruit;
Select of specific rows with output ordered by specific column:
SELECT price FROM fruitforsale WHERE fruit='Orange' ORDER BY state






programming - sqlite - operations
programming:c:function fclose
programming - windows - SetWindowText
programming - C - function ispunct
filename:programming - sqlite - operations
filename:programming%20%2D%20sqlite%20%2D%20operations
last edit:April 18 2012 20:27:38 (4838 days ago)
ct = 1752883510.000000 = July 18 2025 20:05:10
ft = 1334795258.000000 = April 18 2012 20:27:38
dt = 418088252.000000