Why do you need it?

|
Ryukkkkkk 2020-07-29 08:32:49
Message me in private please if anybody knows about schemas in dbms
Ryukkkkkk 2020-07-29 08:43:42
mysql_en-4898.jpg

Ryukkkkkk 2020-07-29 08:43:54
I need answers for this please help
piterden 2020-07-29 13:56:19
Ryukkkkkk 2020-07-29 08:43:54
I need answers for this please help

Why do you need it?

2020-07-30 08:21:14
I have a data.sql file
2020-07-30 08:21:20
how to open it
2020-07-30 18:53:34
mysql_en-4909.jpg

2020-07-30 18:53:48
how to add row name ->status using sql command
piterden 2020-07-30 18:57:04
2020-07-30 18:53:48
how to add row name ->status using sql command

ALTER TABLE statement

2020-07-31 17:00:31
hello 🙂 need some help with passing 2 html date input values to php files sql query. :/ sorry for disturbing
2020-08-01 16:07:24
anybody here ?
2020-08-01 16:08:03
i’ve upgraded to a higher version of mysql & php. now by form isn’t inserting to db :/
2020-08-01 16:08:07
any help plz
2020-08-01 17:29:00
2020-08-01 16:08:03
i’ve upgraded to a higher version of mysql & php. now by form isn’t inserting to db :/

Inbox me

2020-08-01 17:29:09
thanks 🙂
R J 2020-08-02 20:04:36
2020-08-01 16:08:03
i’ve upgraded to a higher version of mysql & php. now by form isn’t inserting to db :/

What is an error

2020-08-02 21:49:02
R J 2020-08-02 20:04:36
What is an error

Error resolved but now he has php error

R J 2020-08-02 21:53:10
Ohh okay
2020-08-02 21:59:17
Hey guys .. I have table with dups record ..dups recording is according to all columns except create dt which could be same or different..
Need to delete dups record

I wrote

DELETE FROM table T
USING (
SELECT C1,
C2
,CREATE_DT
,ROW_NUMBER() OVER (PARTITION BY C1,C2 ORDER BY CREATE_DT DESC) AS RANK_VALUE
FROM Table T
) X
WHERE X.RANK_VALUE <> 1
AND T.c1 = X.c1
And t.c2=x.c2
AND T.CREATE_DT = X.CREATE_DT

2020-08-02 22:00:29
2020-08-02 21:59:17
Hey guys .. I have table with dups record ..dups recording is according to all columns except create dt which could be same or different..
Need to delete dups record

I wrote

DELETE FROM table T
USING (
SELECT C1,
C2
,CREATE_DT
,ROW_NUMBER() OVER (PARTITION BY C1,C2 ORDER BY CREATE_DT DESC) AS RANK_VALUE
FROM Table T
) X
WHERE X.RANK_VALUE <> 1
AND T.c1 = X.c1
And t.c2=x.c2
AND T.CREATE_DT = X.CREATE_DT

Now issue is it’s deleting records where we are having duplicate create date as well.. without taking single record of such duplicates

2020-08-02 22:02:19
It should have retain one record before deleting dups .. it’s working fine when we have dups in all column except create date column
2020-08-03 03:43:31
Jyoti can you understand above issue, @Raj12x it’s not clear to me
2020-08-03 06:15:45
2020-08-03 03:43:31
Jyoti can you understand above issue, @Raj12x it’s not clear to me

I meant if there are 2 records of duplicate value across all columns it should have retained one record which is not happening

R J 2020-08-03 06:51:10
2020-08-03 03:43:31
Jyoti can you understand above issue, @Raj12x it’s not clear to me

Sure

2020-08-03 07:25:29
R J 2020-08-03 06:51:10
Sure

Thanks jyoti

R J 2020-08-03 10:15:49
MySQL Administration
Here You will be able to learn all about MySQL Administration. Note: This channel is created only for learning purpose
https://t.me/mysqladministration

MySQL AdministrationTelegram
Here You will be able to learn all about MySQL Administration. Note: This channel is created only for learning purpose
2020-08-03 11:38:30
2020-08-02 21:59:17
Hey guys .. I have table with dups record ..dups recording is according to all columns except create dt which could be same or different..
Need to delete dups record

I wrote

