Do you know any bots to remove such spam?

|
Harish Kunte 2022-07-01 20:30:57
Hey any one tell me basic to advance MySQL
Sonali 2022-07-01 21:00:36
a. Write function that takes the customernumber as input and returns the purchase_status based on the following criteria.[table:Payments]

If the total purchase amount for the customer is <25000 status=silver, amount between 25000 and 50000 status= Gold, amount>50000 status= Platinum.

b. Write a query that displays customernumber, customername and purchase_status from customers table.

Sonali 2022-07-01 21:00:53
Sonali 2022-07-01 21:00:36
a. Write function that takes the customernumber as input and returns the purchase_status based on the following criteria.[table:Payments]

If the total purchase amount for the customer is <25000 status=silver, amount between 25000 and 50000 status= Gold, amount>50000 status= Platinum.

b. Write a query that displays customernumber, customername and purchase_status from customers table.

Can someone pls help me out with this question?

Swapnil 2022-07-01 21:08:54
Sonali 2022-07-01 21:00:36
a. Write function that takes the customernumber as input and returns the purchase_status based on the following criteria.[table:Payments]

If the total purchase amount for the customer is <25000 status=silver, amount between 25000 and 50000 status= Gold, amount>50000 status= Platinum.

b. Write a query that displays customernumber, customername and purchase_status from customers table.

Refer below link to get an idea as in how function is created in MySQL
https://www.mysqltutorial.org/mysql-stored-function/

MySQL Stored Function By Practical ExamplesMySQL Tutorial
In this tutorial, you will learn how to create MySQL stored functions by using the CREATE FUNCTION statement.
Swapnil 2022-07-01 21:09:37
If still you face an issue do let me know
Sonali 2022-07-01 21:11:11
Swapnil 2022-07-01 21:09:37
If still you face an issue do let me know

Sure Thank you!

Asrar 2022-07-02 00:01:29
How to use Group_concat() with concat()/concat_ws() to aggregate data from multiple columns.
I have been able to achieve above by select id group_concat(concat_ws(‘,’, col1,col2,col3)) group by id

However I’m not able to obtain consistent 3 values seperated by comma when null/empty values are present in the multiple columns.

Swapnil 2022-07-02 00:02:42
Asrar 2022-07-02 00:01:29
How to use Group_concat() with concat()/concat_ws() to aggregate data from multiple columns.
I have been able to achieve above by select id group_concat(concat_ws(‘,’, col1,col2,col3)) group by id

However I’m not able to obtain consistent 3 values seperated by comma when null/empty values are present in the multiple columns.

May be you can use coalesce to avoid null

Asrar 2022-07-02 00:04:13
i need null/empty values
Swapnil 2022-07-02 00:04:44
Asrar 2022-07-02 00:04:13
i need null/empty values

can you give some example ?

Asrar 2022-07-02 00:08:33
don’t have an example handy..It is a one to many relationship case
Alejandro 2022-07-02 04:56:31
Asrar 2022-07-02 00:01:29
How to use Group_concat() with concat()/concat_ws() to aggregate data from multiple columns.
I have been able to achieve above by select id group_concat(concat_ws(‘,’, col1,col2,col3)) group by id

However I’m not able to obtain consistent 3 values seperated by comma when null/empty values are present in the multiple columns.

did you ever tried change those values (null, “”) with a specific value, something like 00001
IF ( ColA = “” OR ColA IS NULL, “00001”.ColA) and after that use Concat to marge all the data?

Alejandro 2022-07-02 04:58:37
or
Alejandro 2022-07-02 04:59:19
IF ( ColA = “” OR ColA IS NULL, CONCAT( “00001”,ColB) . CONCAT(ColA,ColB) )
Asrar 2022-07-02 10:24:58
Alejandro 2022-07-02 04:56:31
did you ever tried change those values (null, “”) with a specific value, something like 00001
IF ( ColA = “” OR ColA IS NULL, “00001”.ColA) and after that use Concat to marge all the data?

Thanks Alejandro.. Will try…👍.. I tried IFNULL but not “”.I will try.

Swapnil 2022-07-02 10:36:31
Stop promoting this vague trading things here in this group
Swapnil 2022-07-02 10:36:39
Admin plz take necessary action
smlkw 2022-07-02 10:38:00
Swapnil 2022-07-02 10:36:31
Stop promoting this vague trading things here in this group

do you know any bots to remove such spam?

Swapnil 2022-07-02 10:38:45
smlkw 2022-07-02 10:38:00
do you know any bots to remove such spam?

AFAIK, Bots are still not able to recognize weather the person is spammer or not

smlkw 2022-07-02 10:41:24
Swapnil 2022-07-02 10:38:45
AFAIK, Bots are still not able to recognize weather the person is spammer or not

Then ping me if one will appear here again

Thanks for the above ping

Swapnil 2022-07-02 10:55:48
smlkw 2022-07-02 10:41:24
Then ping me if one will appear here again

Thanks for the above ping

Thanks for quick response.
And yes will definately let you know

