SELECT ID, Item_ID, Lookup_1, Measure, Descriptor, Required
FROM #lookupDb#.pValue_Lookup
WHERE Description =
ORDER BY ID ASC
SELECT IFNULL(MAX(ID), 0) + 1 AS n FROM #lookupDb#.pValue_Lookup
SELECT COUNT(*) AS c FROM #lookupDb#.pValue_Lookup WHERE Item_ID = 17
SELECT IFNULL(MAX(Item_ID), 0) + 1 AS n FROM #lookupDb#.pValue_Lookup
INSERT INTO #lookupDb#.pValue_Lookup (ID, Item_ID, Description, Required, Lookup_1, Lookup_2, Measure, Descriptor)
VALUES (
,
,
'Height', '*',
,
NULL, 'inches',
)
UPDATE #lookupDb#.pValue_Lookup SET Required = '*'
WHERE Description =
INSERT INTO #lookupDb#.pValue_Lookup (ID, Item_ID, Description, Required, Lookup_1, Lookup_2, Measure, Descriptor)
VALUES (
,
,
,
,
'0', NULL,
,
NULL
)
SELECT ID FROM #lookupDb#.pValue_Lookup
WHERE Description =
AND ID >
AND IFNULL(TRIM(Descriptor), '') = ''
AND IFNULL(TRIM(Lookup_1), '') <> '0'
ORDER BY ID ASC LIMIT 1
UPDATE #lookupDb#.pValue_Lookup SET Descriptor =
WHERE ID =
INSERT INTO #lookupDb#.pValue_Lookup (ID, Item_ID, Description, Required, Lookup_1, Lookup_2, Measure, Descriptor)
VALUES (
,
,
,
,
NULL, NULL,
,
)
Vitals: descriptors / Height / Weight
Vitals setup in #encodeForHTML(lookupDb)#.pValue_Lookup