Re: [sqlite] [EXTERNAL] Understanding SELECT statement

I understand now a little better, how SELECT statement works. Thank you all for the explanations. Hick Gunter ezt írta (időpont: 2018. jún. 26., K, 16:23): > > There is no DATE datatype in SQLite. Your declaration assigns NUMERIC > affinity for the date column. > > It seems that you are storing

Re: [sqlite] [EXTERNAL] Understanding SELECT statement

There is no DATE datatype in SQLite. Your declaration assigns NUMERIC affinity for the date column. It seems that you are storing TEXT values, which is allowed, but in conflict with your declaration. Since you have not declared INTEGER PRIMARY KEY, you only achieve what UNIQUE alone would have