MySQL error: key specification without a key length?

I have a table with a primary key that is a varchar(255). Some cases have arisen where 255 characters isn't enough. ...

MySQL the right syntax to use near '' at line 1 error?

hello i have a run a query using php it give error You have an error in your SQL syntax; check the manual that cor...

mysql: why comparing a 'string' to 0 gives true??

I was doing some MySQL test queries, and realized that comparing a string column with 0 (as a number) gives TRUE! s...

How to convert a MySQL DB to XML??

How can you convert a MySQL database to XML? I want everythimg... data and there relation in XML schema file how to...

DateTime group by date and hour?

I have a datetime called activity_dt and the data looks like this: 2/5/2013 9:24:00 AM 2/7/2013 7:17:00 AM How do...

How to display image from database using php?

I am trying to display an image coming from the database and I was not able to display the image .but its showing li...

Undefined function mysql_connect()?

I have ran aptitude install php5-mysql (and restarted MySQL/Apache 2), but I am still getting this error: Fatal ...

Mysql Can't create/write to file error#13?

I had created a Django view which is returning some data after reading from MySql DB.When i try and fetch around 600...

How can I select the row with the highest ID in MySQL??

How can I select the row with the highest ID in MySQL? This is my current code: SELECT * FROM permlog WHERE max(id)...

Is there a way to run MySQL in-memory for JUnit test cases??

I'm just trying to add test cases for services accessing a MySQL DB, and I would like to recreate the whole schema (...

Hibernate: Automatically creating/updating the db tables based on entity classes?

I have the following entity class (in Groovy): import javax.persistence.Entity import javax.persistence.Id import j...

How can I roll back my last delete command in MySQL??

I accidentally deleted some huge number of rows from a table... How can I roll it back? I executed the query using...

XML output from MySQL?

is there any chance of getting the output from a MySQL query directly to XML? Im referring to something like MSSQL ...

When to use Redis instead of MySQL for PHP applications??

I've been looking at Redis. It looks very interesting. But from a practical perspective, in what cases would it be b...