Why do you need to have one query?

|
iatharva 2021-04-23 07:54:53
Deb_575 2021-04-23 07:53:37
What site is this?

Hacker rank

Deb_575 2021-04-23 07:55:58
iatharva 2021-04-23 07:54:53
Hacker rank

Ohk

Deb_575 2021-04-23 07:56:38
iatharva 2021-04-23 07:54:47
U didn’t discussed u r asking for answer

Right, @Singh_aryan post your solution and output let’s see if we can help

MasterZiv 2021-04-23 08:46:43
Singh_aryan 2021-04-23 06:04:17
Anyone please modify this query to get the solution.

Send code as text , please

Deb_575 2021-04-24 05:50:25
Probably the password provided is wrong
iatharva 2021-04-24 06:03:29
Deb_575 2021-04-24 05:50:25
Probably the password provided is wrong

Agree I think the same too

Curioustolearn 2021-04-24 09:31:15
Hi ! Can someone tell to me if it’s possible to get current logged username without host.
Commands like SELECT USER() SELECT CURRENT_USER() return username and host ( example: root@localhost).
I’m searching for a way to get as result “root” without “localhost” or any other host name.
piterden 2021-04-24 09:37:16
SELECT SUBSTR(USER(), 1, INSTR(USER(), “@”) – 1);
Curioustolearn 2021-04-24 09:47:07
piterden 2021-04-24 09:37:16
SELECT SUBSTR(USER(), 1, INSTR(USER(), “@”) – 1);

Thank you! It’s working.

Jamienash 2021-04-24 10:45:03
Hello everyone, I am a newbie, can someone recommed tutorial for startup?
Liran 2021-04-27 10:52:53
I am trying to configure basic master-Slave and ending up getting this error Slave_IO_Running: Connecting
svart 2021-04-28 08:33:34
Check last error in the slave status output and act accordingly
svart 2021-04-28 08:34:49
Usually the root cause either in a wrong password or port is not open for the replica
Th3c0d3b734ker 2021-04-28 09:18:52
https://filelisting.com/sans-collection-4e5338d177fe11b4b05fdb7591dcc7773448fc85.html

check this link out , in this website you can download all sorts of things, be it any course or movie ,etc

R J 2021-04-28 17:04:39
check out

https://databtale.blogspot.com/2021/04/monitoring-auto-increment-key-columns.html

MONITORING AUTO INCREMENT KEY COLUMNS IN MYSQLBlogspot
 Today, we are going to look into monitoring Auto Increment columns in MySQL Instance. Basically as a Database Administrator we should alw…
hdy1t 2021-05-04 14:55:30
Hello friends, i download mysql for my project but now i cannot click on the register mysql server button. What should i do? Thanks for any help..
hdy1t 2021-05-04 14:55:47
mysql_en-9523.jpg

piterden 2021-05-04 14:57:11
hdy1t 2021-05-04 14:55:30
Hello friends, i download mysql for my project but now i cannot click on the register mysql server button. What should i do? Thanks for any help..

You should start server and then connect to it with client

hdy1t 2021-05-04 15:01:23
mysql_en-9525.jpg
i am root. is it not enough?
piterden 2021-05-04 15:02:04
hdy1t 2021-05-04 15:01:23
i am root. is it not enough?

I don’t follow what you mean. Sorry

hdy1t 2021-05-04 15:03:47
I downloaded mysql and opened a new administrator like root
MasterZiv 2021-05-04 15:03:49
hdy1t 2021-05-04 14:55:47

This is not rdbms, it is client GUI, ask in their forum or chat

piterden 2021-05-04 15:04:25
hdy1t 2021-05-04 15:03:47
I downloaded mysql and opened a new administrator like root

Read documentation

hdy1t 2021-05-04 15:04:46
MasterZiv 2021-05-04 15:03:49
This is not rdbms, it is client GUI, ask in their forum or chat

Rdbms?

piterden 2021-05-04 15:05:11
https://www.google.com/search?q=rdbms&oq=Rdbms&aqs=chrome.0.0l10.1215j0j4&sourceid=chrome&ie=UTF-8

rdbms – Google SearchGoogle
hdy1t 2021-05-04 15:05:30
Yep got it
hdy1t 2021-05-04 15:05:37
Thank you for your time
piterden 2021-05-04 15:06:20
hdy1t 2021-05-04 15:05:37
Thank you for your time

Come when you will get more knowledge and meet a problem

MasterZiv 2021-05-04 15:21:21
hdy1t 2021-05-04 15:04:46
Rdbms?

It’s not MySQL , it’s a client

Deb_575 2021-05-05 11:16:39
why do you need to have one query?
simply delete whatever you want from the two tables
Deb_575 2021-05-05 11:17:26
delete from table_name where column_name = <value>;
that is the syntax
iatharva 2021-05-05 11:17:56
Specific data or all data?
Deb_575 2021-05-05 11:19:04
DELETE t1, t2 FROM t1 INNER JOIN t2 ON t1.id = t2.id;
iatharva 2021-05-05 11:19:17
Deb_575 2021-05-05 11:19:04
DELETE t1, t2 FROM t1 INNER JOIN t2 ON t1.id = t2.id;

Precisely

Deb_575 2021-05-05 11:20:34
Deb_575 2021-05-05 11:19:04
DELETE t1, t2 FROM t1 INNER JOIN t2 ON t1.id = t2.id;

this is the query to delete from two tables using inner join give it a try

|