Re: [sqlite] How to Verify (know that they are correct) Queries in SQLite GUI Manager Firefox add-on?

Message- From: Dwight Harvey <dharv...@students.northweststate.edu> To: sqlite-users <sqlite-users@sqlite.org> Sent: Sun, Dec 7, 2014 9:24 pm Subject: [sqlite] How to Verify (know that they are correct) Queries in SQLite GUI Manager Firefox add-on? I am a student with no Tech or IT bac

Re: [sqlite] How to Verify (know that they are correct) Queries in SQLite GUI Manager Firefox add-on?

The question is ambiguous does he want all the Fred Smiths or just a specific Fred Smith? For example, do we have a case of mistaken identity? How many Fred Smiths are out there? Or does he want All the records for a specific person named Fred Smith? If it is a specific person, is there a

Re: [sqlite] How to Verify (know that they are correct) Queries in SQLite GUI Manager Firefox add-on?

You didn't provide the data set, so it'll be a guess. You'll need to look at the data and do some mental work on comparing what you expect versus what your query result comes back with, and prove what is in the database is what your query is EXACTLY asking for. (Returning on last names of

Re: [sqlite] How to Verify (know that they are correct) Queries in SQLite GUI Manager Firefox add-on?

ite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Dwight Harvey >Sent: Sunday, 7 December, 2014 19:25 >To: sqlite-users@sqlite.org >Subject: [sqlite] How to Verify (know that they are correct) Queries in >SQLite GUI Manager Firefox add-on? &g

Re: [sqlite] How to Verify (know that they are correct) Queries in SQLite GUI Manager Firefox add-on?

On 8 Dec 2014, at 2:24am, Dwight Harvey wrote: > I know very little and Databases are complex and intimidating. > > I figured out how to run queries but I don't know if they are > correct/accurate, as in what I requested from the 'RUN' results? > > How

[sqlite] How to Verify (know that they are correct) Queries in SQLite GUI Manager Firefox add-on?

I am a student with no Tech or IT background what so ever. I am new to Databases and IT in general. I am taking an accelerated class in database basics and within the last three weeks I just learned what databases were. I know very little and Databases are complex and intimidating. I figured