Top "Mysql" questions

How to recover MySQL database from .myd, .myi, .frm files

How to restore one of my MySQL databases from .myd, .myi, .frm files?

mysql recovery

How can I enable the MySQLi extension in PHP 7?

I have installed PHP 7 and MySQL 5.5.47 on Ubuntu 14.04 (Trusty Tahr). I have checked installed extension using: sudo apt-cache search php7…

php mysql mysqli php-7

Joining three tables using MySQL

I have three tables named **Student Table** ------------- id name ------------- 1 ali 2 ahmed 3 john 4 king **Course Table** ------------- id name …

mysql

Maximum execution time in phpMyadmin

When I try to execute (some) queries in phpMyadmin I get this error Fatal error: Maximum execution time of 60 seconds …

php mysql database xampp execution-time

Extension mysqli is missing, phpmyadmin doesn't work

I have a problem with phpmyadmin on ubuntu 12.04. I have already installed apache2, php5, mysql and phpmyadmin. The phpinfo(); script, …

php mysql phpmyadmin ubuntu-12.04

SQL UPDATE all values in a field with appended string CONCAT not working

Here is what I want to do: current table: +----+-------------+ | id | data | +----+-------------+ | 1 | max | | 2 | linda | | 3 | sam | | 4 | henry | +----+…

sql mysql concatenation concat

Convert Unix timestamp into human readable date using MySQL

Is there a MySQL function which can be used to convert a Unix timestamp into a human readable date? I …

mysql unix-timestamp

How to see full query from SHOW PROCESSLIST

When I issue SHOW PROCESSLIST query, only first 100 characters of the running SQL query are returned in the info column. …

mysql

How to alter a column and change the default value?

I got the following error while trying to alter a column's data type and setting a new default value: ALTER …

mysql sql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

I installed MySQL on Mac OS X Mountain Lion with homebrew install mysql, but when I tried mysql -u root …

mysql macos