MySQL (F.A.Q.)

Linear Mode

MySQL (F.A.Q.)

gensek4
Big Clucker

Posts: 147
Threads: 6
Joined: Jan 2015
Reputation: 0

#162

30.08.2019, 02:39

( Last edited by gensek4; 30/08/2019 at 04:24 AM. )

Quote:

Originally Posted by Stepashka

View Post

Если дату хранишь в unix формате то весь запрос выглядит так:

Потребовалось время, что бы понять, что вместо TRUNCATE предполагалось IFNULL)

Спасибо больше, довольно сложно получилось, но зато смог разобраться.
А если допустим необходимо вывести топ из 10 игроков по онлайну за все время?

Все также есть
таблица account
- id
- name
и таблица online
- account_id
- online_sec
- afk_sec

Find

Reply

« Next Oldest | Next Newest »

Messages In This Thread

MySQL (F.A.Q.) - by Stepashka - 22.01.2014, 17:44

Re: MySQL (F.A.Q.) - by Stepashka - 22.01.2014, 17:45

Что такое лэйблы и как использовать as. - by Stepashka - 22.01.2014, 18:31

Re: MySQL (F.A.Q.) - by hub4 - 23.01.2014, 06:20

Re: MySQL (F.A.Q.) - by Stepashka - 23.01.2014, 06:52

Re: MySQL (F.A.Q.) - by Urukhay - 23.01.2014, 12:15

Re: MySQL (F.A.Q.) - by Nazarik - 27.01.2014, 10:36

Re: MySQL (F.A.Q.) - by Splav - 27.01.2014, 11:04

Re: MySQL (F.A.Q.) - by Stepashka - 27.01.2014, 11:36

Re: MySQL (F.A.Q.) - by ZiGGi - 27.01.2014, 13:14

Re: MySQL (F.A.Q.) - by Alexander_Petrov - 09.02.2014, 14:51

Re: MySQL (F.A.Q.) - by stabker - 10.02.2014, 18:53

Re: MySQL (F.A.Q.) - by Stepashka - 10.02.2014, 19:05

Re: MySQL (F.A.Q.) - by stabker - 10.02.2014, 20:10

Re: MySQL (F.A.Q.) - by Stepashka - 10.02.2014, 20:42

Re: MySQL (F.A.Q.) - by stabker - 10.02.2014, 20:52

Re: MySQL (F.A.Q.) - by Urukhay - 13.02.2014, 03:34

Re: MySQL (F.A.Q.) - by Stepashka - 13.02.2014, 07:20

Re: MySQL (F.A.Q.) - by Urukhay - 13.02.2014, 12:59

Re: MySQL (F.A.Q.) - by Stepashka - 13.02.2014, 13:01

Re: MySQL (F.A.Q.) - by Urukhay - 13.02.2014, 13:06

Re: MySQL (F.A.Q.) - by Alexander_Petrov - 13.02.2014, 13:16

Re: MySQL (F.A.Q.) - by Urukhay - 13.02.2014, 13:40

Re: MySQL (F.A.Q.) - by Alexander_Petrov - 13.02.2014, 13:57

Re: MySQL (F.A.Q.) - by Stepashka - 13.02.2014, 14:06

Re: MySQL (F.A.Q.) - by Urukhay - 13.02.2014, 14:17

Re: MySQL (F.A.Q.) - by Urukhay - 15.02.2014, 09:29

Re: MySQL (F.A.Q.) - by Stepashka - 15.02.2014, 09:49

Re: MySQL (F.A.Q.) - by Urukhay - 15.02.2014, 10:39

Re: MySQL (F.A.Q.) - by Stepashka - 15.02.2014, 11:47

Re: MySQL (F.A.Q.) - by Urukhay - 15.02.2014, 12:41

Re: MySQL (F.A.Q.) - by k3dr - 15.02.2014, 15:04

Re: MySQL (F.A.Q.) - by Stepashka - 15.02.2014, 15:06

Re: MySQL (F.A.Q.) - by k3dr - 15.02.2014, 15:48

