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
can anybody tell me how to implement a split function in mysql which behaves like Javascript split. I want a function like this SELECT Split('a,b,c,d', ',') A
I installed MySQL via brew, but instead of letting me set a root password after mysql_secure_installation, I get prompted for the root password instead. % brew
I need to support an old site. using HTML4, <meta http-equiv="Content-Type" content="text/html; charset=windows-1252" > and DB TABLE fields with latin1_
There is a blood bank which maintains two tables: DONOR that contains information on the people who are willing to donate blood and ACCEPTOR, the people who are
i am using onKeyUp event for fire api without submitting the form and i fetched data in response successfully if Mobile number matched. But i don't understand h