User porton

13 votes

3 answers

10k views

Implementing a one to zero or one relationship in SQL

database-design foreign-key

asked Dec 13, 2011 at 15:55

6 votes

1 answer

455 views

Are two indexes needed?

asked Jun 11, 2012 at 14:22

4 votes

2 answers

258 views

Finding rows for a specified date range

mysql datetime

asked Jul 14, 2013 at 15:07

4 votes

4 answers

3k views

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

mysql database-design foreign-key unique-constraint subtypes

asked Nov 3, 2015 at 16:28

4 votes

3 answers

11k views

Assigning empty string to INT NULL field in MySQL

mysql datatypes type-conversion

asked Jul 16, 2018 at 18:54

3 votes

1 answer

315 views

Sequential joining of tables in order

mysql order-by

asked Mar 6, 2013 at 19:46

3 votes

1 answer

13k views

Get week/month data

mysql

asked Dec 5, 2012 at 9:34

2 votes

1 answer

164 views

One table or several tables?

database-design

asked Apr 16, 2012 at 15:39

2 votes

1 answer

2k views

Difference data between adjacent rows

mysql select cursors

asked Aug 31, 2014 at 21:50

1 vote

2 answers

1k views

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

mysql subquery errors

asked Sep 1, 2014 at 13:03

1 vote

2 answers

75 views

Is LIMIT processed before or after retrieving data?

mysql performance optimization query-performance

asked Jun 7, 2015 at 12:22

1 vote

1 answer

112 views

Extract data for all groups in a single SELECT statement

mysql order-by

asked Oct 4, 2013 at 14:25

1 vote

2 answers

275 views

Should I create a multi-column UNIQUE index?

mysql index myisam unique-constraint

asked Jun 23, 2014 at 16:04

1 vote

1 answer

763 views

Why does it use temporary? (MySQL)

mysql performance index index-tuning explain

asked Jun 4, 2017 at 16:40

1 vote

1 answer

197 views

A MySQL EXPLAIN number of rows discrepancy

mysql performance explain performance-tuning

asked Jun 5, 2017 at 11:52

1 vote

2 answers

2k views

A low cardinality column index and SELECT

mysql index cardinality-estimates

asked Dec 18, 2018 at 17:02

1 vote

1 answer

97 views

Adding an index without a lag (PostgreSQL)

postgresql performance index postgresql-performance

asked Jul 24, 2020 at 19:08

1 vote

1 answer

8k views

Getting the first day of week

mysql date-format

asked Dec 19, 2012 at 13:47

1 vote

1 answer

39 views

Stroring a type of an entry

normalization database-design

asked Nov 1, 2012 at 9:31

1 vote

2 answers

38 views

A query for a latest version of data

mysql stored-procedures view datetime

asked Apr 23, 2013 at 16:33

1 vote

0 answers

50 views

A separate table or ENUM? [duplicate]

foreign-key database-design

asked May 13, 2013 at 12:28

1 vote

1 answer

82 views

PostgreSQL chooses a wrong order of Hash Join

postgresql query-performance join execution-plan postgresql-13

asked Aug 6, 2021 at 16:45

1 vote

1 answer

83 views

LIKE or match by beginning for binary strings in PostgreSQL

postgresql index blob varbinary bytea

asked Feb 5 at 2:54

0 votes

1 answer

134 views

Sorting by a field in child table

mysql join order-by sorting

asked Nov 11, 2013 at 15:01

0 votes

1 answer

347 views

How to represent it with UNIQUE indexes and foreign keys?

foreign-key database-design

asked Jul 4, 2013 at 18:32

0 votes

1 answer

40 views

Which of tables key to reference?

mysql database-design foreign-key primary-key

asked Apr 25, 2013 at 14:43

0 votes

1 answer

87 views

best relationship for this design?

mysql foreign-key mysql-workbench

asked Apr 25, 2013 at 16:28

0 votes

1 answer

81 views

Several variants of a string in tables

database-design

asked Oct 23, 2012 at 20:20

0 votes

1 answer

77 views

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

mysql stored-procedures view

asked Mar 5, 2013 at 12:59

0 votes

0 answers

19 views

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

postgresql query-performance execution-plan explain

asked Aug 6, 2021 at 16:06

Stack Exchange Network

current community

your communities

more stack exchange communities

40 Questions

Implementing a one to zero or one relationship in SQL

Are two indexes needed?

Finding rows for a specified date range

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

Assigning empty string to INT NULL field in MySQL

Sequential joining of tables in order

Get week/month data

One table or several tables?

Difference data between adjacent rows

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

Is LIMIT processed before or after retrieving data?

Extract data for all groups in a single SELECT statement

Should I create a multi-column UNIQUE index?

Why does it use temporary? (MySQL)

A MySQL EXPLAIN number of rows discrepancy

A low cardinality column index and SELECT

Adding an index without a lag (PostgreSQL)

Getting the first day of week

Stroring a type of an entry

A query for a latest version of data

A separate table or ENUM? [duplicate]

PostgreSQL chooses a wrong order of Hash Join

LIKE or match by beginning for binary strings in PostgreSQL

Sorting by a field in child table

How to represent it with UNIQUE indexes and foreign keys?

Which of tables key to reference?

best relationship for this design?

Several variants of a string in tables

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

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