I have a product system that each category can have multiple subcategory layers if there aren't any products attached to them, and we can attach as many products as we want to a category if there aren't any sub-categories attached…
This is a rails app that uses Vue as front-end. There are 2 similar models/tables, named user_notifications and seller_notifications, that have the same columns. In the user_notifications_controller there are 2 distinct actions, one that shows only user_notifications (for the My…
using this query: SELECT ARCustomerCode, count(ARCustomerCode) FROM customers group by ARCustomerCode having count(ARCustomerCode) > 1; I am able to identify the number of rows where ARCustomerCode is not unique. How can I update each duplicate ARCustomerCode field by appending the…
I have a table and I want to select all unique values of all attributes in one query. For example table Person with 3 columns name, age, city. Example: Name age city Alex 34 New York Leo 34 London Roy…
I'm new to Python. I'm building a learning application that allows users to run sql queries on training tables directly from a browser. I am using FastAPI + Jinja2 + PostgreSQL. I am using ACE as a code editor. Is…
I have a table like below report_code | result_of_report _______________________________ Rpx-34512-00| rejected Rpx-34512-01| rejected Rpx-34512-02| rejected Rpt-22433-00| rejected Rpt-22433-01| rejected Rpt-22433-02| rejected Rpt-22433-03| rejected Rpt-22433-04| rejected Rpt-22433-05| rejected Rpt-22433-06| accepted Rcs-34555-00| rejected Rcs-34555-01| rejected Rcs-34555-02| accepted And this is what…
I have three tables accounts, receivables and receiveds . My basic table is receivables I want to get the names from the account table and then subtract the sum of received column in receiveds table form the receivable column in…
MySqlConnection con = GetConnection(); string sql = "SELECT COUNT(ID) FROM booking WHERE DATE(Booking_Date) = CURDATE()"; string sql2 = "SELECT SUM(Fare) FROM booking WHERE DATE(Booking_Date) = CURDATE()"; MySqlCommand cmd = new MySqlCommand(sql, con); cmd.CommandType = System.Data.CommandType.Text; MySqlDataReader BookingToday = cmd.ExecuteReader(); while…
I have a table: select * from users id | name | company_name 1 | Sam | Sam's Plumbing 2 | Pat | Pat's Bakery 3 | Vic | I want to move users.company_name to a new companies table, with…
I'm trying to filter my table 'mange' with the condition of customers who eat both the "mexicaine" and the "végétarienne". I have a table 'mange' which contains 'nom' and 'pizza' I have tried to filter with select * from mange…