658,604 questions
-1
votes
3
answers
122
views
How to empty a single column in MySQL without updating each row individually? [closed]
I have a large MySQL table in phpMyAdmin, and I want to clear all data in a specific column.
I know how to do it using:
UPDATE table_name SET column_name = NULL;
Or by dropping and re-adding the ...
- 25
3
votes
1
answer
63
views
Error in MariaDB query - difference to MySQL
My host (Fastcomet) just upgraded servers, and moved from MySQL to MariaDB. Now I have SQL errors - probably due to slight differences in syntax.
I strugled to get it working under MySQL - and have ...
- 43
-3
votes
0
answers
74
views
Insert Data from Java to MySql [closed]
I don't know how to convert Java string numbers to insert them into MySQL table. The field 'peso' in MySQL is declared as float.
public void Conferma() {
// Creo un oggetto Prodotto
...
- 1
-4
votes
0
answers
84
views
How to save session shopping cart data into database [closed]
I have a shopping script where customers can add items to their cart and then view their cart.
But i don't know how to make the checkout page to be able to SAVE THE SESSION items (CART DATA) into the ...
- 21
-2
votes
0
answers
24
views
why is station_name suppressed in my LOAD DATA INFILE [duplicate]
In my bash script below I am able to load data into mysql, but somehow some fields are not correctly captured.
#!/bin/bash
DB_USER="myuser"
DB_PASS="mypass"
DB_NAME="aws_db&...
- 1,588
0
votes
0
answers
50
views
PHPMyAdmin won't let me update a password for a user account, even though I'm logged into the root account [closed]
I'm trying to update the password for the user account in a MySql database managed through PHPMyAdmin. I'm logged in as root and I'm changing the password through User accounts/change password. Here's ...
- 459
-4
votes
0
answers
38
views
Restored mysql directory in XAMPP and now MySQL server won't start [closed]
When I changed my development machine to a Mac, it created case sensitivity problems with the database on my XAMPP server. I was attempting a solution offered here: MySQL case sensitivity table name ...
0
votes
0
answers
34
views
Safe deployment of new features for live Flutter app with Node.js backend [closed]
I have a Flutter app live on the App Store with ~400 users and a Node.js backend running on AWS EC2 with MySQL. I want to add new features safely without breaking the app for current users.
...
-1
votes
0
answers
30
views
Cannot Start mysql.service on ubuntu after restore of files [closed]
I had to restore the MySQL files on Ubuntu from a system backup. Unfortunately mysqld will not start. I chowned the directory to mysql:mysql but I still get this error:
`Defined-By: systemd
Support: ...
- 620
-2
votes
0
answers
35
views
MySQL Stored Procedure INSERT INTO a temp table from CTE erroring [duplicate]
I am creating a temp table in a stored procedure to hold the results of a CTE query. Without the temp table the query works fine. The code is below. I keep getting an error at the INSERT INTO line - ...
- 1
0
votes
0
answers
96
views
SQL table(s) to get desired output in PHP [closed]
I have a PHP table in this format:
$Output = array (
'strSMD' => array (
'name' => 'blabla',
'server' => 'https:/blabla.com',
'profile' => 'https://blabla.com/...
- 1
-3
votes
1
answer
57
views
Why mysqldump is returning cannot find table ">" in python subprocess [duplicate]
i have created a mini python tool to backup using mysqldump
import os
import subprocess
from datetime import datetime
from dotenv import load_dotenv,dotenv_values
load_dotenv(dotenv_path="./...
-1
votes
0
answers
52
views
How to setup MySQL InnoDB Cluster for High Availability in Docker Compose [closed]
I am trying to set up a MySQL InnoDB Cluster for High Availability in Docker Compose. Below are the files.
docker compose
version: '3'
services:
mysql-server-1:
container_name: mysql-server-1
...
2
votes
1
answer
74
views
Mysql query to show records with 3 date criterias
I need a little help with a select query please.
I need to pull 3 records at a time from a table to display on a form where people can sign up to one or any of the three matches displayed on the form
...
- 81
1
vote
3
answers
64
views
How to count distinct concurrent resource max usage using a mysql query?
I have to validate a software license based on the concurrent resources concurrently used.
I have this MYSQL table:
resource-id
from
to
1
13/01/2026 09:00
13/01/2026 20:30
1
14/01/2026 18:00
14/01/...
- 9,667
