Top "Mysql" questions

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

SELECTING with multiple WHERE conditions on same column

Ok, I think I might be overlooking something obvious/simple here... but I need to write a query that returns …

mysql sql aggregate-functions where-clause
Data truncated for column?

After changing the data type of a MySql column in order to store Twilio call ids (34 char strings), I try …

mysql warnings twilio
Rename a table in MySQL

Renaming a table is not working in MySQL RENAME TABLE group TO member; The error message is #1064 - You have …

mysql database table-rename
brew install mysql on macOS

I'm trying to setup up MySQL on mac os 10.6 using Homebrew by brew install mysql 5.1.52. Everything goes well and I …

mysql macos homebrew mysql-error-1045
how to convert a string to date in mysql?

I have a string column which acts as a date and I want to select it as a date. Is …

mysql string date
Fix Access denied for user 'root'@'localhost' for phpMyAdmin

I'm using WAMP Server 2.2 on a PC. In phpMyAdmin (version 5.5.24) I edited the 'root' user (with 'localhost' host) and gave …

php mysql phpmyadmin wamp
Row count with PDO

There are many conflicting statements around. What is the best way to get the row count using PDO in PHP? …

php mysql pdo
How do I remove a MySQL database?

You may notice from my last question that a problem caused some more problems, Reading MySQL manuals in MySQL monitor? …

mysql
How do I kill all the processes in Mysql "show processlist"?

Because I see a lot of processes there, and the "time" column shows big values for all of them.

mysql database
Remove duplicate rows in MySQL

I have a table with the following fields: id (Unique) url (Unique) title company site_id Now, I need to …

mysql sql duplicates