Top "Mysql" questions

how to access the command line for xampp on windows

I am running Xampp on my Windows 7 machine and was wondering if and how I could run commands for xampp …

php mysql apache xampp

Storing image in database directly or as base64 data?

The common method to store images in a database is to convert the image to base64 data before storing the …

mysql database image imagemagick base64

How to search JSON data in MySQL?

I have inserted records in mysql DB, with json encoded data type, Now I have to make search within json …

mysql json mysql-json

How do I repair an InnoDB table?

We (apparently) had poorly executed of our Solaris MySQL database engine last night. At least some of the InnoDB tables …

mysql innodb repair

MySql Inner Join with WHERE clause

Here is my code: SELECT table1.f_id FROM table1 WHERE table1.f_com_id = '430' AND table1.f_…

mysql sql where-clause mysql-error-1064

How can I convert an MDB (Access) file to MySQL (or plain SQL file)?

Is it possible to create a Dump of SQL commands from a Microsoft Access database? I hope to convert this …

mysql sql ms-access import dump

Howto: Clean a mysql InnoDB storage engine?

Is it possible to clean a mysql innodb storage engine so it is not storing data from deleted tables? Or …

mysql innodb

Error Code: 1005. Can't create table '...' (errno: 150)

I searched for a solution to this problem on the Internet and checked the Stack Overflow questions, but none of …

mysql foreign-keys mysql-error-1005

Change a column type from Date to DateTime during ROR migration

I need to change my column type from date to datetime for an app I am making. I don't care …

mysql ruby-on-rails ruby ruby-on-rails-3 migration

Can't connect to local MySQL server through socket homebrew

I recently tried installing MySQL with homebrew (brew install mysql) and when I try to run it I get the …

mysql homebrew