mysql tag

409 questions

1 answers
39 views
0

SQL query to sort data from two tables (MySQL)

Table A ID_A,Name_ATable B ID_B,Name_B,Gender,ID_AI'd like to sort out all the data (ID_B, Name_B, Gender, ID_A, Name_A) from these two data tables, but the sorting condition is ①Name_BDESC,②If there ...

mysql

2 years ago

1 answers
104 views
0

MySQL no longer starts.Please let me know the solution!

I'm a beginner in programming.I tried it through trial and error, but I couldn't solve it, so I have a question.Mysql installed on xampp has stopped starting, and the database is not available and the...

mysql xampp

2 years ago

1 answers
39 views
0

InnoDB: The OS said file flush did not succeed

ERROR InnoDB: The OS said file flush did not succeed What kind of error is ?

mysql

2 years ago

3 answers
152 views
0

Which GUI application is best suited for Google Cloud SQL?

Google Cloud Platform > Cloud SQL > MySQL 2nd Generation Instancehas been created.The DB in this instance has my Mac and Microsoft Access (no MacOS version) or LibreOffice Base (There is a Mac v...

mysql google-apps-script google-cloud google-app-engine libreoffice

2 years ago

1 answers
43 views
0

I'd like to check the number of people born in 1991 and 1981.

Please find out how many celebrities were born in 1991 and 1981.However, do not use the date function, but use the UNION clause.SELECT COUNT(birth),SUBSTRING (birth, 1, 4) AS 'Year of Birth'from `cele...

mysql sql

2 years ago

1 answers
119 views
0

Enter HTML in MySQL in Django (Save?)

I'm sorry to bother you at such a busy time.This is my first time to ask you a question.I was creating an application on Django this time, but When creating one page, save each HTML tag in MySQL and W...

html mysql python3 django

2 years ago

1 answers
45 views
0

Mysql.sock disappeared.

When I updated my Mac to High Sierra, the mysql.sock under /tmp disappeared.I thought it would be fixed after uninstalling and reinstalling, but the sock file was not generated.That's why I can't use ...

mysql macos

2 years ago

1 answers
143 views
0

Want to know how to implement best practices for accessing split tables in Spring Data JPA

For example, a user table with user informationuser_0, user_1, user_2, user_3 (when userId is divided by 4, the remainder follows the table name) I would like to know how to implement without having t...

mysql spring spring-boot database jpa

2 years ago

1 answers
95 views
0

Why do rails use datetime instead of timestamp for created_at?

Rails ActiveRecord creates a datetime type on the DB for columns created_at and updated_at that are introduced in migration with t.timestamps at least in MySQL.The datetime type is close to storing th...

ruby-on-rails mysql rails-activerecord

2 years ago

1 answers
47 views
0

MySQL Workbench Cannot Connect to DB

I recently started using MySQL Workbench.I've been using it for a long time, but when I tried to start it today (2022/6/22), I got the following error.I tried the following.Add C: WindowsWindows SySys...

mysql mysql-workbench

2 years ago

- 8 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656