Categories
Database Development

Getting proper output of my SELECT clause. SQLite

I am coding a bus connection search engine. My goal is to see the time when the bus is departing, while the stop_from and stop_to names are provided. I have created the STOP table CREATE TABLE STOP ( ID INTEGER PRIMARY KEY, STOP_NAME TEXT NOT NULL, ROUTE_ID INTEGER NOT NULL ); and the TIMETABLE table […]

Categories
Database Development

Getting proper output of my SELECT clause. SQLite

I am coding a bus connection search engine. My goal is to see the time when the bus is departing, while the stop_from and stop_to names are provided. I have created the STOP table CREATE TABLE STOP ( ID INTEGER PRIMARY KEY, STOP_NAME TEXT NOT NULL, ROUTE_ID INTEGER NOT NULL ); and the TIMETABLE table […]