mysql tag

409 questions

2 answers
54 views
0

extracting and sorting mysql maximums

I would like to ask you an additional question regarding the contents of your reply.mysql Work Data ID Extraction Across DatesThe ID is now displayed every 15 minutes as shown below.この I would like to...

mysql sql

2 years ago

1 answers
82 views
0

I would like to improve the speed of SQL statements (with code) that INNER JOIN 12 tables.I have changed it to LEFT OUTER JOIN, but it does not lead to improvement.

SQL statements include:In this SQL, there are only two tables that are INNER JOIN and WHERE statements.This will take about 10 seconds to complete the aggregation.However, due to this requirement, the...

mysql sql

2 years ago

1 answers
77 views
0

ID extraction across mysql work data dates

The following data is available:USER_NAME,ID,START_TIME,END_TIMEAAAA, 1, 2017/8/99:00, 2017/8/918:00AAAA, 5, 2017/8/9 12:00, 2017/8/9 13:00BBBB, 2, 2017/8/9 22:00, 2017/8/1000:00BBBB, 2, 2017/8/1000:0...

mysql

2 years ago

1 answers
122 views
0

Mysql2::Error (Access denied for user'b00120fa21c0f6'@'ip-10-139-25-93.ec2.internal' (using password: YES)) :

EnvironmentherokuClearDB MySQL I'm running the Rails app with Heroku, but while I was working on it, We're sorry, but something wrong. and the app stopped working.When I looked at the Heroku log, I fo...

ruby-on-rails mysql heroku

2 years ago

2 answers
90 views
0

Questions for Error 1040 in MySQL

I would like to ask you a question to help me solve mySQL problem.I will write down the current symptoms first, and then write down how I handled it in my own way.Finally, I would appreciate it if you...

mysql

2 years ago

1 answers
80 views
0

Confirmation of registered email address when completing registration form

When I create a registration form in HTML, I would like to display That email address is already registered in the MySQL database on the form, but what should I do?

html mysql

2 years ago

1 answers
138 views
0

Understanding PHP MySQL Prepared Statements Security

I made the following prepaid statement.id:int type, name:varcher type, area:int type.Assume area is a number from 1 to 10 that represents the position where you live.For example, 1=Kanto, 2=Kansai, 3=...

php mysql security

2 years ago

1 answers
99 views
0

Can you set the id that you have registered in the two tables to each other's columns in one SQL session?

There are two tables.One is an item table and the other is a parts table.There is a type of entry on the item screen where item data is registered. Only when type is abcde is registered in the part ta...

mysql sql

2 years ago

2 answers
140 views
0

About MySQL AUTO INCREMENT

I set auto increment for mysql from phpmyadmin.id is Data Type: INT, Length/Value: 11, Adjust privileges: Checked, A_I: Checkedappears.I think this error means that the id is set to 11 digits, but it'...

mysql phpmyadmin

2 years ago

1 answers
131 views
0

Unable to register with mysql if selinux is enforcing (symfony3)

Thank you for your help.I am practicing the code in a Symfony introduction, but if I set selinux to enforcing, I will not be able to register a record in mysql, so could you help me?The error message ...

mysql symfony2 mariadb doctrine2 selinux

2 years ago

- 5 -

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