I’m using Python and trying to compare two tables in SQL and match them by partial country names. So far I’ve gotten country names that match exactly. I’m running into an issue trying to get partial …
Tag: sqlite
Compare Two Relations in SQL
I just started studying SQL and this is a demo given by the teacher in an online course and it works fine. The statement is looking for “students such that number of other students with same GPA is equal to number of other students with same sizeHS”: It seems that in this where clause, we’re…
counting individual elements that meet a certain criteria without duplicates in sqlite3
I’m trying to count all the individual actors from movies in 2004 the problem is when I tried using the count() function it returned how much times every actor appeared in a movie that year. basically I cant get count() to play well with the GROUP BY function. relevant tables: movies (id, title, year), …
Storing date value into sqlite table in python3 stores integer value
I’m stuck with this bug and on how to solve it. Background: I have built a ‘Paycheck’ table in SQLite that has a date attribute, net pay attribute, and a gross pay attribute. I have set the date attribute to a date datatype in SQLite, and set the net and gross attribute to an integer datatyp…
Time series group by day and kind
I create a table using the command below: CREATE TABLE IF NOT EXISTS stats ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, session_kind INTEGER NOT NULL, ts TIMESTAMP NOT NULL DEFAULT …
Python3: Can’t write to text file with obtained data from SQL table
I think I am stucked on an easy job as a beginner but have to ask this question. My objective is to create another list from data obtained from a SQL Table. This list will be created in acocrdance …
SQLite C# System.Data.SQLite.SQLiteException
I want to insert data into a database via sqlite but each time I got the error below: Connection Established Successfully… code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error near “hpi_caseid”: syntax error at System.Data.SQLite.SQLite3.Prepare(SQLite…
Retrieve Total Chapters in each books
I have got the database which has id,chapter_name,chapter_num,verse_num,verse_text,testament as columns. I would like to retrieve chapterName and the total number of chapters in each book. I’m using the following query to do so, Unfortunately, it lists a very big count of chapter names and duplicate cha…
How to get the id from next inserted element before that is created?
I need to get the id from the future element insert in my table. I have an autoincrement id. await db.execute(‘CREATE TABLE Product(Id INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT)’); Imagine this …
‘KeyError’ while filling an SQL table with CSV data
I’m currently working on a project that’s requires wrangling OSM data (Udacity Course), and adding it to an SQLite dataset ready for queries. I’m currently trying to add a ‘.csv’ file to an exisiting SQL table with the following function: However each time I try to execute it get…