Database Archives - Page 41 of 44

I want to pull out duplicate records in a MySQL Database. This can be done with: SELECT address, count(id) as cnt FROM list ...

I am trying to learn the best way to write queries. I also understand the importance of being consistent. Until now, I have ...

SELECT id, amount FROM report I need amount to be amount if report.type="P" and -amount if report.type="N". How do I add this to ...

I have a table story_category in my database with corrupt entries. The next query returns the corrupt entries: SELECT * FROM story_category WHERE ...

Is it possible to temporarily disable constraints in MySQL? I have two Django models, each with a foreign key to the other one. ...

Why doesn’t a TRUNCATE on mygroup work? Even though I have ON DELETE CASCADE SET I get: ERROR 1701 (42000): Cannot truncate a ...

I accidentally enabled ONLY_FULL_GROUP_BY mode like this: SET sql_mode="ONLY_FULL_GROUP_BY"; How do I disable it? 35 s 35

This should be dead simple, but I cannot get it to work for the life of me. I’m just trying to connect remotely ...

How do I copy or clone or duplicate the data, structure, and indices of a MySQL table to a new one? This is ...