MySQL

column sales_mode value : A|B -> 1|2

I got my solution on SO on how to copy data from a column to another column but I need to convert the "from column" unix to the datetime columnColumnA is of type int and ColumnB is of type TIMESTAMP:

We are facing a problem with RDS MySQL 80

Want to improve this question? Add details and clarify the problem by editing this post

Trigger Triggername afhentet Tabel scan After Insert

We're trying to run SQL files containing multiple insert statements as a single query, but it seems rollback fails when any of the statements contain an error

Want to improve this question? Update the question so it focuses on one problem only by editing this post

I've been trying to connect to an RDS instance using the sqlalchemy library using a tokenAccording to the docs it should be possible via the cparams['token'] variable, but doing so I get an error of an unexpected argument

I'm pushing a simple cloudbuild code for WordPress with --add-cloudsql-instances but unix sockets not showing up, just an empty folder

Using Docker Desktop, I've started a container of mysql/mysqlserver

I am trying to write a Visual Studion 2019 c++ application to connect to a MySql database on another machine on my networkI am following a D J Oaman example

I have table like this

Want to improve this question? Add details and clarify the problem by editing this post

I'm looking to report the best seller by total sales price using the table below: Sales table:

i would like to perform Mysql search & replace with random characters, taken from a listI cannot use regex, since my version is way prior to 8

In my program all work properly but problem is the total like get twice for one user i try to iterate properly but i am not succeed i can try to solve this problem from 2 days

I have 3 tables in a MYSQL DB

Want to improve this question? Update the question so it focuses on one problem only by editing this post

I'm working for a simple project and I need a way to update the QTablewidget below automatically if there's new data inserted or deleted

I need help with reading MySQL database and converting it's result to HL7 file with Mirth Connect

I have

In our system, a user can be of 2 types

I have a table product with a column name now I created a new field slug and I want to fill all the slugs with the name column value but replace all white spaces with dashes

I need to create a file using NamedTemporaryFile and download some data into it: