Why I can't find my database file in C: disc from DB Browser
I made database file called doctors.db in path given in following picture. I played with it in Command Prompt and it works perfect!
Now when I try to find it with program DB Browser for sqlite, you can see it is not possible to find it. Does someone know what the problem is? I am really surprised by this. I scrolled entire PC folder and still no sign of it..
Solution
Are you sure you've called it 'doctors.db', not just 'doctors'? The file type 'file' suggests it doesn't have its extension.
- Query to find position in a string before keyword and extract data before that position
- SQL: get next relative day of week. (Next Monday, Tuesday, Wed.....)
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- java.sql.SQLException: Column Index out of range, 2 > 1
- Should LIKE 'searchstr%' use an index?
- Multiple STRING_AGG in one query
- Postgres: Add constraint if it doesn't already exist
- UPDATE Statement ignores INNER JOIN
- Execute Stored Procedure Minimal API .Net
- Change default schema for user
- Oracle SQL - Select oldest of 3 dates, but ignore NULLs
- Housing Society management system database structure
- Keep getting error: PLS-00103: Encountered the symbol "CREATE"
- How to use an UPDATE Query with an INNER JOIN to update fields within a table
- Extract 4 million rows from database in chunks of 1 million rows each
- Aggregate into custom groups
- SQL query for chat application
- SQL basic problem when trying to SELECT 4 atributes and use GROUP BY with only 2
- How to modify query converting DATEDIFF to Oracle accepted syntax?
- Sales data analysis: calculate percentage of each product as per total sales
- Calculate the sum of values for the columns that meet the criteria
- Insert missing rows in time series consumption history
- Oracle database dependencies in PL/SQL
- How to autofill a field with data from another field in the same table?
- In Oracle: How to sort by group/cluster by a column value
- oracle SQL query - add date rows using different date
- How to fix products without cover image in PrestaShop
- IF ROW_COUNT() return error
- Select with like is not returning the correct results
- I am trying to get the start date ONLY from the column below using a SUBSTRING. Can someone tell me what I'm doing wrong?