I created a table using this schema using sqlite3:
vs table monitor Done_files (file_id INTEGER primary key, file_name VARCHAR (32767), original_related_dir_ pathVARCHAR (32767), backup-up_related_dir_ pathVARCHAR (32767), directory_id INTEGER);
Now, I would like to get all the records where the original _relative_dir_path '.' Is equal to, without 'what I have done is:
choose from the monitored files * where the original_related_dire_path ='. ';
The result is not a record, even though I have this record in the table:
1 | 'P9040479.JPG' | '.' | '| . '| 1
I read on the web and I did not see any mistake in my syntax ... I also tried to like it. ', But still no results. I am not an expert in SQL, maybe you can see something wrong? Thanks!
I have no problem with the statement.
I have created the table you have mentioned
There was no INSERT with the same values provided by you.
and did the query, and inquired even without any clause.
No problem, so I suspect that when you execute your selection, then you should be connected to the correct database.
Comments
Post a Comment