Top "Mysql" questions

How to use GROUP_CONCAT in a CONCAT in MySQL

If I have a table with the following data in MySQL: id Name Value 1 A 4 1 A 5 1 B 8 2 C 9 how do …

mysql concat group-concat

mysqldump data only

I am looking for the syntax for dumping all data in my mysql database. I don't want any table information.

mysql mysqldump

How to unblock with mysqladmin flush hosts

I have gone through similar cases listed here but it doesn't seem to work. I was using MySQL Workbench to …

mysql mysql-workbench

Check if table exists without using "select from"

Is there a way to check if a table exists without selecting and checking values from it? That is, I …

mysql sql

How can I modify the size of column in a MySQL table?

I have created a table and accidentally put varchar length as 300 instead of 65353. How can I fix that? An example …

mysql database alter-table

How can I store and retrieve images from a MySQL database using PHP?

How can I insert an image in MySQL and then retrieve it using PHP? I have limited experience in either …

php mysql database blob

Count table rows

What is the MySQL command to retrieve the count of records in a table?

mysql

You can't specify target table for update in FROM clause

I have a simple mysql table: CREATE TABLE IF NOT EXISTS `pers` ( `persID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(35) …

sql mysql mysql-error-1093

How to use MySQLdb with Python and Django in OSX 10.6?

This is a much discussed issue for OSX 10.6 users, but I haven't been able to find a solution that works. …

python mysql django virtualenv virtualenvwrapper

How to subtract 30 days from the current datetime in mysql?

How do I subtract 30 days from the current datetime in mysql? SELECT * FROM table WHERE exec_datetime BETWEEN DATEDIFF(NOW() …

mysql