MySQL

Since both tables are in the same format, is it possible to take #1's value for each worksite and date and #2's value for each worksite and date, and join them so they appear in the same table on just another column?

Design for a MySQL database to store performance results of different web applications

I have a audit table like this:

Whenever I send my POST form back to PHP, and try to save to Database, it doesn't even get the value, and it saves default value: 0000-00-00 00:00:00 on my database

My SSRS Server is using an ODBC connection to pull data from a MySQL serverI have a query that's making use of the FIND_IN_SET method

I am adding zipkin tracing to my service and trying to use an external MySQL to store the traces instead of local mysql, Is this possible

I have this heavy database: https://githubcom/datacharmer/test_db

Here is one part of my python code for inserting data retrieved from Sharepoint into MySQL Database, it runs every 10 mins

I have to combine these multiple UNION queries

Mysql database: store java Date into database column of datetime type, eg

I have two SQL query's, when I write the second query it drops a SQL error, like this "Foreign key constraint is incorrectly formed"And I don't know, the first table have ID with primary key

I have 3 related tables and I would like to show with a query sql a table with the "titulo" of the table "recetas" with the "categoria" of the table "categorias" that is selected, a recipe can have more than one category for that I have created the table "recetas-categorias", I have tried with subqueries but I do not get it, I am a beginner in sql

I am new to web2py and I was wondering if it was possible to convert this mysql statement to web2py DALthe dates are formatted as strings, It shows last day records of every month:

I am trying to connect to my local mysql server from my console, but whenever I try to open a connection it gives me a file not found exceptionThe connection string should be correct

Database Structure

I am trying to connect Matlab 2017b to MySQLThere is a thread here describing what to do

I have 3 tables:

Trying to query a mysql table that has over 18 million rowsAll I need is a simple:

I'm using mysql connector 80 and the below code throws a Closed cursor error when trying to fetch the row

My table

This question already has an answer here:

Here is the structure of my tables:

I used Open Server 52