Top "Mysql" questions

PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client

I'm running MySQL version 8 on PHP 7.0. I'm getting the following error when I try to connect to my database from …

php mysql mysql-8.0

How to get the number of days of difference between two dates on mysql?

I need to get the number of days contained within a couple of dates on MySQL. For example: Check in …

mysql date

Using DISTINCT and COUNT together in a MySQL Query

Is something like this possible: SELECT DISTINCT COUNT(productId) WHERE keyword='$keyword' What I want is to get the …

mysql sql

add column to mysql table if it does not exist

My research and experiments haven't yielded an answer yet, so I am hoping for some help. I am modifying the …

mysql

Change limit for "Mysql Row size too large"

How can I change the limit Row size too large (> 8126). Changing some columns to TEXT or BLOB or using …

mysql

How to generate a create table script for an existing table in phpmyadmin?

How can I generate a create table script for an existing table in phpmyadmin?

mysql phpmyadmin

How to delete from multiple tables in MySQL?

I am trying to delete from a few tables at once. I've done a bit of research, and came up …

mysql sql mysql-error-1064 sql-delete

Mysql: Select rows from a table that are not in another

How to select all rows in one table that do not appear on another? Table1: +-----------+----------+------------+ | FirstName | LastName | …

mysql sorting unique database-table

String concatenation in MySQL

I am using MySQL and MySQL Workbench 5.2 CE. When I try to concatenate 2 columns, last_name and first_name, it …

mysql mysql-workbench concat

Error in MySQL when setting default value for DATE or DATETIME

I'm running MySql Server 5.7.11 and this sentence: updated datetime NOT NULL DEFAULT '0000-00-00 00:00:00' is not working. Giving …

mysql sql date datetime console