user avatar
user avatar
user avatar
porton
  • Member for 10 years, 6 months
  • Last seen more than a month ago
13 votes
3 answers
10k views

Implementing a one to zero or one relationship in SQL

6 votes
1 answer
455 views

Are two indexes needed?

4 votes
2 answers
258 views

Finding rows for a specified date range

4 votes
4 answers
3k views

Two ways to define may-have-a (1..0-1) relationship

4 votes
3 answers
11k views

Assigning empty string to INT NULL field in MySQL

3 votes
1 answer
315 views

Sequential joining of tables in order

3 votes
1 answer
13k views

Get week/month data

2 votes
1 answer
164 views

One table or several tables?

2 votes
1 answer
2k views

Difference data between adjacent rows

1 vote
2 answers
1k views

#1093 - You can't specify target table 'R' for update in FROM clause

1 vote
2 answers
75 views

Is LIMIT processed before or after retrieving data?

1 vote
1 answer
112 views

Extract data for all groups in a single SELECT statement

1 vote
2 answers
275 views

Should I create a multi-column UNIQUE index?

1 vote
1 answer
763 views

Why does it use temporary? (MySQL)

1 vote
1 answer
197 views

A MySQL EXPLAIN number of rows discrepancy

1 vote
2 answers
2k views

A low cardinality column index and SELECT

1 vote
1 answer
97 views

Adding an index without a lag (PostgreSQL)

1 vote
1 answer
8k views

Getting the first day of week

1 vote
1 answer
39 views

Stroring a type of an entry

1 vote
2 answers
38 views

A query for a latest version of data

1 vote
0 answers
50 views

A separate table or ENUM? [duplicate]

1 vote
1 answer
82 views

PostgreSQL chooses a wrong order of Hash Join

1 vote
1 answer
83 views

LIKE or match by beginning for binary strings in PostgreSQL

0 votes
1 answer
134 views

Sorting by a field in child table

0 votes
1 answer
347 views

How to represent it with UNIQUE indexes and foreign keys?

0 votes
1 answer
40 views

Which of tables key to reference?

0 votes
1 answer
87 views

best relationship for this design?

0 votes
1 answer
81 views

Several variants of a string in tables

0 votes
1 answer
77 views

Two dichotomy views of a table, and means to express this as a stored procudure?

0 votes
0 answers
19 views

Force PostgreSQL not to think beyond what EXPLAIN says [duplicate]