sql tag

625 questions


1 answers
274 views
0
The Mysql container cannot be started using the web app created by Docker+Lavel, Nginx, Mysql, phpmyadmin.

environmentWSL2 (Ubuntu 22.04)DockerNginxMysqlPhpmyadminWhat do you want to doSince Mysql cannot be started, I want to find out the cause and start it.StatusMigration failed → Mysql is not starting → ...

1 years ago

1 answers
302 views
0
I don't know if Cloudinary or database settings are wrong.

I asked the following questions and was able to set them up.When I tried to post an image in the production environment, an error occurred.The Cloudinary configuration I was referring to should have b...


1 answers
280 views
0
MySql update does not use index

The MySql command below does not use the index in update.In where, we make decisions in the order of column FlagSer and PriceUpdateTimeSer.The index fflag_price_idx は is the composite index of the col...

1 years ago

1 answers
403 views
0
In spring boot (2.7.8-SNAPSHOT) environment, I changed my DB from H2DB to My SQL (mysql-connector-j-8.0.32), but I got an error.

In the H2 environment, type conversion was possible, but when I switched to My SQL, I got an error.I didn't know exactly where and how to fix it.I would appreciate it if you could help me.·The followi...

1 years ago

2 answers
319 views
0
Understanding Extracting Records with Same Value and Non-Continuous Id in a Column

Suppose you have the following users table:I would like to extract records with the same name and no consecutive id from this table.The expected results are as follows:I would appreciate it if you cou...

sql
1 years ago

1 answers
514 views
0
rails db:create error: Could not find mysql2-0.5.4 in any of the sources

When I tried to create a database with rails db:create, I received the following error:Could not find mysql2-0.5.4 in any of the sourcesRun `bundle install` to install missing gems.Are you going to se...

1 years ago

1 answers
380 views
0
My Japanese is garbled when I connect to mysql from python

When I tried to create python and mysql containers using docker and connect python to mysql and display the table in fetchall, the Japanese was garbled.When you enter the mysql container and view it d...

1 years ago

1 answers
372 views
0
Understanding the MySQL Table Configuration of Parent-Child Hierarchy Data

What you want to do in the endI want to display the parent-child hierarchy category in PHPQAfter searching, I found [PHP][Recursive function version] that I tried to register and display categories of...

1 years ago

1 answers
393 views
0
sql query : a category purchased immediately before and immediately after a specific category

Hello, I'm a marketer who is using SQL little by little. I'm asking you this question because I had a hard time filling out queries during work First, the table is as below.TS category member number 2...

sql
1 years ago

1 answers
441 views
0
sql query questions

Hello, I'm a marketer who is using SQL little by little. I'm asking you this question because I had a hard time filling out queries during workFirst of all, the table is shown below.TS Category Member...

sql
1 years ago
- 1 - »

© 2024 OneMinuteCode. All rights reserved.