Top "Mysql" questions

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

1067 error on attempt to start MySQL

I've installed MySQL on Windows 7. When I'm trying to start MySQL service I'm getting error 1067: The process terminated unexpectedly. Log …

mysql mysql-error-1067
Check for database connection, otherwise display message

I would like to check if the website can connect to mySQL. If not, I would like to display an …

php mysql mysql-error-1064
How to store a datetime in MySQL with timezone info

I have thousands of photos that were taken in Tanzania and I want to store the date and time each …

mysql datetime timezone
Is there a way to view past mysql queries with phpmyadmin?

I'm trying to track down a bug that's deleting rows in a mysql table. For the life of me I …

mysql phpmyadmin
How can I suppress column header output for a single SQL statement?

I'm executing some SQL statements in batch (using the mysql command-line binary). I want one of my several SELECT statements …

mysql output columnheader suppression
How to select the first row for each group in MySQL?

In C# it would be like this: table .GroupBy(row => row.SomeColumn) .Select(group => group .OrderBy(row => …

mysql group-by grouping
where does MySQL store database files?

I have uninstall wamp server and now I need my database to restore. How can I do this process?

mysql phpmyadmin wamp recover
How to enable relation view in phpmyadmin

When working in XAMPP with phpmyadmin, after creating a table I have the option to click "relation view" after clicking …

mysql phpmyadmin
PHP Warning: mysqli_connect(): (HY000/2002): Connection refused

I am using PHP 5.5 and MAMP (downloaded from here): I have a basic script like this: <?php $servername = "127.0.0.1"; $username = "…

php mysql mamp
Create a new Ruby on Rails application using MySQL instead of SQLite

I want to create my Rails application with MySQL, because I like it so much. How can I do that …

mysql ruby-on-rails ruby