I have a table called "Student_fees_deposit" and in this table, a column has multiple values in it. An example is Student_fees_deposit id | amount_detail ---|---------------- 1 |{"1"{"amount":"5000.00","date":"2022-12-15","amount_discount":"5000.00"}} 2 | {"1":{"amount":"9000.00","date":"2022-12-15","amount_discount":"5000.00"}} How can I get the amount value for id =…
I have the following query SELECT price FROM prices left join suppliers s on prices.id_supplier = s.id_supplier AND prices.id_product = 57; Table structures are as follows: Suppliers: id_supplier name 1 Supplier 1 2 Supplier 2 3 Supplier 3 Prices id_pk…
I am currently working on a project which will have so many queries run a same time. and I am sending data to database in one table and want to check if the data is successfully inserted. I read about…
Why is there an error when updating or editing data in Laravel using a data array, like this error. foreach() argument must be of type array|object, string given Database in MySQL: Screenshot my Database in MySQL Code: Controller: public function…
import mysql.connector cnx = mysql.connector.connect( user='db', password='yab@db', host='3306', database='database1' ) cursor = cnx.cursor() query = 'SELECT * FROM your_table' cursor.execute(query) results = cursor.fetchall() for row in results: print(row) cursor.close() cnx.close() I am try to connect to mysql database through python…
I work for a web-hosting company. I'm rather green, and being new, I only have non-root access to our clients' servers. Often, I need to troubleshoot mysql. Since I don't have root, I must use the clients' mysql credentials. These…
Want to ask why my data from the database (MySQL) doesn't all appear on the website from the grades table join with the grade_details table, my database is attached: Screenshot my Database in MySQL So this data is from the…
I'm working on for presence control. The check-in and check-out are 2 difference records in a table It is possible that somebody does not check-out for several days, but should count as present for the particular day person ID -…
Hope y'all are enjoying the holidays. I am attempting an automated installation of wordpress on my Linux VM using ansible. To that end, I have written this ansible piece of code that tries to mimic the official ubuntu guide. Here…
I need to join two tables: our_sample and tls207_pers_appln from PATSTAT. our_sample' has 4 columns: appln_id, appln_auth, appln_nr, appln_kind. tls207_pers_appln has 4 columns: appln_id, person_id, applt_seq_nr, invt_seq_nr. our_sample has 2191 rows and some (60) of them are missing in tls207_pers_appln.…