Category "mysql"

Symfony 3.4 and MySQl 8. General error: 2006 MySQL server has gone away when running a transaction in a rabbitmq queue

I have one system (Symfony 5, symfony/messenger) sending data to another (Symfony 3.4, enqueue/enqueue-bundle 0.9) using a rabbitmq queue. The data is used to c

Docker Container cant connect to MySQL database

I have a MySQL instance running in a docker container, available on my host system at port 3333. I already tested the connection via the MySQL workbench to veri

How to use group by and ordery by with some operation in SQL? [closed]

I have two columns price and sold_count for the product table. How do write sql query to find the top 3 shops having highest Revenue (calculat

mysql command is not found in macOS

I have installed MySQL with .dmg installation file according to the official page. But it returns command not found: mysql when I execute mysql command. How to

My password_verify for a value from database always return false

include("src/database.php");#this included file works wll $query=mysqli_query($conn,"SELECT * FROM students limit 1"); $data=mysqli_fetch_assoc($query); echo "m

how can i display the name of a professional from a patient's appointment?

I have this four tables: One for users, other for professionals, other for patients y another for appointments. I want to get the name of professional from pati

retrieving first rehire and terminated dates and second rehire and termination of employee

I want to write a SQL Query to fetch 1st rehire, termination date and 2nd rehire, termination dates of employee if employee doesn't having those dates then it w

retrieving first rehire and terminated dates and second rehire and termination of employee

I want to write a SQL Query to fetch 1st rehire, termination date and 2nd rehire, termination dates of employee if employee doesn't having those dates then it w

Update on Duplicate key with two columns to check mysql

I am trying to get my head around the 'On Duplicate Key' mysql statement. I have the following table: id (primary key autoincr) / server id (INT) / member id (I

Prisma: update nested entities in a single query

I am using Prisma and Express.js to make requests to my MySQL database table. I have one-to-many relationship between my Contest-Round tables and am trying to w

I would like to use R Shiny to upload csv data to MySQL table and display

Apologies for the long question. I wrote the following R script to upload/append some csv files i get on a regular basis to a MySQL database. The examples files

Very persistent /opt/lampp/bin/mysql.server: 264: kill: No such process. Xampp/ubuntu 16.04

I installed XAMPP on Ubuntu. MySql-server fails to run properly. I tried many solutions, as suggested by google "/opt/lampp/bin/mysql.server 264 kill no such

I can't delete my image when it is liked because of the foreign key in mysql

There is the schema of my db : And I've got this error message when I try to delete a picture : SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot de

MySQL group rows

I have a table with: Id (id of rider) Time (is the time that he has done) Session (number session where the time was done) idlap idRider session time 1

preg_replace vs ereg_replace vs str_replace On This Particular Case

Using PHP, I want to generate custom MySQL dump file (due to cannot use exec and a few other reasons). I found these 2 similar solutions: https://www.kvcodes.co

MySql not showing in Visual Studio

I have downloaded Mysql.data , Mysql.data.entityframework , mysqlconnector and additionally downloaded mysql installer.But Mysql not showing in Visual studio 20

Maintain Datagridview Checkbox State while using filter

I have a datagridview which I populated thru mysql query Using command As New MySqlCommand("SELECT p_code as 'Prodcut Code', p_name as 'Product Name', filter "

Having issue with matching rows in the database using PDO

I am looking to get row count to check if same email is already in database or not. i have tried couple of mechanism but no success. when i run my query directl

Delete rows with null values mysql

I want to delete the rows with null values in the column How can i delete it? SELECT employee.Name, `department`.NUM, SALARY FROM employee LE

how can I update multi specific rows in mysql and php ? in the example there are tow rows 50 , 51 I need to update "quantity" and "note"

how can I update multi specific rows in mysql and php ? in the example there are tow rows 50 , 51 I need to update "quantity" and "note" . SN | Medication | Qya

Other Categories