Re: MySQL (F.A.Q.) - by Stepashka - 15.02.2014, 15:53

Re: MySQL (F.A.Q.) - by k3dr - 15.02.2014, 16:02

Re: MySQL (F.A.Q.) - by Alexander_Petrov - 16.02.2014, 14:58

Re: MySQL (F.A.Q.) - by Stepashka - 16.02.2014, 16:00

Re: MySQL (F.A.Q.) - by Nazarik - 17.02.2014, 05:57

Re: MySQL (F.A.Q.) - by Nazarik - 17.02.2014, 06:12

Re: MySQL (F.A.Q.) - by Jon_De - 25.03.2014, 18:27

Re: MySQL (F.A.Q.) - by Stepashka - 25.03.2014, 20:03

Re: MySQL (F.A.Q.) - by lost13 - 26.03.2014, 06:46

Re: MySQL (F.A.Q.) - by lost13 - 26.03.2014, 11:06

Re: MySQL (F.A.Q.) - by Stepashka - 26.03.2014, 11:34

Re: MySQL (F.A.Q.) - by OKStyle - 26.03.2014, 11:38

Re: MySQL (F.A.Q.) - by lost13 - 26.03.2014, 12:17

Re: MySQL (F.A.Q.) - by Stepashka - 26.03.2014, 12:34

Re: MySQL (F.A.Q.) - by lost13 - 26.03.2014, 13:06

Re: MySQL (F.A.Q.) - by eakwarp - 26.03.2014, 13:47

Re: MySQL (F.A.Q.) - by Stepashka - 26.03.2014, 14:11

Re: MySQL (F.A.Q.) - by Urukhay - 30.03.2014, 04:06

Re: MySQL (F.A.Q.) - by DartfoL - 30.03.2014, 07:06

Re: MySQL (F.A.Q.) - by Stepashka - 30.03.2014, 08:20

Re: MySQL (F.A.Q.) - by Urukhay - 30.03.2014, 13:02

Re: MySQL (F.A.Q.) - by Stepashka - 30.03.2014, 13:22

Re: MySQL (F.A.Q.) - by lost13 - 31.03.2014, 05:49

Re: MySQL (F.A.Q.) - by Stepashka - 31.03.2014, 06:17

Re: MySQL (F.A.Q.) - by Jon_De - 09.04.2014, 14:36

Re: MySQL (F.A.Q.) - by Stepashka - 09.04.2014, 14:45

Re: MySQL (F.A.Q.) - by OKStyle - 26.05.2014, 03:22

Re: MySQL (F.A.Q.) - by Nazarik - 26.05.2014, 11:08

Re: MySQL (F.A.Q.) - by Stepashka - 26.05.2014, 11:22

Re: MySQL (F.A.Q.) - by Stepashka - 04.07.2014, 17:17

Re: MySQL (F.A.Q.) - by Urukhay - 10.07.2014, 14:43

Re: MySQL (F.A.Q.) - by eakwarp - 10.07.2014, 14:46

Re: MySQL (F.A.Q.) - by Makar93 - 19.07.2014, 13:47

Re: MySQL (F.A.Q.) - by Stepashka - 19.07.2014, 14:05

Re: MySQL (F.A.Q.) - by Makar93 - 19.07.2014, 14:15

Re: MySQL (F.A.Q.) - by Stepashka - 19.07.2014, 14:17

Re: MySQL (F.A.Q.) - by Jon_De - 29.08.2014, 13:20

Re: MySQL (F.A.Q.) - by Stepashka - 29.08.2014, 13:23

Re: MySQL (F.A.Q.) - by stabker - 30.08.2014, 16:09

Re: MySQL (F.A.Q.) - by eakwarp - 30.08.2014, 16:32

Re: MySQL (F.A.Q.) - by Stepashka - 30.08.2014, 16:37

Re: MySQL (F.A.Q.) - by stabker - 30.08.2014, 16:41

Re: MySQL (F.A.Q.) - by Stepashka - 30.08.2014, 17:05

Re: MySQL (F.A.Q.) - by stabker - 30.08.2014, 17:12

