MySQL community server witch performance better on windows or Linux?

|
thanosphan 2021-09-10 09:02:31
What query are you trying?
thanosphan 2021-09-10 09:03:19
select sum(balance) from table group by wallet, to_date(timestamp)
thanosphan 2021-09-10 09:03:44
I don’t know what exactly the function is to convert the Timestamp to date. You can look it up for the DB engine you are using
thanosphan 2021-09-10 09:41:16
https://paiza.io/projects/e/Wmp-YhXGGLpzNCo8bELwnw

Something like this

Online editor and compilerpaiza.io
Paiza.IO is online editor and compiler. Java, Ruby, Python, PHP, Perl, Swift, JavaScript… You can use for learning programming, scraping web sites, or writing batch
yadukrishna38 2021-09-11 18:40:55
mysql_en-12610.jpg
can someone help me on this?
piterden 2021-09-11 23:04:38
yadukrishna38 2021-09-11 18:40:55
can someone help me on this?

What is it?

2021-09-12 05:01:02
@Man_Like_Denzil @MasterZiv Pardon me, but how should we report spam bots on this group like the ones above? Is there a custom command for that?
piterden 2021-09-12 05:06:03
2021-09-12 05:01:02
@Man_Like_Denzil @MasterZiv Pardon me, but how should we report spam bots on this group like the ones above? Is there a custom command for that?

You can ping me, @MasterZiv (he is sleep right now) or @smlkw
Someone should be available

piterden 2021-09-12 05:06:49
Also that was not bots. Bots couldn’t pass the captcha
2021-09-12 05:07:34
piterden 2021-09-12 05:06:03
You can ping me, @MasterZiv (he is sleep right now) or @smlkw
Someone should be available

Thanks! 🙂

MasterZiv 2021-09-12 05:42:51
yadukrishna38 2021-09-11 18:40:55
can someone help me on this?

Send query as a text, please.

yadukrishna38 2021-09-12 10:04:55
Write a query to output the apartments whose prices are greater than the average and are also not rented, sorted by the ‘Price’ column.
yadukrishna38 2021-09-12 10:05:13
mysql_en-12632.jpg

Grv 2021-09-12 10:24:19
yadukrishna38 2021-09-11 18:40:55
can someone help me on this?

order by price is missing

yadukrishna38 2021-09-12 10:25:07
Grv 2021-09-12 10:24:19
order by price is missing

i didnt get u

Grv 2021-09-12 10:25:35
select * from table_name
where price > (select avg(price) from tst)
and status = ‘not rented’
order by price;
Amit Kumar 2021-09-12 18:51:33
Anyone having good architecture doc and PT DOC
Amit Kumar 2021-09-12 18:51:39
Kindly share if anyone
Web_official 2021-09-12 19:20:29
MasterZiv 2021-06-23 08:38:38
(!!!)
People this chat is not a kindergarten , we will not do your work instead of you.
Neither this is a school, we will not teach you.

Remind you, that any offtopic is removed without any warning and if the sender is re-sending, they will be banned.

In particular, MySQL and MSSQL (Microsoft SQL Server) are two different RDBMS, and MSSQL is offtopic.

can You (Admin) please explain the purpose of the group??

piterden 2021-09-12 19:25:03
Amit Kumar 2021-09-12 18:51:33
Anyone having good architecture doc and PT DOC

What is PT DOC?

Amit Kumar 2021-09-12 20:31:30
Performance tuning
2021-09-12 21:01:28
Web_official 2021-09-12 19:20:29
can You (Admin) please explain the purpose of the group??

Not an admin here,

but I guess it’s pretty clear: we’re a study group, we won’t make your homework or work for you, but we can guide you towards the answer so long as you provide a minimal working example of your faulty code alongside the error messages

MasterZiv 2021-09-12 22:14:00
Web_official 2021-09-12 19:20:29
can You (Admin) please explain the purpose of the group??

Get help?

Web_official 2021-09-13 01:57:01
2021-09-12 21:01:28
Not an admin here,

but I guess it’s pretty clear: we’re a study group, we won’t make your homework or work for you, but we can guide you towards the answer so long as you provide a minimal working example of your faulty code alongside the error messages

looks good and thanks for the Ans.

ruydar 2021-09-13 09:24:04
Hi
MySQL community server witch performance better on windows or Linux ?
piterden 2021-09-13 09:24:50
ruydar 2021-09-13 09:24:04
Hi
MySQL community server witch performance better on windows or Linux ?

It depends on configuration

MasterZiv 2021-09-13 09:25:39
ruydar 2021-09-13 09:24:04
Hi
MySQL community server witch performance better on windows or Linux ?

perf is same, but hardly you will find any hosting based on Windows.

ruydar 2021-09-13 09:26:41
MasterZiv 2021-09-13 09:25:39
perf is same, but hardly you will find any hosting based on Windows.

Which operating system is more stable and faster

piterden 2021-09-13 09:27:10
And even if you found, that will be only your troubles
piterden 2021-09-13 09:27:53
ruydar 2021-09-13 09:26:41
Which operating system is more stable and faster

OS which you know better

ruydar 2021-09-13 09:28:40
piterden 2021-09-13 09:27:53
OS which you know better

I do not know which is better

piterden 2021-09-13 09:29:23
I’m talking about your knowledge of operating systems
piterden 2021-09-13 09:31:00
ruydar 2021-09-13 09:28:40
I do not know which is better

Which OS do you know better than other?

ruydar 2021-09-13 09:31:51
piterden 2021-09-13 09:31:00
Which OS do you know better than other?

I think 🤔 Linux fast

Anjuman Nehal 2021-09-13 09:33:42
mysql_en-12660.jpg
Can anyone pls help me on this ?
|