2022 Developer Survey is open! Take survey.
user avatar
user avatar
user avatar
porton
  • Member for 10 years, 5 months
  • Last seen more than a month ago
1 vote
1 answer
192 views

A MySQL EXPLAIN number of rows discrepancy

1 vote
1 answer
54 views

LIKE or match by beginning for binary strings in PostgreSQL

0 votes
2 answers
4k views

"Cannot drop index 'unique_token_data': needed in a foreign key constraint" in MySQL without a foreign key

4 votes
3 answers
11k views

Assigning empty string to INT NULL field in MySQL

1 vote
1 answer
60 views

PostgreSQL chooses a wrong order of Hash Join

0 votes
0 answers
19 views

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

4 votes
4 answers
3k views

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

0 votes
2 answers
75 views

When rows of a resultset are generated?

1 vote
1 answer
82 views

Adding an index without a lag (PostgreSQL)

1 vote
2 answers
2k views

A low cardinality column index and SELECT

13 votes
3 answers
9k views

Implementing a one to zero or one relationship in SQL

6 votes
1 answer
449 views

Are two indexes needed?

0 votes
2 answers
1k views

Replace some rows in one table with rows of another table

1 vote
1 answer
752 views

Why does it use temporary? (MySQL)

0 votes
0 answers
916 views

Fetching from parent/child table pairs

1 vote
2 answers
1k views

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

1 vote
2 answers
73 views

Is LIMIT processed before or after retrieving data?

0 votes
2 answers
201 views

Updating a table with a single UPDATE statement vs several UPDATE statements

2 votes
1 answer
2k views

Difference data between adjacent rows

0 votes
0 answers
186 views

Store both a city and its region?

0 votes
0 answers
261 views

Performance: Interleaving several statement handles in MySQL

1 vote
2 answers
272 views

Should I create a multi-column UNIQUE index?

3 votes
1 answer
13k views

Get week/month data

0 votes
1 answer
130 views

Sorting by a field in child table

-1 votes
1 answer
52 views

One or two tables (for two things: cancellations and moves)?

1 vote
1 answer
112 views

Extract data for all groups in a single SELECT statement

-1 votes
1 answer
2k views

Calculating employee's work time

4 votes
2 answers
257 views

Finding rows for a specified date range

0 votes
1 answer
346 views

How to represent it with UNIQUE indexes and foreign keys?

1 vote
0 answers
50 views

A separate table or ENUM? [duplicate]