DELETE FROM table T
USING (
SELECT C1,
C2
,CREATE_DT
,ROW_NUMBER() OVER (PARTITION BY C1,C2 ORDER BY CREATE_DT DESC) AS RANK_VALUE
FROM Table T
) X
WHERE X.RANK_VALUE <> 1
AND T.c1 = X.c1
And t.c2=x.c2
AND T.CREATE_DT = X.CREATE_DT

Anyone any help?
Please

2020-08-03 11:42:21
2020-08-03 11:38:30
Anyone any help?
Please

Can you show the actual data and what you want to achive (resultant data) in image/table format

2020-08-03 11:42:30
Then maybe i can help you.
2020-08-03 11:42:53
Or DM if future needs to discus.
MasterZiv 2020-08-08 17:53:17
2020-08-02 21:59:17
Hey guys .. I have table with dups record ..dups recording is according to all columns except create dt which could be same or different..
Need to delete dups record

I wrote

DELETE FROM table T
USING (
SELECT C1,
C2
,CREATE_DT
,ROW_NUMBER() OVER (PARTITION BY C1,C2 ORDER BY CREATE_DT DESC) AS RANK_VALUE
FROM Table T
) X
WHERE X.RANK_VALUE <> 1
AND T.c1 = X.c1
And t.c2=x.c2
AND T.CREATE_DT = X.CREATE_DT

You should give much more details on this for one to be able to help you…

DDL, sample data, what you need to delete and to leave interact…

Z78901 2020-08-08 19:44:13
mysql_en-4986.jpg
Hii..I was trying to execute this store procedure to get the details of an user if the username and password is there. I created a store procedure for it when I try to execute store procedure always it is showing 0 rows affected , anyone please help me with this
Z78901 2020-08-08 19:44:51
Everytime time I run this store procedure it is showing 0 rows affected
Master Yoda 2020-08-08 19:46:52
Z78901 2020-08-08 19:44:51
Everytime time I run this store procedure it is showing 0 rows affected

It does just select

Master Yoda 2020-08-08 19:46:59
What do you want?
Z78901 2020-08-08 19:48:17
When I use sql query directly without store procedure it is working perfectly but when I use store procedure it is showing this
Z78901 2020-08-08 19:48:26
I want to run it with store procedure
MasterZiv 2020-08-08 20:08:11
Z78901 2020-08-08 19:44:51
Everytime time I run this store procedure it is showing 0 rows affected

Take the query out and debug applying same parameter values.
Then put back into the procedure

Z78901 2020-08-08 21:19:39
MasterZiv 2020-08-08 20:08:11
Take the query out and debug applying same parameter values.
Then put back into the procedure

Bro it get worked

Mahendra Seth 2020-08-09 18:57:51
Z78901 2020-08-08 19:44:13
Hii..I was trying to execute this store procedure to get the details of an user if the username and password is there. I created a store procedure for it when I try to execute store procedure always it is showing 0 rows affected , anyone please help me with this

Remove @ it will work fine

Mahendra Seth 2020-08-09 18:58:08
From store procedure variable name
Mahendra Seth 2020-08-09 18:58:24
Because you are already passing in the procedure
Mahendra Seth 2020-08-09 18:58:49
You have already declared
MasterZiv 2020-08-09 21:52:13
Mahendra Seth 2020-08-09 18:58:08
From store procedure variable name

No, @ is quite ok in variable name in mySQL

MasterZiv 2020-08-09 21:53:24
Z78901 2020-08-08 19:44:13
Hii..I was trying to execute this store procedure to get the details of an user if the username and password is there. I created a store procedure for it when I try to execute store procedure always it is showing 0 rows affected , anyone please help me with this

But you are correct, variable names are different.

prasannabalaji03 2020-08-10 07:23:48
Hi team ., Any link for 2 node group replication and cluster
prasannabalaji03 2020-08-10 07:23:53
MySQL 8
prasannabalaji03 2020-08-10 07:24:48
More hands on cluster ., How to rebuild cluster and bootstrap MySQL router .,
prasannabalaji03 2020-08-10 07:25:56
Cross chrcked on the MySQL administration group ., Not available
MasterZiv 2020-08-10 10:21:35
Hello,guys, have some questions about mysql_innodb_cluster. if you reboot one of servers or some power outage issue cause one of mysql server down, how did you put mysql_innodb_cluster up automatically? 2.i am not understand mysql innodb cluster HA, is there hava multiple matser solutions for mysql innodb mysql, could u pls give some link, thanks
|