mysql tag

409 questions

1 answers
48 views
0

Is it possible that multiple ORDER BYs will affect the contents of the SELECT result?

environment·MySQL 5.7Question·ORDER BY is the order of arrangement, so I thought it would not affect the contents of the SELECT result itself even if I specify more than one order, but is it not?·Not ...

mysql

2 years ago

3 answers
41 views
0

I want the latest list for each specified column (SQL, SELECT statement)

Please tell me the SQL statement.How do I write a SELECT statement to get the latest bill list for each user_id?mysql>descbills;+---------------------+--------------+------+-----+---------+--------...

mysql sql

2 years ago

1 answers
133 views
0

I can import it with phpMyAdmin, but it's not working.

As you can see, import the SQL source, 38,767 bytes (41 KB on disk) and Import to screen completed successfully.44 queries were performed.(create.sql) and There are, but there are no signs of import.I...

mysql phpmyadmin

2 years ago

1 answers
45 views
0

Group by gives error as if the column does not exist even though there is a column

When I ran SQL below, I got the following message:The foods table has an id (primary key).Displayed messages:Expression#13 of SELECT list is not in GROUP BY cause and containers nonaggregated column'k...

mysql

2 years ago

1 answers
158 views
0

I want to install homebrew and mysql.

When you type homebrew install url into the terminal, the following display appears: curl:(60) SSL certificate problem:self-signed certificate insert chainMore details here: https://curl.se/docs/sslce...

mysql homebrew

2 years ago

1 answers
97 views
0

A value different from the displayed value is updated to MySQL.

Labels and select boxes are set up in the form as follows, and the contents of the labels are changed in conjunction with the ones selected in the select box.There is a table in MySQL that looks like ...

javascript html mysql node.js

2 years ago

1 answers
54 views
0

If you pass patchEntity(), it will be converted to NULL.

We are creating a user management system with PHP (CakePHP).In the input form to add users on the management screen, the select box is used in the entry of permissions.When submitting the form, the fo...

php mysql cakephp

2 years ago

2 answers
136 views
0

MySQL root password is questioned -- skip-grant-tables is not available.

MySQL root password is questioned. You cannot use --skip-grant-tables.$mysql-u rootERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO)Unable to log in next door.What s...

mysql amazon-linux

2 years ago

1 answers
46 views
0

Error connecting to MySQL - ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

After MySQL was introduced into AWS Lightsail, I tried to log in to MySQL first, but I received the following error:Enter current password for root (enter for none): ERROR 2002(HY000): Can't connect t...

mysql

2 years ago

2 answers
59 views
0

SQLSTATE [HY000] [2002] No such file or directory

I am studying PHP on a local server (PHP 7.0.14) in MacOS 10.12.2.<?phpdefine('DB_DATABASE', 'test_db'); // database specification define('DB_USERNAME', 'dbuser'); // database userdefine('DB_PASSWO...

php mysql macos

2 years ago

- 17 -

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