Top "Mysql" questions

PDO support for multiple queries (PDO_MYSQL, PDO_MYSQLND)

I do know that PDO does not support multiple queries getting executed in one statement. I've been Googleing and found …

php mysql pdo

PHP PDO with foreach and fetch

The following code: <?php try { $dbh = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password); echo "Connection is successful!&…

php mysql pdo foreach fetch

How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE

I have a CSV file which contains 10 columns. I want to select only some columns from that file and load …

mysql csv

How do you list all triggers in a MySQL database?

What is the command to list all triggers in a MySQL database?

mysql triggers

Insert the same fixed value into multiple rows

I've got a table with a column, lets call it table_column that is currently null for all rows of …

mysql sql sql-update sql-insert

When is a timestamp (auto) updated?

If I have a column in a table of type TIMESTAMP and has as default: CURRENT_TIMESTAMP does this column …

mysql sql timestamp

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0

I am getting the following error ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0 when …

mysql load-balancing f5

How to convert MySQL time to UNIX timestamp using PHP?

There are a lot of questions that ask about 'UNIX timestamp to MySQL time'. I needed the reversed way, yea... …

php mysql timestamp

MySQL integer field is returned as string in PHP

I have a table field in a MySQL database: userid INT(11) So I am calling it to my page with …

php mysql types int gettype

Illegal mix of collations error in MySql

Just got this answer from a previous question and it works a treat! SELECT username, (SUM(rating)/COUNT(*)) as TheAverage, …

mysql collation mysql-error-1267