Inserting two tables with many-to-many relationship in a single for loop using pandas on MariaDB

I'm trying to bulk insert data into two tables that have a many-to-many relationship, if I insert in only one ...

From [MySQLdiscussion group] 2023-08-15 12:18:58 0  1  457

Way to remove double quotes and convert data type to string in Google BigQuery

The values ​​are of JSON object type and I want to change them to strings and remove the double quote symbols....

From [MySQLdiscussion group] 2023-08-15 11:25:31 0  1  504

Error while connecting to MySQL database on Hasura Cloud

I'm using Hasura cloud environment. For the MySQL database, I am using MySQLWorkbench and created a database. ...

From [MySQLdiscussion group] 2023-08-15 10:54:43 0  1  483

Encountered the trouble of configuring MYSQL and node.js

constSequelize=require("sequelize");require("dotenv").config();constsequelize=newSequelize...

From [MySQLdiscussion group] 2023-08-15 10:55:24 0  1  417

How to insert data from multiple nested lists into multiple rows in the database using a stored procedure

I have a MySql database table that looks like this: id|page_name|language|item_id|item_text This table stores ...

From [MySQLdiscussion group] 2023-08-14 19:11:53 0  1  604

Unable to drop index required by MySQL foreign key constraint

I need to modify my existing database to add a column. Therefore, I also want to update the UNIQUE field to in...

From [MySQLdiscussion group] 2023-08-14 13:34:46 0  2  579

Hive query: Convert date timestamp to date format

I want to convert a date timestamp column containing something like '4/12/202315:37' to a date format like: 20...

From [MySQLdiscussion group] 2023-08-14 13:02:24 0  1  625

MySQL missing email address query

I have a table (datas): lineaccountnameemail11000ReyesVonRuedenSr.sharon51@yahooo.com11000Dr.ElenaBartellV1100...

From [MySQLdiscussion group] 2023-08-14 12:29:58 0  1  435

SQL left join using where clause to filter empty fields

I have two tables, one is the user table (Userstable) and the other is the token table (Tokentable). I want to...

From [MySQLdiscussion group] 2023-08-13 19:06:52 0  1  556

Database row matching problem challenges

I want to get the row count to check if the same email already exists in the database. I tried several mechani...

From [MySQLdiscussion group] 2023-08-13 16:46:45 0  1  513

MySQL query to convert rows of multiple tables into columns

I need to ask you about MySQL select query from 3 tables. I have 3 similar tables: table_1menu_id|menu_name1|m...

From [MySQLdiscussion group] 2023-08-13 16:02:22 0  1  564

Average tenure: Statistics for a manager's tenure

Recruiting teams want to know how long managers have been in their positions. Retrieve the average tenure of m...

From [MySQLdiscussion group] 2023-08-13 11:54:57 0  1  568

PDOException SQLSTATE The file or directory does not exist

I believe I have successfully deployed my (very basic) website to fortrabbit, but as soon as I connect to SSH ...

From [MySQLdiscussion group] 2023-08-10 17:44:11 0  2  643

Remove duplicate rows and keep only the latest worklog entries

I created this query and it works. The problem is that it shows rows for each job log. I just need the latest ...

From [MySQLdiscussion group] 2023-08-10 17:25:56 0  1  676

In-depth understanding of the creation process of MySQL index - timestamp field

I would like to understand how an index is created in MySQL - i.e. if it is a TimeStamp field - does it create...

From [MySQLdiscussion group] 2023-08-10 16:05:59 0  1  633