Tagged Questions
1
vote
3answers
85 views
Can I make sure two columns dont have the same value
If I have a table that looks like this
CREATE TABLE foo (
id INT NOT NULL AUTO_INCREMENT,
aa INT NOT NULL,
bb INT NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY (aa, bb),
CONSTRAINT aa_ref ...
1
vote
0answers
31 views
How does MySQL 5.1 use indexes?
I've read the docs for MySQL v5.1.x on how about the indexes are used, but I'm not sure I understood it properly.
Suppose having the following MySQL table:
CREATE TABLE IF NOT EXISTS ...
1
vote
2answers
295 views
Lost connection to MySQL server during query
Here is a part of my query
SELECT * INTO OUTFILE 'Target_File_Name' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '' FROM (SELECT 'Start time','Calling no','Called ...
3
votes
1answer
425 views
Is it possible to compare timestamps between rows?
I have a MySQL table reqs with (this is simplified from actual):
| Field | Type | Null | Key | Default | Extra |
...
