How to run SQL queries in Hackerrank afterwards? What does it mean?

Error 1044 (4200) occurred on line 5: Access to database "company" for user "@" localhost ...

From [MySQLdiscussion group] 2024-03-19 19:50:44 0  1  370

MySQL fiscal year

I need to select the data for the financial year I am using the following query but it is not working SELECT*F...

From [MySQLdiscussion group] 2024-03-19 18:14:26 0  1  407

MySQL: Retrieve sum of grouped rows from aggregate results

Suppose I have statistics on the number of visits by users in each country: The query is as follows: SELECTcou...

From [MySQLdiscussion group] 2024-02-26 23:21:28 0  1  876

How to specify date function in MySQLWorkBench to avoid error prompts?

I tried creating a table and this is how I set it up: CREATETABLEemp_tab(empnoNUMeric(10),nameVARCHAR(50)NOTNU...

From [MySQLdiscussion group] 2024-02-26 21:56:48 0  1  548

Formatting Date Values for MySql

My plan is to insert a date (day_of_test) into a MySql database where the data format is referenced as date. I...

From [MySQLdiscussion group] 2024-02-26 20:50:13 0  1  343

Docker cannot connect applications together in the same network

I have a dockercompose file that looks like this: version:"3.9"services:mysqldb:image:mysql:5.7conta...

From [MySQLdiscussion group] 2024-02-26 20:53:13 0  1  365

PHP inserts strange symbols instead of polish letters

When I use this code to insert data from mysql database it does not populate with polish letters but shows ran...

From [MySQLdiscussion group] 2024-02-26 19:48:29 0  1  426

Convert a mysql query to its equivalent Knex query

I'm trying to convert my mysql query to its equivalent Knex query This is the query create table test(idINTUNS...

From [MySQLdiscussion group] 2024-02-26 19:06:08 0  1  317

Caching reporting data in the same transaction database vs using a data warehouse

We have a SaaS solution where each tenant has its own MySQL database. Now I'm designing a dashboard for this S...

From [MySQLdiscussion group] 2024-02-26 19:20:23 0  1  403

MySQL: Get the dataset for a given date - the last existing dataset before this if one does not exist

My table structure is as follows: CREATETABLE`market_trend_record`(`date`dateNOTNULL,`symbol`CHAR(40),`identif...

From [MySQLdiscussion group] 2024-02-26 18:44:20 0  1  436

Access permissions queried in model.php file in Laravel

I have a relationship and a function in my User.php; classUserextendsModel{publicfunctionchildren(){return$thi...

From [MySQLdiscussion group] 2024-02-26 16:58:05 0  1  495

Select some coordinates from a large set of coordinates that appear to be evenly distributed over the area

I have a MySQL table that contains region and latitude/longitude location columns. Each area has many location...

From [MySQLdiscussion group] 2024-02-26 16:23:02 0  1  384

How to search for a word in a column of 2 different repositories using one query (MySQL with TYPEORM and Nestjs)

I'm using MySQL and Typeorm in nestjs latest version and I have the following entities: shop.entity.ts: @Entit...

From [MySQLdiscussion group] 2024-02-26 15:52:00 0  1  322

pymysql insert only if not present

This is my first time using sql and trying to insert data only if the entry is not in the database. My sql loo...

From [MySQLdiscussion group] 2024-02-26 15:39:51 0  1  336

How to GROUP BY multiple columns with multiple HAVING values ​​in MySQL?

I'm trying to create a mysql query to view the table where search queries are stored. This query attempts to g...

From [MySQLdiscussion group] 2024-02-26 12:04:45 0  1  458