I want to run the following code, but Python gives me an error code : select = input("ENTER USER FOR PASS RECOVERY : ") cursor.execute("SELECT COUNT(*) FROM user_stat WHERE usr=(%s)",(select)) python code error : mysql.connector.errors.ProgrammingError: 1064 (42000): You have an…
basically when in another page someone chooses a category it redirects him to this page and adds "?category=(category he choose)" to the url, then it checks in this page what's his category and pulls the ids from db where the…
Assuming that I have 20L records, Approach 1: Hold all 20L records in a single table. Approach 2: Make 20 tables and enter 1L into each. Which is the best method to increase performance and why, or are there any…
I'm having trouble manipulating certain information in a Select. I've tried a few ways but with no positive result. Select: select cpri.sequential, cpri.id, coalesce(sum(pdr.something), 0) something, ... from cpri inner join cpr on cpr.id = cpri.id left join pdr on…
I'll give an example to better clarify what I want: Suppose I have the following classes in my programming language: Class Person( int id, string name, List<Car> cars ); Class Car( int id, string name, string brand ) I want…
I need a report of which cars (license plates) are parked in and when. This is an example of my table. id lic_plate datetime lane _________________________________________________ 10 1234-JM 2022-10-07 12:24:33 IN 11 1234-JM 2022-10-07 12:29:57 OUT 12 5678-PC 2022-10-07 15:14:17…
I am trying to count the number of consecutive weeks an employee went to work. So I have this table that has whether jon or andy went to work on certain weeks (I have all week of the year). I…
My salary table looks like this, employeeId Salary salaryEffectiveFrom 19966 10000.00 2022-07-01 19966 20000.00 2022-07-15 My role/grades table looks like this, employeeId grade roleEffectiveFrom 19966 grade 3 2022-07-01 19966 grade 2 2022-07-10 I am trying to get the salary a…
I have this membertype table: | member_id | member_name | |-----------|-------------| | 901 | Liz | | 902 | Margaret | | 903 | Bob | and this revenue table: | GIS_ID | Member_ID | Total_Revenue | Total_Discount | Number_Transaction…
original question: Determine, for all presidents who married only woman older than 30, id and the sum of children number in all their marriages? issue: The issue is that the pres_id 44 has three columns with 3 different presidents and…