Top "Mysql" questions

In MySQL what does "Overhead" mean, what is bad about it, and how to fix it?

simple question, but its been nagging me for a while now.... what is "overhead" in MySQL, and should i be …

mysql overhead

Get mySQL MONTH() to use leading zeros?

How do I specify to mySQL's MONTH() function to return '08' instead of 8 in this query? I'd like the …

mysql sql date

Populate PHP Array from While Loop

If I am fetching data from a MySQL database and using a while loop to iterate through the data how …

php mysql arrays loops while-loop

Update MySQL with if condition

It seems I have big problems with conditional queries. I have to do a conditional update. I write here what …

mysql sql sql-update

MySQL, better to insert NULL or empty string?

I have a form on a website which has a lot of different fields. Some of the fields are optional …

mysql sql sql-null

How does "do something OR DIE()" work in PHP?

I'm writing a php app to access a MySQL database, and on a tutorial, it says something of the form …

php mysql exception-handling conditional

Exporting a MySQL table into a CSV file

I have a MySQL table which has to be taken out as a CSV file. The query I used is …

mysql csv mysql-workbench

Error in phpMyAdmin after updating to v4.8.0: The $cfg['TempDir'] (./tmp/) is not accessible

phpMyAdmin worked fine with v4.7.9. Now after updating to v4.8.0 today (replacing the old phpmyadmin folder against the new one) …

php mysql linux phpmyadmin

Unable to access MySQL after it automatically generated a temporary password

I have erased and installed OSX 10.11 El Capitan and I have been following through this tutorial to get MySQL up …

mysql macos osx-elcapitan sequelpro

Yii2 How to perform where AND or OR condition grouping?

I am new to Yii-2 framework. How can i achieve following query in Yii-2 framework using activeQuery and models. SELECT * …

php mysql activerecord yii yii2