INSERT INTO words (
baseWord,
serverVersion,
translatedList,
transcription,
partOfSpeech,
examples,
image,
synonims,
categoryId
)SELECT
baseWord,
serverVersion,
translatedList,
transcription,
partOfSpeech,
examples,
image,
synonims,
0
from ...date_end, time_enddate_start, time_start datetimeпотом в epochпотом castв long, вычесть и отформатироватьselect STRFTIME("%H:%M:%S", CAST( strftime('%s',datetime(date_end, time_end ) ) AS LONG ) - CAST( strftime('%s', datetime(date_start, time_start ) ) AS LONG) ) from _variables;drop table IF EXISTS _Variables;
CREATE TEMP TABLE _Variables(date_end date, time_end time, date_start date, time_start time) ;
INSERT INTO _Variables VALUES ('2022-01-21', '13:00:00', '2022-01-21', '01:00:00');LIKE CREATE TABLE contacts (
first_name text NOT NULL,
last_name text NOT NULL,
email text NOT NULL
);CREATE UNIQUE INDEX idx_contacts_emailEXPLAIN QUERY PLAN
SELECT
first_name,
last_name,
email
FROM
contacts
WHERE
email LIKE 'lisa.smith@sqlitetutorial.ne%';SEARCH TABLE contacts USING INDEX idx_contacts_email (email>? AND email<?)TABLE SCAN
src/main/resources/application.properties:spring.datasource.url = jdbc:sqlite:${USERPROFILE}\\sqlite\\database_name.dbString.format("%s/src/main/resources/%s",
System.getProperty("user.dir"), resourceFileName);