Category "mysql"

Show the name and the extension where the capital is an extension of name of the country from the table CITY

For example, In 'Monaco-Ville' the name is Monaco and the extension is -Ville. This problem is from SQLZOO. I am having trouble making my solution look like the

node.js async/await using with MySQL

I need to get all results synchronized and append to a string with async/await keywords like c#. I am new to node.js and I can not adapt this new syntax to m

How do I get DISTINCT columns and COUNT occurrences of sub DISTINCT columns [closed]

I am having some difficulty building a file download statistics database and displaying the information how I would like. Table: customer_stat

definer/invoker of view lack rights to use them

When I import my database all the tables are imported successfully, but when I'm trying to access the "views" then I got the message below on phpmyadmin's scree

Can't remotely connect to MySQL error (13) with PHP script, connecting through CLI works

I have looked at around 50 of the same question on here, but none of them seem to be fixing my problem. I can't remotely connect to my MySQL database through a

Failing to connect to an Amazon Aurora MySQL from SpringBoot

I want to connect my spring boot application to AWS Aurora MySQL RDS. The problem is while there are plenty of examples of AWS MySQL RDS. I cant find an example

Fulltext index match string with period (.) mysql

I have a few column fulltext indexed and i'm testing some string to search. My db contains cars components so my researches could be for example "Engine 1.6". T

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver even after using the mySql Maven Dependency on Intellij

I am using Intellij for a servlet project and using maven <dependency> <groupId>mysql</groupId> <artifactId>mysql-conn

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver even after using the mySql Maven Dependency on Intellij

I am using Intellij for a servlet project and using maven <dependency> <groupId>mysql</groupId> <artifactId>mysql-conn

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed

I have a spring boot project running on java8 after I installed mysql8 server and tried to connect I am getting the error com.mysql.jdbc.exceptions.jdbc4.MySQ

Not able to migrate changes to mysql database from Django

I have added foreign keys to some of the models in a Django application but the changes are not being reflected in the MySQL database even after migrating them.

Store / Website Column in Magento 2 Admin Grid - Custom Module

I have created a custom module in magento 2. I have two tables, first one is the main table and the other one is for the stores. The second table has the foreig

Codeigniter changes with `count_all_results`

So... it appears as if overnight, SOME-thing has changed with either the Codeigniter 4 framework or PHP in general, as my website is now down - and it seems to

MySQL normalization issue with performance

I have a table of shops and anoher table of shop configs (plan, discounts and Others configs), I need to add some Fields to store SMTP configs. Should I create

XAMPP MySQL won't start after rebooting

This happened without any forewarning, the last thing I registered in the database was a column with the autoincrement property. This is the error log: 2022-01-

SQL AVG() to 2 decimals

I'm trying to get this average to give me 2 decimals, so instead of 17.4534 I just get 17.45. I tried various combinations using CAST in each of the 2 places I

Go_gorm: AutoMigrate with foreignKey( Failed to open the referenced table )

I've just entered stuyding Go language and try to use gorm connecting w MySQL. When I try to create tables with foreign key, it gives me same error "Error 1824:

Sequelize - ORM - Associations not working

Using Sequelize with MySQL. I have three models. Consultant, FamilyMember and Appointments. Appointment refers to Consultant and FamilyMember. I have defined th

Lost Connection to MySQL server at '<server name>:<port>', system error: 10053 An established connection was aborted

Here is one part of my python code for inserting data retrieved from Sharepoint into MySQL Database, it runs every 10 mins. cnx = mysql.connector.connect(user=

Issue with connections pool on mysql

I'm having some issues with the api I'm developing: sometimes (yes, not always) when I make a request to the golang server from my angular app, it gaves me this