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,921
questions
0
votes
2
answers
55
views
How can I group results where string has the same 6 characters from a total of 7 in MySQL/MariaDB?
I have a table that consists of vehicle plates, where all the plates have always 7 characters.
Sometimes a plate was miswritten and so my SELECT query must be able to consider that "AAU1234" ...
- 31
-2
votes
0
answers
24
views
How do I connect MySQL db to use locally in development?
I'm building a Next.js application that needs user authentication.
I'm trying to set up a MySQL db in CPanel for that. I am currently mainly interested testing this locally on my laptop.
In CPanel, I ...
0
votes
0
answers
26
views
Query is not fetching the latest data from MySQL while using FOR UPDATE clauses
I have a table which locks rows as per accountId and a lock status column having values 0 and 1.
CREATE TABLE lock (
id INT(11),
accountId INT(11),
isLocked TINYINT(2),
);
The requirement is ...
-3
votes
0
answers
16
views
HttpErrorResponse et ERR_CONNECTION_REFUSED in angular [closed]
enter image description here
Error fetching client and net::ERR_CONNECTION_REFUSED I have to write cin and the nom and prenom should write automatically in input values ( i make connection between ...
-7
votes
0
answers
42
views
hi Where is the error in this query? someone can help me? [closed]
SELECT view_fav_items.* ,1 AS fav FROM view_fav_items
INNER JOIN fav ON fav.fav_itmesid = view_fav_items.items_id AND fav.fav_userid = 17
UNION ALL
SELECT * , 0 AS fav FROM view_fav_items
WHERE ...
0
votes
0
answers
23
views
JDBC : UTF-8 Characters not getting stored in SQL table in right format
I am trying to write a dataframe in SQL table which is having some extended ASCII characters like 'em-dash', pound symbol. But same is not getting written in DB table, showing some junk characters ...
0
votes
3
answers
66
views
How to move the last row to the top in a table in MySQL?
I have a row in the following table which is the first row but added to the table at the end and now I'd like to modify the table in a way to show employee ids in order starting by number 1.
Issue:
(
...
- 3
-2
votes
0
answers
29
views
How to pass dropdown value to php to mysql query for the next drop-down value? [closed]
How am I able to allow the second query in this snippet to pass the value from the first selection onchange to the next? whenever I put the variable in the query, it does not recognize the change, but ...
0
votes
1
answer
37
views
How to run mysql on mac os? [closed]
I installed mysql using brew:
brew install mysql
Installation went fine without any error.
When I do:
brew services
I see:
mysql none
Seems mysql is not started.
So how to get it running?
- 7,000
0
votes
0
answers
41
views
Could not convert PHP value of type DateTimeImmutable to type Doctrine\DBAL\Types\DateTimeType
I have a Symfony Command that reads rows from a spreadsheet and inserts them into a MySQL table. The command was working fine in Symfony 4.4. I started getting this error after I upgraded my version ...
0
votes
0
answers
20
views
Benchmarking software to create stored procedure on Azure Mysql flexible server
I was hoping someone can point me in the right direction. The data benchmarking software (Hammerdb) that I am using can't seem to create stored procedures on MS Azure under MySQL flexible server but ...
- 51
-1
votes
0
answers
15
views
MySQL - Validation of my.cnf does not work [closed]
MySQL my.cnf [ configuration ] validation as per documentation can be done using --validate-config command. But it does not work
Below is example which i tried
mysqld --defaults-file=/mnt/provision/...
-2
votes
0
answers
9
views
Mysql Case when no match show zeros [duplicate]
I have query which is working fine but not showing range of the count is zero
Here is mysql query
select
case
when hotel_offer_price between 0 and 5000 then '0-5000'
when hotel_offer_price ...
- 1,956
0
votes
0
answers
27
views
MySQL Date Column Index (NO Datetime)
I have a table with a date column (NO datetime, date only), which I always use to retrieve information by YEAR using BETWEEN. I was wondering if it's more efficient (and faster) to add a column to ...
- 79
-1
votes
0
answers
80
views
Where I've got problem in connection between program and data base?
In my program, I first load the form with mysql login. When I enter the incorrect login and password, it works fine, it doesn't allow me to go any further. When I enter the correct login and password.....
- 27