Mysql
MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). DO NOT USE this tag for other DBs such as SQL Server, SQLite etc. These are different DBs which all use SQL to manage the data.
72
votes
14
answers
2.7K
views
How do I see all foreign keys to a table or column?
In MySQL, how do I get a list of all foreign key constraints pointing to a particular table? a particular colu
69
votes
11
answers
2.1K
views
MySQL: Grant **all** privileges on database
I've created database, for example 'mydb'. CREATE DATABASE mydb CHARACTER SET utf8 COLLATE ut
60
votes
8
answers
2.9K
views
Create new user in MySQL and give it full access to one database
I want to create a new user in MySQL and give it full access only to one database, say dbTest, that I create w
60
votes
24
answers
588
views
Find duplicate records in MySQL
I want to pull out duplicate records in a MySQL Database. This can be done with: SELECT address, count(id) a
60
votes
16
answers
2.1K
views
MySQL Error 1093 - Can't specify target table for update in FROM clause
I have a table story_category in my database with corrupt entries. The next query returns the corrupt entries:
59
votes
30
answers
1.5K
views
Disable ONLY_FULL_GROUP_BY
I accidentally enabled ONLY_FULL_GROUP_BY mode like this: SET sql_mode = 'ONLY_FULL_GROUP_BY'; Ho
60
votes
13
answers
2.5K
views
How to truncate a foreign key constrained table?
Why doesn't a TRUNCATE on mygroup work? Even though I have ON DELETE CASCADE SET I get: ERROR 1701 (4
59
votes
27
answers
1.6K
views
Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server
This should be dead simple, but I cannot get it to work for the life of me. I'm just trying to connect re
64
votes
14
answers
753
views
Duplicating a MySQL table, indices, and data
How do I copy or clone or duplicate the data, structure, and indices of a MySQL table to a new one? This is w
47
votes
26
answers
955
views
Finding duplicate values in MySQL
I have a table with a varchar column, and I would like to find all the records that have duplicate values in t
59
votes
4
answers
1.2K
views
TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
Per the MySQL docs, there are four TEXT types: TINYTEXT TEXT MEDIUMTEXT LONGTEXT What is the maximum length t
47
votes
8
answers
1.3K
views
MySQL: Large VARCHAR vs. TEXT?
I've got a messages table in MySQL which records messages between users. Apart from the typical ids and m
57
votes
12
answers
677
views
"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"
While executing an INSERT statement with many rows, I want to skip duplicate entries that would otherwise caus
58
votes
11
answers
1.8K
views
How can I find all the tables in MySQL with specific column names in them?
I have 2-3 different column names that I want to look up in the entire database and list out all tables which
58
votes
26
answers
1.9K
views
How do you set a default value for a MySQL Datetime column?
How do you set a default value for a MySQL Datetime column? In SQL Server it's getdate(). What is the eq
54
votes
14
answers
2.1K
views
How do I specify unique constraint for multiple columns in MySQL?
I have a table: table votes ( id, user, email, address, primary key(id), ); Now I want
58
votes
20
answers
480
views
MySQL error code: 1175 during UPDATE in MySQL Workbench
I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writi
51
votes
17
answers
682
views
How to get the sizes of the tables of a MySQL database?
I can run this query to get the sizes of all tables in a MySQL database: show table status from myDatabaseNam
60
votes
30
answers
1.7K
views
How do I quickly rename a MySQL database (change schema name)?
The MySQL manual at MySQL covers this. Usually I just dump the database and reimport it with a new name. This
55
votes
8
answers
2.4K
views
What's the difference between utf8_general_ci and utf8_unicode_ci?
Between utf8_general_ci and utf8_unicode_ci, are there any differences in terms of performance?