Re: MySQL (F.A.Q.) - by Urukhay - 07.09.2014, 08:05

Re: MySQL (F.A.Q.) - by Stepashka - 07.09.2014, 08:11

Re: MySQL (F.A.Q.) - by Makar007 - 01.03.2015, 15:09

Re: MySQL (F.A.Q.) - by Oxsen - 02.03.2015, 20:22

Re: MySQL (F.A.Q.) - by ZiGGi - 02.03.2015, 22:19

Re: MySQL (F.A.Q.) - by CodeBreaker - 04.03.2015, 15:26

Re: MySQL (F.A.Q.) - by Dembel - 05.03.2015, 09:14

Re: MySQL (F.A.Q.) - by Stepashka - 05.03.2015, 09:53

Re: MySQL (F.A.Q.) - by Stepashka - 05.03.2015, 09:53

Re: MySQL (F.A.Q.) - by Dembel - 05.03.2015, 10:00

Re: MySQL (F.A.Q.) - by Stepashka - 05.03.2015, 10:10

Re: MySQL (F.A.Q.) - by Dembel - 05.03.2015, 10:12

Re: MySQL (F.A.Q.) - by CamperGTA - 01.08.2015, 18:03

Re: MySQL (F.A.Q.) - by Stepashka - 01.08.2015, 18:25

Re: MySQL (F.A.Q.) - by Stepashka - 01.08.2015, 19:28

Re: MySQL (F.A.Q.) - by Dembel - 01.08.2015, 21:39

Re: MySQL (F.A.Q.) - by nonamepawn - 01.10.2015, 15:02

Re: MySQL (F.A.Q.) - by xJester - 01.10.2015, 15:36

Re: MySQL (F.A.Q.) - by nonamepawn - 19.10.2015, 14:54

Re: MySQL (F.A.Q.) - by White_116 - 19.10.2015, 15:14

Re: MySQL (F.A.Q.) - by stabker - 19.10.2015, 15:21

Re: MySQL (F.A.Q.) - by White_116 - 19.10.2015, 15:39

Re: MySQL (F.A.Q.) - by Stepashka - 19.10.2015, 17:20

Re: MySQL (F.A.Q.) - by White_116 - 19.10.2015, 18:15

Re: MySQL (F.A.Q.) - by ZiGGi - 19.10.2015, 20:08

Re: MySQL (F.A.Q.) - by themakar - 02.01.2016, 18:00

Re: MySQL (F.A.Q.) - by Stepashka - 02.01.2016, 18:34

Re: MySQL (F.A.Q.) - by themakar - 02.01.2016, 23:56

Re: MySQL (F.A.Q.) - by Davidoff - 03.01.2016, 08:49

Re: MySQL (F.A.Q.) - by Stepashka - 04.01.2016, 15:58

Re: MySQL (F.A.Q.) - by Davidoff - 04.01.2016, 19:46

Re: MySQL (F.A.Q.) - by stabker - 04.01.2016, 21:44

Re: MySQL (F.A.Q.) - by prineside - 05.01.2016, 00:46

Re: MySQL (F.A.Q.) - by Davidoff - 06.01.2016, 19:34

Re: MySQL (F.A.Q.) - by themakar - 28.03.2016, 16:11

Re: MySQL (F.A.Q.) - by ea8de1 - 28.03.2016, 16:20

Re: MySQL (F.A.Q.) - by ea8de1 - 13.04.2016, 14:58

Re: MySQL (F.A.Q.) - by Stepashka - 13.04.2016, 15:00

Re: MySQL (F.A.Q.) - by ea8de1 - 13.04.2016, 15:04

Re: MySQL (F.A.Q.) - by Stepashka - 13.04.2016, 16:19

Re: MySQL (F.A.Q.) - by ea8de1 - 13.04.2016, 16:22

Re: MySQL (F.A.Q.) - by themakar - 21.05.2016, 16:12

Re: MySQL (F.A.Q.) - by Eims - 09.11.2016, 21:04

Re: MySQL (F.A.Q.) - by S4D - 10.11.2016, 06:34

