![]() Next time you ask a question, you might find it beneficial to set up a dbfiddle for those who are trying to solve your issue - help us to help you!īTW, SQLite (unlike other systems) doesn't support UPDATEs with JOINs. You can find all this on the dbfiddle here. The result of SELECT * FROM master after the UPDATE: m_id m_value Then I ran the following query: UPDATE master To answer the first part of the question, I did the following:Īdded some records: INSERT INTO master VALUES (1, 'Buy') Unfortunately this doesn't seem to work, and I'm not even sure where to start on the DELETE. Value = (SELECT scheduled.value FROM scheduled WHERE scheduled.id = master.id)ĮXISTS (SELECT * FROM scheduled WHERE scheduled.due >= ?) I'm new the SQLite, the closest I have gotten is the following: UPDATE master I'm trying to craft a query where if I run it after 12:01:00, I would like to see: Table: master Imagine this is the starting state: Table: master Once the master table is updated, I would like to delete those values from the scheduled table. ![]() ![]() I would like to update a value in the master table with the value in the scheduled table if I run a query some time after due has occurred. I have an application using SQLite with two tables a master table and a scheduled table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |