In MySQL, how do I get a list of all foreign key constraints pointing to a particular table? a particular colu
I've created database, for example 'mydb'.
CREATE DATABASE mydb CHARACTER SET utf8 COLLATE ut
I want to create a new user in MySQL and give it full access only to one database, say dbTest, that I create w
I want to pull out duplicate records in a MySQL Database. This can be done with:
SELECT address, count(id) a
I have a table story_category in my database with corrupt entries. The next query returns the corrupt entries:
I am trying to learn the best way to write queries. I also understand the importance of being consistent. Unti
What is the (default) charset for:
Is there an SQL injection possibility even when using mysql_real_escape_string() function?
Consider this samp
Is it possible to make a simple query to count how many records I have in a determined period of time like a y
Is it possible to temporarily disable constraints in MySQL?
I have two Django models, each with a foreign key
SELECT id, amount FROM report
I need amount to be amount if report.type='P' and -amount if report.
I accidentally enabled ONLY_FULL_GROUP_BY mode like this:
SET sql_mode = 'ONLY_FULL_GROUP_BY';
Why doesn't a TRUNCATE on mygroup work?
Even though I have ON DELETE CASCADE SET I get:
ERROR 1701 (4
I want to do a full outer join in MySQL. Is this possible? Is a full outer join supported by MySQL?
This should be dead simple, but I cannot get it to work for the life of me.
I'm just trying to connect re
How do I copy or clone or duplicate the data, structure,
and indices of a MySQL table to a new one?
This is w
I have a table with a varchar column, and I would like to find all the records that have duplicate values in t
Per the MySQL docs, there are four TEXT types:
What is the maximum length t
I've got a messages table in MySQL which records messages between users. Apart from the typical ids and m
While executing an INSERT statement with many rows, I want to skip duplicate entries that would otherwise caus