I have a problem with my PHP and MySQL code. I was creating a private messaging system but unfortunately, each time I reload the page, the las
I have made a query on a data and it returns a result: [ RowDataPacket { 'COUNT(t.id)': 2 } ] How can I access it like the count number? I have tried result.COU
I have this table state num ------------------------- ca 20 ny 30 ca 50 ca 10 ny 70 ny 90 What I want is to p
I have installed a third party framework fate, and mysql has been installed inside this framework, at the following path: /data/projects/fate/common/mysql/mysql
I have following query to handle null value and flag those based on two table join however c.pure_proc_flag is null then 0 else 1 does not provide the result
conn = mysql.connector.connect(host="localhost", user="root", password="", database="Attendance") my_cursor = conn.cursor() my_curso
I have the following structure of my database, implementing a simple EAV model (see pic): My product has a type, which through the junction table restricts pro
I have tried my best to debug this issue for the past few days with no luck. I am a beginner so there could totally be simple things I just didn't know. So I ha
"SELECT * FROM `user` WHERE `id`=" . $adminID . " ORDER BY `name` ASC LIMIT " . $start . "," . $length try to get data but the response showing []
This is my code my $sql variable didn't give query plese help me for this I try this but I couldn't please help me with that <?php $connect = mysqli_con
i used this query java and mysql but its not work (if i send directly mysql console its work bun in java not work.) Here down is my code: PreparedStatement pst;
I need to make an alter table via migration on a node:14 server with umzug. The code is : IF NOT EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_
Here is a glimpse of my .csv file: Name,Start Date,End Date,Budget Class 1,1/1/2020,31/1/2020,"USD10,000.00" Class 2,1/2/2020,28/2/2020,"USD14,000.00" The date
I am using sqlalchemy with MySql. I need to return a dict in select. Adding that dict value to fetched data is not an option. Is there any way in sqlalchemy or
I have this user table structure. `users` ( `id` bigint(20), `balance` bigint(20), `current_parent` bigint(20), `parents` varchar(45
we are currently in the process of migrating latin1 databases to UTF8 in a MySQL Server. We are investigating what is the best approach and hopefully without an
I'm trying to Delete all the records related to this supplier from all relevant tables for Supplier with supplierNum = S3. But when I try to delete, I get an er
We are using very simple SELECT … WHERE queries (1000 rows, from a very small table with 18000 entries) to load time series data for plotting (for testin
I have data in the below format { "userId": 1 "stateId": 199, "productId": [ 1, 2 ] } I want to get this type of response
Even though I already started the game on the teacher's side, the code keeps on returning 'notrunning' so does this just mean that is_null($result[0])? <?php