I enter that code, but it doesn’t work properly and it shows the power several times image Image >Solution : This seems to be happening because you have 3 products that have category id as ‘3’ and that category name I guess is ‘Power’. So, when you are selecting all the categories where each category… Read More Why does it display the power field several times?

SELECT MAX(SELECT MAX(LENGTH(`name`)) count FROM `student_info` UNION SELECT MAX(LENGTH(`address`)) count FROM `student_info` UNION SELECT MAX(LENGTH(`class`)) count FROM `student_info` UNION SELECT MAX(LENGTH(`roll`)) count FROM `student_info` UNION SELECT MAX(LENGTH(`subject`)) count FROM `student_info`) FROM `student_info` by using similar type of query i want to find one max value of string so i can manage table properly. what is… Read More I want to find max lenght of string from a tabe in SQLite

I’m trying to count distinct values across columns using sqlite3 in python but cant seem to get the correct results. Am only able to get the count of distinct values in 1 column. I’ve create a database and imported the csv file as a table conn = sqlite3.connect(‘test.db’) curr = conn.cursor() curr.execute(‘DROP TABLE IF EXISTS… Read More Counting distinct values across columns using sqlite3 in python

SQLite3 on Linux Arch. One table of country names, which is going to be referenced through foreign keys by a different table listing the FIFA World Cup host country and champion for each edition. Ideally I will extend it to multiple fields like: runner-up, bronze medalist, fourth place, etc. The table with the list of… Read More Ambiguous column name in SQLite3, but ambiguity hard to avoid

So, I am fetching a record from a table in SQLite but I don’t want to include the first column which is "id" and primary key in the table. But I can’t seem to achieve that. After fetching a row, I have the row data object. Is there any way, I can use the data… Read More How to remove a specific column value from SQLite Row Object in Python

Let’s imagine I have two sqlite tables: CREATE TABLE T_A (year_A INT, amount_A DOUBLE); and CREATE TABLE T_B (year_B INT, amount_B DOUBLE); Those tables contain data below: table T_A year_A | amount_A ———————- 2020 | 100.0 2020 | 200.0 2021 | 300.0 2021 | 400.0 table T_B year_B | amount_B ———————- 2021 | 1000.0 2021… Read More FULL OUTER JOIN emulation and aggregate function (e.g. SUM)

I’m trying to get a count of document where the email of my user appear, I’m doing this for every user so I use a loop which takes every email of my user that got a document (to avoid having people with 0 document). So I know for sure that i got 5 row (5… Read More Weird result with sqlite in python

I am trying to creat a view of database. I would need to select only the values from Comments.FK_CommentID which are NOT NULL but I can’t seem to know how to solve it. Here’s my view: CREATE VIEW Comments_of_comments AS SELECT User.Username AS User, Comments.content AS Comment, Comments.FK_CommentID AS ‘Commented on’ FROM Comments INNER JOIN… Read More Adding NOT NULL constraint to one SELECT Column

IN MY EMPLOYEE TABLE COLUMN "HIREDATE" HAS (DATETIME) FORMAT AND I AM GETTING ERROR WHEN I TRY RETRIEVE THE DATA BY THIS QUERY BELOW: SELECT FirstName, HireDate FROM employees WHERE HireDate (‘2002-08-14 00:00:00”) I AM GETTING AN ERROR IN SQLITE. Execution finished with errors. Result: unrecognized token: "’2002-08-14 00:00:00”) " At line 1: SELECT FirstName,… Read More HOW CAN I CORRECT THIS SQLITE SYNTAX ERROR

how can i send a parameter to a query this is my code import pandas as pd import sqlite3 def query_brand(filter): sql_query = pd.read_sql(f’SELECT * FROM ps_lss_brands WHERE label = {filter}’, self.conn_brand) df = pd.DataFrame(sql_query, columns = [‘id_brand’, ‘label’]) # print(df["id_brand"][0]) print(df) query_brand("ACURA") this the error that i get pandas.errors.DatabaseError: Execution failed on sql ‘SELECT… Read More how to send parameters with f-Strings in a sqllite query python