How to improve slow query with indexed tables MariaDB?

How do I find the 2nd most recent order of a customer

How to safely restore a Master-Master GTID enabled replication?

Cannot login into PHPMyAdmin

Register Command in Discord.js and MySQL

Procedure does not exist. Error 1305 MariaDB

AWS Python Lambda timeout when trying to access MySQL

MySQL error: Unknown column ... in 'where clause'

Cannot inner join


Grouping data from Database table by months in datatable

Stored Procedure slower than equivalent query

Can you add another row to a CASE statement that provides a TOTAL?

Are these two different ```RLIKE ^[^aeiou]``` and ```NOT RLIKE ^[aeiou]```?

How to create table with specific condition?

When save GORM entity in Micronaut Job an text field throws DataIntegrityViolationException... Data truncation: Data too long for column

package can't find headers

django.db.utils.OperationalError: (2059, <NULL>)

Best approach to manage side menu in php

Get the id of an element of a GROUP_CONCAT?

How to get id in a variable

Field 'camp_id' doesn't have a default value in a not null, auto_increment primary key field

Need Help Python 3.x Code Simplification (help)

Are AWS RDS manual snapshots stored incrementally or not?

Is there a subquery that can use a max date from a different column in the same table to calculate datediff?

MySQL db - Can i use a wildcard inside a field?

Exporting Objects in NodeJS for API

SQL insert into table. have value = (value before inserted) + a number(ex 1000)

Create another table TRANS_TEMP from TRANSACTION table by change the column name acc_no to account_no

Socket error when connecting to In App MySQL in Azure App Service

Did I convert PDO to MySQLi correctly?

Get count of particular category and further bifurcated sub category using SQL query

how to give same number to the same seller in php, taking mysql_insert_id();

Shortening a php prepare statement?

How do I join 3 tables in Mysql keeping the null values?

MySQL community server unable to start

MySQL 5.6 - select results where the most recent of multiple datetime columns is 1 month ago at least

Change DateTime string into Date

Suggestion for fixing Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 851095168 bytes)

Why can't i see my database by portscanning

How can I select a list of distinct values from a field of comma separated values?

mariadb select * returns empty set

How to get SQL errors when using multiple statements

php create table without utf8 format

How to check if a word is in a set of allowed words during INSERT INTO table VALUES (....)?

How to query specific column in a UWP application?

how to register and login user with OTP in express js API with mysql as db

Upload img to SQL database and display it on webpage

how to extract JSON array from the database in codeigniter

MaxScale after Failover the master-slave-configuration on previous slave server is resetted

MySQL- fetch the records count per minute

How to connect the nested VM to directly from the local host machine using ip?

Connecting MySQL Server 8.0 using C#

select option problem on saving on database codeigniter

I need inner join for my project FLASK PYTHON

I want to export mysql blobs into files in a directory, is there a better way other than select into dumpfile?

What is the proper way of storing calculated amounts in database?

mysql - store typically/mostly NULL columns in one table or create 1:1 relationship?

Setting up proper binding on IIS for Android Application Backend

Having trouble getting this database query to work

Stored procedure for inserting or updating records against duplicate rows

How to generate periods in php and register them in MYSQL with Symfony?

return multiple data in codeigniter

Optimize mysql query runtime

Maria DB to Mysql replication

Laravel: Route [PackageController.fetch] not defined

I get http 502 error on node.js express when i try to get data from MySQL

How to get the results of a query to the values passed in in an array (mySQL and PHP)

Ajax call outputs the same message

Delete Operation is not working using PHP POP Delete modal?

How to get top 3 users according to rating

display records not ID using PHP and Mysql

CakePHP 2.x Field is Empty or null

How can I Autoload Spring Security when modified from screen

How do I update users specified in file in mysql?

com.mysql.jdbc.CommunicationsException: Communications link failure (glassfish+mysql))

MySQL reset autoincrement id index based on column date

Mysql - Create view with case and count

select * from (desc ordered table) turns out ascending order

MySQL query with joins works in Phpmyadmin but not in php

Update model From Database | Visual Studio 2019

I can't create an SQL table due to a syntax error

Insert query is not adding values to database

MYSQL Query, IN with multiple string with comma separated Not working

how to count active employees for each month in Mysql based on joining date and resigning date

Removing duplicates on mysql table [the table is > 2Gb]

MySql - Select records like a particular number present in a string and separated by commas

Java - database, beans, arraylist, jtable. best practice?

Trying to insert user input data into mysql database using java netbeans but not inserting

Why is jpa not adding records to the database?

How to Optimize Mysql Server performance? (Increase execution speed of Queries )

Spring Boot MySQL Docker Caused by: Connection refused (Connection refused)

Getting error Unknown column 'operatorID' in 'field list'

What does this error mean in php and mysql?

I am migrating from xampp to IIS and SQL server

How to save multiple inputs in laravel in mysql database?

SQL Joining tables using other tables foreign keys

MySQL: insert values in new table from an old one using another mapping table

SQL selecting lines with no empty colums

Same ID Different Value become one row