Top "Mysql" questions

MySQL join with where clause

I have two tables I want to join. I want all of the categories in the categories table and also …

mysql join where-clause

Difference between Key, Primary Key, Unique Key and Index in MySQL

When should I use KEY, PRIMARY KEY, UNIQUE KEY and INDEX?

mysql indexing primary-key unique-key sqlperformance

Dropping Unique constraint from MySQL table

How can I drop the "Unique Key Constraint" on a column of a MySQL table using phpMyAdmin?

mysql

How to select rows that have current day's timestamp?

I am trying to select only today's records from a database table. Currently I use SELECT * FROM `table` WHERE (`timestamp` &…

mysql sql timestamp

Commands out of sync; you can't run this command now

I am trying to execute my PHP code, which calls two MySQL queries via mysqli, and get the error "Commands …

php sql mysql mysqli

How to Get True Size of MySQL Database?

I would like to know how much space does my MySQL database use, in order to select a web host. …

mysql database size byte storage

Detecting locked tables (locked by LOCK TABLE)

Is there a way to detect locked tables in MySQL? I mean tables locked by the LOCK TABLE table WRITE/…

mysql locking

mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists

While starting mysql server 5.7.17 using mysqld_safe, following error occcours. 2017-02-10T17:05:44.870970Z mysqld_safe Logging to '/var/…

mysql sockets

How to resolve Unable to load authentication plugin 'caching_sha2_password' issue

In eclipse when i started my application i got this - Could not discover the dialect to use. java.sql.…

java mysql eclipse maven spring-boot

Object of class DateTime could not be converted to string

I have a table with string values in the format of Friday 20th April 2012 in a field called Film_Release …

php mysql datetime insert