porton
  • Member for 10 years, 1 month
  • Last seen this week
3 answers
12 votes
9k views
2 bookmarks
Implementing a one to zero or one relationship in SQL
1 answers
6 votes
432 views
1 bookmarks
Are two indexes needed?
4 answers
4 votes
3k views
Two ways to define may-have-a (1..0-1) relationship
3 answers
4 votes
11k views
Assigning empty string to INT NULL field in MySQL
1 answers
3 votes
13k views
Get week/month data
1 answers
3 votes
301 views
Sequential joining of tables in order
2 answers
3 votes
249 views
Finding rows for a specified date range
1 answers
2 votes
162 views
One table or several tables?
1 answers
2 votes
2k views
Difference data between adjacent rows
2 answers
1 votes
1k views
#1093 - You can't specify target table 'R' for update in FROM clause
2 answers
1 votes
72 views
Is LIMIT processed before or after retrieving data?
1 answers
1 votes
110 views
Extract data for all groups in a single SELECT statement
2 answers
1 votes
262 views
Should I create a multi-column UNIQUE index?
1 answers
1 votes
713 views
1 bookmarks
Why does it use temporary? (MySQL)
1 answers
1 votes
188 views
A MySQL EXPLAIN number of rows discrepancy
2 answers
1 votes
2k views
A low cardinality column index and SELECT
1 answers
1 votes
67 views
Adding an index without a lag (PostgreSQL)
1 answers
1 votes
8k views
Getting the first day of week
1 answers
1 votes
38 views
Stroring a type of an entry
0 answers
1 votes
50 views
A separate table or ENUM?
2 answers
1 votes
37 views
A query for a latest version of data
1 answers
1 votes
41 views
PostgreSQL chooses a wrong order of Hash Join
1 answers
0 votes
121 views
Sorting by a field in child table
1 answers
0 votes
38 views
Which of tables key to reference?
1 answers
0 votes
85 views
best relationship for this design?
1 answers
0 votes
343 views
1 bookmarks
How to represent it with UNIQUE indexes and foreign keys?
1 answers
0 votes
80 views
Several variants of a string in tables
1 answers
0 votes
76 views
Two dichotomy views of a table, and means to express this as a stored procudure?
0 answers
0 votes
19 views
Force PostgreSQL not to think beyond what EXPLAIN says
2 answers
0 votes
4k views
"Cannot drop index 'unique_token_data': needed in a foreign key constraint" in MySQL without a foreign key