Re: MySQL (F.A.Q.) - by Stepashka - 10.11.2016, 08:08

Re: MySQL (F.A.Q.) - by Eims - 10.11.2016, 10:24

Re: MySQL (F.A.Q.) - by Sidorovich12 - 18.02.2017, 08:49

Re: MySQL (F.A.Q.) - by Mcc - 18.02.2017, 11:43

Re: MySQL (F.A.Q.) - by Bombo - 20.02.2017, 09:17

Re: MySQL (F.A.Q.) - by Sidorovich12 - 04.03.2017, 14:19

Re: MySQL (F.A.Q.) - by youngPimp - 20.06.2017, 13:00

Re: MySQL (F.A.Q.) - by Mcc - 20.06.2017, 13:48

Re: MySQL (F.A.Q.) - by cm666 - 21.06.2017, 20:42

Re: MySQL (F.A.Q.) - by youngPimp - 22.06.2017, 02:07

Re: MySQL (F.A.Q.) - by joker2020pro - 22.06.2017, 03:36

Re: MySQL (F.A.Q.) - by Eims - 07.09.2017, 14:20

Re: MySQL (F.A.Q.) - by ZiGGi - 07.09.2017, 15:15

Re: MySQL (F.A.Q.) - by Johhnyllll - 07.09.2017, 15:18

Re: MySQL (F.A.Q.) - by Eims - 07.09.2017, 16:15

Re: MySQL (F.A.Q.) - by pawnoholic - 23.03.2019, 20:59

Re: MySQL (F.A.Q.) - by Stepashka - 24.03.2019, 08:49

Re: MySQL (F.A.Q.) - by pawnoholic - 24.03.2019, 11:17

Re: MySQL (F.A.Q.) - by Stepashka - 24.03.2019, 11:26

Re: MySQL (F.A.Q.) - by Eims - 25.03.2019, 09:08

Re: MySQL (F.A.Q.) - by Stepashka - 25.03.2019, 11:21

Re: MySQL (F.A.Q.) - by Eims - 25.03.2019, 13:41

Re: MySQL (F.A.Q.) - by x_O - 21.04.2019, 19:33

Re: MySQL (F.A.Q.) - by Stepashka - 21.04.2019, 19:42

Re: MySQL (F.A.Q.) - by x_O - 21.04.2019, 20:02

Re: MySQL (F.A.Q.) - by Johhnyllll - 30.04.2019, 10:44

Re: MySQL (F.A.Q.) - by eakwarp - 30.04.2019, 10:47

Re: MySQL (F.A.Q.) - by Johhnyllll - 30.04.2019, 10:48

Re: MySQL (F.A.Q.) - by Stepashka - 30.04.2019, 12:04

Re: MySQL (F.A.Q.) - by Johhnyllll - 30.04.2019, 12:26

Re: MySQL (F.A.Q.) - by Stepashka - 30.04.2019, 12:30

Re: MySQL (F.A.Q.) - by bgAndroid - 06.08.2019, 02:12

Re: MySQL (F.A.Q.) - by Stepashka - 06.08.2019, 07:20

Re: MySQL (F.A.Q.) - by cm666 - 06.08.2019, 14:25

Re: MySQL (F.A.Q.) - by Stepashka - 06.08.2019, 20:28

Re: MySQL (F.A.Q.) - by gensek4 - 28.08.2019, 02:11

Re: MySQL (F.A.Q.) - by Stepashka - 28.08.2019, 06:46

Re: MySQL (F.A.Q.) - by gensek4 - 29.08.2019, 11:35

Re: MySQL (F.A.Q.) - by Stepashka - 29.08.2019, 12:03

Re: MySQL (F.A.Q.) - by gensek4 - 30.08.2019, 02:39

Re: MySQL (F.A.Q.) - by Stepashka - 30.08.2019, 06:50

Re: MySQL (F.A.Q.) - by gensek4 - 30.08.2019, 07:22

View a Printable Version

Forum Jump:

Users browsing this thread: 1 Guest(s)