Dude 2022-07-02 12:10:13
Dear all.
A question about replication.
I have two slaves for a same master.
Updated a bunch of inserts on master (50k).
One slave had no delay whereas other lagged 200 seconds.
Please help me understand what could be the reasons.
Swapnil 2022-07-02 12:35:19
Dude 2022-07-02 12:10:13
Dear all.
A question about replication.
I have two slaves for a same master.
Updated a bunch of inserts on master (50k).
One slave had no delay whereas other lagged 200 seconds.
Please help me understand what could be the reasons.

Are both slaves in same region ?

Dude 2022-07-02 13:32:42
Yes. Aws Mumbai
Swapnil 2022-07-02 14:58:08
Dude 2022-07-02 13:32:42
Yes. Aws Mumbai

same config ?

Gauravprajapati1999 2022-07-02 17:41:38
https://youtu.be/aqw2T04b2GA

How to apply for provisional degree certificate online at Jiwaji University || Gaurav PrajapatiYouTube
How to apply for provisional degree certificate online at Jiwaji University || Gaurav Prajapati || Speed Technology

In this video we will tell you that you will tell all the process from start to payment for your degree.

Click on the given link for degree : – https://jiwaji.mponline.gov.in/portal/Services/Jiwaji/NewCBS/frmCounterBase.aspx

Don’t forget to like ,comment share & Subscribe…..!!!!
Share, Support, Subscribe ….!!!!
==============================
YouTube Channel Subscribe Now :-
https://www.youtube.com/channel/UC0zC2yXG8AKoBPYdRBionHg
==============================
Follow Me On Facebook Page :-
https://www.facebook.com/speedtechnology22
==============================
Follow Me On GitHub :-
https://github.com/Gauravprajapati1999
==============================
Follow Me On Twitter Account :-

===============================
Follow Me On Blogging :-
https://gauravprajapati.hashnode.dev/
===============================

For business inquiries : – Saurabhprajapati636@gmail.com

About : – Speed Technology is a YouTube Channel, where you will find technology videos in Hindi, New Video is Posted Everyday 🙂

🔥 Please Like, Subscribe & Share! ❤️
🔥Thank you ! ❤️

Gauravprajapati1999 2022-07-02 17:42:07
Please Subscribe my YouTube Channel Friends Please Help
Gauravprajapati1999 2022-07-02 17:43:06
https://youtu.be/1M3XuSpRT3E

How to create table in MySQL tutorial in Hindi #mysqltutorials #mysql #viralvideo #TechnicalaliabaYouTube
Gauravprajapati1999 2022-07-02 17:43:29
Please Subscribe My YouTube channel
Dude 2022-07-02 21:40:26
Swapnil 2022-07-02 14:58:08
same config ?

I just noticed that one slave has slave parallel workers 4..
The other one zero.
Could this could be a reason.

We have binlog replication setup with row format

Swapnil 2022-07-02 22:02:31
Dude 2022-07-02 21:40:26
I just noticed that one slave has slave parallel workers 4..
The other one zero.
Could this could be a reason.

We have binlog replication setup with row format

Yes that can be the reason

Sandip Londhe 2022-07-03 08:53:46
Swapnil can you tell some real time situation where we can use store procedures
Sandip Londhe 2022-07-03 13:20:57
mysql_en-22392.jpg

Sandip Londhe 2022-07-03 13:21:06
Find the number of apartments per nationality that are owned by people under 30 years old.
Output the nationality along with the number of apartments.
Sort records by the apartments count in descending order.
Gauravprajapati1999 2022-07-03 14:05:57
https://youtu.be/k5kJfKhIdQc

How To INSERT Record In MySQL Database Table Using Command | MySQL Tutorial – 2 #mysqltutorialsYouTube
इस वीडियो में हम एक वीडियो में पूरा MySQL/sql सीखने जा रहे हैं।
हम मूल बातें और साथ ही MySQL की अग्रिम अवधारणाओं को शामिल करेंगे।

एक वीडियो में mysql सीखें
हिंदी में mysql
एक वीडियो में mysql हिंदी में
php mysql हिंदी में
एक वीडियो में मास्टर mysql
हिंदी में एक वीडियो में मास्टर mysql
एक वीडियो में mysql कदम दर कदम
1 घंटे में mysql
हिंदी में mysql सीखें 2020
एक वीडियो में mysql ट्यूटोरियल
mysql ट्यूटोरियल हिंदी में
एक वीडियो में mysql ट्यूटोरियल हिंदी में
Don’t forget to like ,comment share & Subscribe…..!!!!
Share, Support, Subscribe ….!!!!
==============================
YouTube Channel Subscribe Now :-
https://www.youtube.com/channel/UC0zC2yXG8AKoBPYdRBionHg
==============================
Follow Me On Facebook Page :-
https://www.facebook.com/speedtechnology22
==============================
Follow Me On GitHub :-
https://github.com/Gauravprajapati1999
==============================
Follow Me On Twitter Account :-

===============================
Follow Me On Blogging :-
https://gauravprajapati.hashnode.dev/
===============================

For business inquiries : – Saurabhprajapati636@gmail.com

About : – Speed Technology is a YouTube Channel, where you will find technology videos in Hindi, New Video is Posted Everyday 🙂

🔥 Please Like, Subscribe & Share! ❤️
🔥Thank you ! ❤️

|