sql tag

625 questions

1 answers
134 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
46 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
159 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
98 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

2 answers
87 views
0

Postgresql cannot be started due to a permission error

This is my first post for a beginner.I installed postgresql to bring the personalized application to the production environment in heroku.I tried booting and received the following error:%psql --versi...

postgresql heroku

2 years ago

1 answers
124 views
0

Please tell me how to create a good batch to register with OracleDB based on the text file.

Load text file (id, value) → Perth → Insert to DB (Oracle) (In case of duplicate id, add value in Update) I would like to create a batch of processing, so please tell me how to process it efficiently....

java sql oracle

2 years ago

1 answers
135 views
0

How do I implement the Like feature in Servlet, Java, and PostgreSQL?

I want to create a program that shows the total number of likes per article by pressing the likes link, but running jsp doesn't work.test.jsp<%@pagelanguage=java contentType=text/html;charset=UTF-8...

java postgresql jsp servlet

2 years ago

1 answers
47 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

- 28 -

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