Top "Mysql" questions

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

How do I find which transaction is causing a "Waiting for table metadata lock" state?

I am trying to perform some DDL on a table and SHOW PROCESSLIST results in a " Waiting for table metadata …

Read More
mysql
MySQL - Selecting data from multiple tables all with same structure but different data

Ok, here is my dilemma I have a database set up with about 5 tables all with the exact same data …

Read More
sql mysql join mysql-error-1052
MySQL - Make an existing Field Unique

I have an already existing table with a field that should be unique but is not. I only know this …

Read More
mysql unique-constraint
MySQL: Insert datetime into other datetime field

I have a table with a DATETIME column. I would like to SELECT this datetime value and INSERT it into …

Read More
mysql sql datetime insert
Generate GUID in MySQL for existing Data?

I've just imported a bunch of data to a MySQL table and I have a column "GUID" that I want …

Read More
mysql random guid
How to use PDO to fetch results array in PHP?

I'm just editing my search script after reading up on SQL injection attacks. I'm trying to get the same functionality …

Read More
php mysql pdo
MySQL and PHP - insert NULL rather than empty string

I have a MySQL statement that inserts some variables into the database. I recently added 2 fields which are optional ($intLat, $…

Read More
php mysql null sql-insert
MySQL Trigger after update only if row has changed

Is there any possibility to use an "after update" trigger only in the case the data has been REALLY changed. …

Read More
mysql sql database triggers
How to get ID of the last updated row in MySQL?

How do I get the ID of the last updated row in MySQL using PHP?

Read More
php mysql
MySQL ON vs USING?

In a MySQL JOIN, what is the difference between ON and USING()? As far as I can tell, USING() is …

Read More
mysql join using