mysql tag

409 questions


1 answers
40 views
0
I want to do attendance aggregation in MySQL

What do you want to doI want to get attendance, absences, lateness, and lateness (one absent out of three) from MySQL.I'd like to count the number of absences for being late (three times and one time)...

2 years ago

1 answers
39 views
0
What to install with MySQL MAMP and what to boot from the terminal?

What is the difference between installing with MySQL MAMP and booting at the terminal?

2 years ago

3 answers
79 views
0
I want to replace Distinct with Exist in SQL

To speed up the query of the search results, I wanted to replace Distinct with Exist, but it was too complicated for me to replace it well.There are two, but they are as follows.Also, when I measured ...

2 years ago

1 answers
45 views
0
Understanding Partial Matching for Ambiguous Searches

% value %This is a conditional expression using LIKE that allows to retrieve partially matched records.I am currently writing the basic processing of the search function that retrieves data from MySQL...

2 years ago

1 answers
118 views
0
Database Errors in Chef Solo

[Question] $bundle exec knife solo cookie node nameThe following error occurs in Error executing action create on resource 'mysql_database [aws]'*Currently, recipes that do not use database are workin...

2 years ago

1 answers
54 views
0
CakePHP does not display modified correctly.

I recently started studying CakePHP.I'm suffering from an error right away...I think it's a rudimentary problem, so If anyone knows, please reply.<div class=topics index> <h2><?phpecho_...

2 years ago

1 answers
37 views
0
On duplicate key update lock conditions

Access MySQL on AWS RDSWhen adding API (Apache+Fuel PHP) and performing load testWhile Apache stopped accepting connections, Waiting for RDS logs on RDS performance insights synch/cond/mysys/my_thread...

2 years ago

1 answers
38 views
0
I want to get the number of HITs when I search the aggregate column in MySQL

usersid|name1 | tanaka2 | suzuki3 | satoarticlesid | writer_1 | writer_2 | writer_31 | tanaka | tanaka | tanaka2 | suzuki | sato | tanaka3 | suzuki | suzuki | satoI use MySQL.There is a table similar ...

2 years ago

1 answers
41 views
0
About MySQL INSERT INTO

I'm studying php, MySQL based on a textbook.If the form information is entered correctly, it will display 1 was inserted and The information should be stored in the database, but it will not be proces...

2 years ago

1 answers
66 views
0
Show variables like '%char%'; results differ between MySQL Workbench and the server

I installed MySQL 5.7.23 and set the character code in /etc/my.cnf with the following settings: [mysqld]character-set-server=utf8mb4[client]default-character-set=utf8mb4The environment is Virtualbox (...

2 years ago
« - 23 - »

© 2024 OneMinuteCode. All rights reserved.