Unable to make api request to backend with Axios network error

Iwasmakingoneappwithfrontendreact.jsusesaxiostoapicallandforbackendiamusingexpressandnodewithdatabasemysqlwhil...

From [MySQLdiscussion group] 2024-03-29 15:42:21 0  1  446

MySQL trigger before validating data

I want to create a trigger that validates some data before inserting rows into a table. I have three tables: T...

From [MySQLdiscussion group] 2024-03-29 15:31:41 0  1  418

Convert row-based results to column-based results for different groups of users: How to achieve this "rotation"?

I'm running MySQL5.7. I'm looking for a SQL query that "rotates" some data from rows into columns. T...

From [MySQLdiscussion group] 2024-03-29 13:22:26 0  1  478

Prioritize display of full-text search results for "best matches" for exact matches, including join tables

What do I have to change in the query to get an exact match in the first place? For example, anyone enters hap...

From [MySQLdiscussion group] 2024-03-29 12:30:39 0  1  467

How to run a SQL file containing multiple databases (schema) from Mysql shell?

I use MysqlWorkbench to export multiple schemas into a 2GB sql file. Now, I want to import it. The problem is ...

From [MySQLdiscussion group] 2024-03-29 10:04:36 0  1  385

What is a good practice for large data volume update queries to avoid lock wait timeouts?

So basically, I currently have this query: UPDATEactASaINNERJOINblokASbONb.fav_pat=a.pat_idSETa.blok_id=b.id I...

From [MySQLdiscussion group] 2024-03-29 10:03:38 0  1  483

How to pass data to backend in React Native

I'm trying to develop a barcode scanner app for IOS, now I have managed to create a scanner that can read data...

From [MySQLdiscussion group] 2024-03-29 09:26:34 0  1  434

Improve performance of MYSQL queries with one-to-many relationships

I have a query in my database that takes 25 seconds to return results, which is too long. It seems like it sho...

From [MySQLdiscussion group] 2024-03-28 23:17:19 0  1  567

Connect to a local MySQL Workbench database using sqlplus

I'm trying to learn the PL/SQL language. On my Mac laptop (macOS Monterey, M1) I have the following setup: MyS...

From [MySQLdiscussion group] 2024-03-28 21:56:02 0  1  449

Configuring PhpMyAdmin to connect to a remote MariaDB server

I have a computer within the LAN network at my workplace that hosts a MariaDB database from Xampp and accesses...

From [MySQLdiscussion group] 2024-03-28 21:35:59 0  1  530

How can I get the complete list of all book categories in the table?

I have a "Books" table like this: I'm trying to make a SpringBoot application where all these books ...

From [MySQLdiscussion group] 2024-03-28 19:11:27 0  1  428

Why does my SequenceGenerator skip id values?

I set the artistId in the following code: @Id @SequenceGenerator(name="artist_sequence",sequenceName...

From [MySQLdiscussion group] 2024-03-28 18:29:23 0  2  437

I need to create an object using an object id from a MySQL database

I'm developing an inventory management system and I'm working on the final part of allowing users to update or...

From [MySQLdiscussion group] 2024-03-28 17:41:00 0  1  422

Connect Azure SQL Database to a .NET project

I have built a WebAPI using dotnet and this is my first time using Azure (or any other cloud platform) to host...

From [MySQLdiscussion group] 2024-03-28 16:54:34 0  1  395

Laravel query: orderBy not working with groupBy (using join table)

I'm developing basic messaging functionality in Laravel and want to display every user who sent a message to t...

From [MySQLdiscussion group] 2024-03-28 16:08:45 0  1  375