mysql tag

409 questions


1 answers
294 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
297 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
429 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

1 answers
571 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
407 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
411 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
422 views
0
I want to import files under the directory in bulk in mysql.

I can't think of a way to import all the files under the db directory into mysql at once, so please let me know.For my part, I was wondering if I could get the file name list with ls-1db and do well, ...

1 years ago

1 answers
374 views
0
I want Nodejs to repeat MySQL query statements synchronously

I am currently studying Javascript using Nodejs.I would like to store the values obtained by executing the query statement in an array, but it will become asynchronous, so it will not store data after...

1 years ago

1 answers
411 views
0
Using CHAR and VARCHAR in MySQL

How do I use CHAR and VARCHAR differently in MySQL 5.7?I understood the following, but is it okay to put fixed length strings in VARCHAR and all VARCHAR?CHAR is a fixed length, so it stores a fixed le...

1 years ago

1 answers
464 views
0
MySQL crashed

I am using MySQL installed from Homebrew on my Mac.When I tried to launch MySQL, ERROR!The server quit without updating PID file(/usr/local/var/mysql/****.pid).failed to boot with the boot.For /usr/lo...

2 years ago
- 1 - »

© 2024 OneMinuteCode. All rights reserved.