tahirg
Advanced Member | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
SELECT _id,
NAME,
NAME_LOW,
MANUFACTURER,
MANUFACTURER_LOW,
CALLORIES,
PROTEIN,
FAT,
CARBOHYDRATES,
NETTO,
BARCODE,
TAGS,
IS_ADDED_BY_USER,
IS_PER_PORTION,
FREQUENCY,
UUID,
DELETED,
MODIFIED_DATE,
LIST_ID,
USER_ID,
SYNC_UUID
FROM products;
INSERT INTO products (
_id,
NAME,
NAME_LOW,
MANUFACTURER,
MANUFACTURER_LOW,
CALLORIES,
PROTEIN,
FAT,
CARBOHYDRATES,
NETTO,
BARCODE,
TAGS,
IS_ADDED_BY_USER,
IS_PER_PORTION,
FREQUENCY,
UUID,
DELETED,
MODIFIED_DATE,
LIST_ID,
USER_ID,
SYNC_UUID
)
VALUES (
'_id',
'NAME',
'NAME_LOW',
'MANUFACTURER',
'MANUFACTURER_LOW',
'CALLORIES',
'PROTEIN',
'FAT',
'CARBOHYDRATES',
'NETTO',
'BARCODE',
'TAGS',
'IS_ADDED_BY_USER',
'IS_PER_PORTION',
'FREQUENCY',
'UUID',
'DELETED',
'MODIFIED_DATE',
'LIST_ID',
'USER_ID',
'SYNC_UUID'
);
UPDATE products
SET _id = '_id',
NAME = 'NAME',
NAME_LOW = 'NAME_LOW',
MANUFACTURER = 'MANUFACTURER',
MANUFACTURER_LOW = 'MANUFACTURER_LOW',
CALLORIES = 'CALLORIES',
PROTEIN = 'PROTEIN',
FAT = 'FAT',
CARBOHYDRATES = 'CARBOHYDRATES',
NETTO = 'NETTO',
BARCODE = 'BARCODE',
TAGS = 'TAGS',
IS_ADDED_BY_USER = 'IS_ADDED_BY_USER',
IS_PER_PORTION = 'IS_PER_PORTION',
FREQUENCY = 'FREQUENCY',
UUID = 'UUID',
DELETED = 'DELETED',
MODIFIED_DATE = 'MODIFIED_DATE',
LIST_ID = 'LIST_ID',
USER_ID = 'USER_ID',
SYNC_UUID = 'SYNC_UUID'
WHERE _id = '_id' AND
NAME = 'NAME' AND
NAME_LOW = 'NAME_LOW' AND
MANUFACTURER = 'MANUFACTURER' AND
MANUFACTURER_LOW = 'MANUFACTURER_LOW' AND
CALLORIES = 'CALLORIES' AND
PROTEIN = 'PROTEIN' AND
FAT = 'FAT' AND
CARBOHYDRATES = 'CARBOHYDRATES' AND
NETTO = 'NETTO' AND
BARCODE = 'BARCODE' AND
TAGS = 'TAGS' AND
IS_ADDED_BY_USER = 'IS_ADDED_BY_USER' AND
IS_PER_PORTION = 'IS_PER_PORTION' AND
FREQUENCY = 'FREQUENCY' AND
UUID = 'UUID' AND
DELETED = 'DELETED' AND
MODIFIED_DATE = 'MODIFIED_DATE' AND
LIST_ID = 'LIST_ID' AND
USER_ID = 'USER_ID' AND
SYNC_UUID = 'SYNC_UUID';
DELETE FROM products
WHERE _id = '_id' AND
NAME = 'NAME' AND
NAME_LOW = 'NAME_LOW' AND
MANUFACTURER = 'MANUFACTURER' AND
MANUFACTURER_LOW = 'MANUFACTURER_LOW' AND
CALLORIES = 'CALLORIES' AND
PROTEIN = 'PROTEIN' AND
FAT = 'FAT' AND
CARBOHYDRATES = 'CARBOHYDRATES' AND
NETTO = 'NETTO' AND
BARCODE = 'BARCODE' AND
TAGS = 'TAGS' AND
IS_ADDED_BY_USER = 'IS_ADDED_BY_USER' AND
IS_PER_PORTION = 'IS_PER_PORTION' AND
FREQUENCY = 'FREQUENCY' AND
UUID = 'UUID' AND
DELETED = 'DELETED' AND
MODIFIED_DATE = 'MODIFIED_DATE' AND
LIST_ID = 'LIST_ID' AND
USER_ID = 'USER_ID' AND
SYNC_UUID = 'SYNC_UUID';
|
