How to find MySQL process list and to kill those processes??

The MySQL database hangs, due to some queries. How can I find the processes and kill them? ...

Uninstalling XAMPP and its services?

I have installed xampp while port 80 wasn't free. As a result one of the services wasn't able to run. Then I tried t...

MySQL query to get column names??

I'd like to get all of a mysql table's col names into an array in php? Is there a query for this? ...

How does MySQL store data?

I looked around Goole but didn't find any good answer. Does it store the data in one big file? What methods does it ...

Installing specific package versions with pip?

I'm trying to install version 1.2.2 of the MySQL_python adaptor, using a fresh virtualenv created with the --no-site...

Display menu PHP as per timeslot PHP MySQL?

I have a table in MySQL DB which stores Menu served by restaurant on each weekday and in time slots. Table structur...

mysql update query with sub query?

Can anyone see what is wrong with the below query? When I run it I get: #1064 - You have an error in your SQL s...

Joining 3 tables with mySQL with 1 query?

This has been asked and answered in different instances but all that I've seen doesn't quite work for my problem. P...

ERROR 1396 (HY000): Operation CREATE USER failed for 'jack'@'localhost'?

I seem to be unable to re-create a simple user I've deleted, even as root in MySQL. My case: user 'jack' existed be...

MySQL TEXT vs BLOB vs CLOB?

What are the differences, advantages and disadvantages of these different data-types both from a performance standpo...

How to get index of element in Laravel collection?

How to retrieve the index of an element in a collection ? My code : $users = User::has('posts')->withCount('pos...

SQL Update query with group by clause?

Name type Age ------------------------------- Vijay 1 23 Kumar 2 26 An...