Top "Mysql" questions

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'

This is the Warning im getting in console, Im confused with this warning: Loading class `com.mysql.jdbc.Driver'. This …

mysql jdbc

How do you join on the same table, twice, in mysql?

I have 2 tables. One (domains) has domain ids, and domain names (dom_id, dom_url). the other contains actual data, 2 …

mysql

adding 30 minutes to datetime php/mysql

I have a datetime field (endTime) in mysql. I use gmdate() to populate this endTime field. The value stored is …

php mysql datetime strtotime

MySQL SELECT query string matching

Normally, when querying a database with SELECT, its common to want to find the records that match a given search …

sql mysql string match

Alter SQL table - allow NULL column value

Initially, the table "MyTable" has been defined in the following way: CREATE TABLE IF NOT EXISTS `MyTable` ( `Col1` smallint(6) NOT …

mysql sql alter

Re-assign host access permission to MySQL user

I have several thousand MySQL users all set to allow access from a specific host. The problem is that now …

mysql permissions

MySQL Daemon Failed to Start - centos 6

EDIT: Look at the checkmarked answer comments to get your issue solved. Whenever I try to start the SQLD service …

php mysql phpmyadmin centos6

Mysql select distinct

I am trying to select of the duplicate rows in mysql table it's working fine for me but the problem …

mysql select greatest-n-per-group

Can MySQL convert a stored UTC time to local timezone?

Can MySQL convert a stored UTC time to local time-zoned time directly in a normal select statement? Let's say you …

mysql sql timezone convert-tz

How do I delete all the duplicate records in a MySQL table without temp tables

I've seen a number of variations on this but nothing quite matches what I'm trying to accomplish. I have a …

mysql sql duplicates sql-delete unique-index