Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

select rows in sql with latest date for each ID repeated multiple times

I have a table where each ID is repeated 3 times. there is a date in front of each id in …

mysql sql hive
Which rows are returned when using LIMIT with OFFSET in MySQL?

In the query below: SELECT column FROM table LIMIT 18 OFFSET 8 how many results will we get as output and from …

mysql
generate days from date range

I would like to run a query like select ... as days where `date` is between '2010-01-20' and …

sql mysql datetime between
centos: Another MySQL daemon already running with the same unix socket

I have a strange error when starting mysqld service: Another MySQL daemon already running with the same unix socket. I've …

mysql sockets unix centos6
mysql command for showing current configuration variables

Can not find a command that displays the current configuration of mysql from within the database. I know I could …

mysql mysql-management
MySQL - ignore insert error: duplicate entry

I am working in PHP. Please what's the proper way of inserting new records into the DB, which has unique …

php mysql insert
MySql with JAVA error. The last packet sent successfully to the server was 0 milliseconds ago

I have read about this exception a lot, but I can't solve my. Mysql server is working. I can connect …

java mysql mysql-connector
Enable binary mode while restoring a Database from an SQL dump

I am extremely new to MySQL and am running it on Windows. I am trying to restore a Database from …

mysql database mysqldump database-restore
ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it

An error suddenly occurred while I was debugging my code. It has this series of errors regarding the connection to …

php mysql pdo wamp
In PHP with PDO, how to check the final SQL parametrized query?

In PHP, when accessing MySQL database with PDO with parametrized query, how can you check the final query (after having …

php mysql pdo sql-parametrized-query