I am receiving the error of SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 i
Here What I did is I have a user entity and a role entity. Every user can have one role. I have set up many-one relationship in role entity. I have create an en
Surveys table: enter image description here Questions table: enter image description here My sql query: SELECT s.id, q.question FROM questions q JOIN surveys s
Looks like my ORM, Prisma, does not allow for rolling back a migration. How have folks using Prisma rolled back a migration? Is there a way to manually rollback
I have two tables in a MySQL database: address that includes a description field which at most has a city name and a country buried somewhere inside it. There a
I will be very grateful for any help. My situation.. I have a table with students (I write only main columns for this question): | Id | Lastname | Firstname | _
I am making a cinema booking system for my dbms project. for the bookings table , I only want a certain number of inserts in a table to be possible. How can i a
I'm creating a simple php program and I'm trying to find a way to be able to go from the page 2 back to the page 1 with a button. I tried by making a button in
The SNO seems to be misdirecting So, I simplified the question even further --creation CREATE TABLE LAB (JOB_ID int, LAB_ID VARCHAR(50)); CREATE TABLE SPR (JOB_
I need to fill multiple different arrays by using a MySQL query. This would have up to 16 different arrays. I want to specify each array with
I have this Existing table tb1 in my database Now new data comes and new data is stored in another table tb2 Earlier Account_Number 9988 was Level 2, But now
I have a table like below with two columns Person and Supervisor. Person Supervisor 1 3 2 3 3 4 I want to select rows where the Supervisor column only has val
I opened PopSQL and the there is a red dot at my connection. If I go into it and test it, it tells me Unknown database 'giraffe'. I opened mySQL and typed 'show
I am trying to find the average number of rental books for each quarter. Rental(RegNum, DateBorrowed, DateReturned) Books(RegNum, BookName, Category) What i am
I have a table called products which has a varchar column called name encoded in latin1_swedish_ci. I'm trying to make a search query in order to filter product
I am looking for some help. I need to create a dependent dropdown based on the previous input. Everything works in my code, and it sends and receives data from
I'm working on a student project. I'm building an e-commerce website to sell soaps, and the error message I'm getting is the following. Fatal error: Uncaught E
I'm trying to make a secure connection with my database I wrote the following code: <?php // form filled? if (isset($_POST['submit'])) { $user = 'gebrui
I am running a MySql 8 DB and using Visual Studio 2017. Here is my VB code. Try With prm .Direction = ParameterDirection.Input .MySqlDbType
i have two 3 files 1 for the database and the others is for add the data and the index but my adddata.php doesn't catch the value and just ret