Top "Mysql" questions

Clear MySQL query cache without restarting server

Is there any way to clear mysql query cache without restarting mySQL server?

mysql caching

FIND_IN_SET() vs IN()

I have 2 tables in my database. One is for orders, and one is for companies. Orders has this structure: OrderID | …

mysql

ImportError: No module named MySQLdb

I am referring the following tutorial to make a login page for my web application. http://code.tutsplus.com/tutorials/…

python mysql flask sqlalchemy mysql-python

MySQL vs MySQLi when using PHP

Which is better, MySQL or MySQLi? And why? Which should I use? I mean better not just in terms of …

php mysql mysqli

Insert auto increment primary key to existing table

I am trying to alter a table which has no primary key nor auto_increment column. I know how to …

mysql primary-key

MySQL user DB does not have password columns - Installing MySQL on OSX

I am trying to change MySql root password. What I have done is below. Install MySql-5.7.6 ~ .dmg(Community Server) and …

mysql macos passwords root

Error Code 1292 - Truncated incorrect DOUBLE value - Mysql

I am not sure what is this error! #1292 - Truncated incorrect DOUBLE value: I don't have double value field or …

mysql truncated mysql-error-1292

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?

mysql kill-process

Mysql: Select all data between two dates

I have a mysql table with data connected to dates. Each row has data and a date, like this: 2009-06…

mysql date between

Find most frequent value in SQL column

How can I find the most frequent value in a given column in an SQL table? For example, for this …

mysql sql