Questions tagged [mysql]
MySQL is a free, open-source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). DO NOT USE this tag for other DBs such as SQL Server, SQLite etc. Those are different DBs that all use their own dialects of SQL to manage the data. Always specify the exact version of the server in the question. Note that configuration/setup-related questions are off-topic on stackoverflow.
mysql
661,892
questions
0
votes
0
answers
13
views
Setting MariaDB encryption
Hello I need to Configure a MariaDB server to provide data encryption during storage. I am performing the task on linux oracle 9. when I try to restart the server, I get the following message
[vagrant@...
-2
votes
0
answers
16
views
MySQL mysql --login-path always connects to local server [closed]
I am starting to use mysql_config_editor to configure connections to remote servers. Until recently, I've been setting up only local connections, and things seem to work as desired.
But now I have ...
0
votes
0
answers
28
views
Fetch all rows which contain value from comma separated values [duplicate]
I have two mysql tables... Students and Batches
batches table :
id | batch_name
1 Monday
2 Tuesday
3 Wednesday
4 Thursday
5 Friday
6 Saturday
...
-3
votes
0
answers
12
views
How do I recover a MySQL database and it's data from .IBD files [MAC OS] [duplicate]
I recently deleted my local MySQL 8.0.32 macOS server and reinstalled version 9.0.0. I wasn't able to extract the schema and data from the databases on the old server since I was unable to launch it. ...
-2
votes
2
answers
19
views
Insert custom date into mysql timestamp field
I try to insert values into a new table. This is the insert with certain date format (dd/mm/yyyy h:m):
INSERT INTO `sport` (`TIME`, `HOME`, `VISIT`, `HOME_RESULT`, `VISIT_RESULT`) VALUES ('20/07/2024 ...
-3
votes
0
answers
16
views
Qual é a diferença entre usar '=' ou ':=' para atribuir um valor a uma variável no mysql? [closed]
Eu estava executando algumas querys com variáveis quando eu cheguei na seguinte dúvida:
executar o comando '@variavel = dado' e o 'comando @varivel := dado' fazem a mesma função, só que as coisas ...
-1
votes
0
answers
25
views
problem in delete function in java and mysql [closed]
error message when i press delete حذف
I have a table connected with mysql when I choose a row to delete it doesn't work
here is the code of delete
private void l2MouseClicked(java.awt.event....
0
votes
0
answers
20
views
How to Convert a Complex SQL Query to Hibernate Criteria API
I'm learning about Hibernate's Criteria API and would like to know how to convert this particular SQL query to Criteria API. Here is the SQL query I’m working with:
select s1.score as score,count(s1....
-2
votes
0
answers
12
views
Database in MySQL for an app on Android and Apple Playstore
So guys I recently learned the basic of MySQL to create a database for my startup, My app team just launched an app for us how do I give them permissions to use my database with the app and any other ...
0
votes
0
answers
19
views
.net azure vm and mysql
I have a .net service running, when it runs out of memory (every 10hours ish, nother issue) and it crashes.
When I restart the service it cannot connect to the mysql database. I get authentication ...
0
votes
1
answer
22
views
Remove unreferenced records from database
I have 3 tables in a MySQL database
user
--------------------------------------
user_id, (PK)
email
agreement_user
--------------------------------------
agreement_user_id, (PK)
user_id, (FK user....
-2
votes
2
answers
59
views
Why I am getting Missing From Keyword error in the following code?
The cancellation rate is computed by dividing the number of canceled
(by client or driver) requests with unbanned users by the total number
of requests with unbanned users on that day.
Write a ...
0
votes
1
answer
41
views
syntax error, unexpected string content "", expecting "-" or identifier or variable or number
In a PHP application I am trying to the users information from the table like below
session_start();
$sql = "SELECT * FROM users WHERE company_id = $_SESSION['companyId']";
$result = $...
-2
votes
0
answers
44
views
ER_BAD_FIELD_ERROR in SQL [closed]
CREATE DATABASE IF NOT EXISTS RAIL;
USE RAIL;
CREATE TABLE IF NOT EXISTS train (
t_id INT NOT NULL AUTO_INCREMENT,
t_rating INT NOT NULL,
t_name VARCHAR(20) NOT NULL,
t_price INT NOT ...
0
votes
0
answers
21
views
ER_NOT_SUPPORTED_AUTH_MODE Error even though mysql2 is being used [duplicate]
I am receiving an error
ERROR [ExceptionHandler] ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
every time I try to ...