What is connection between both tables?

Interested

Is there any internship for data analysis or Sql.

Hello everyone!

Why i haven’t binary /usr/bin/mysqld_safe ?

Who knows

Are you interested in AWS, Devops ,Azure and GCP course training!
Dm me for more details

I am interested but is there any fees

Yes

Salary grade table

Emp table

#help#sql query #by using above two tables want output this pic

Hi all

I have a slave server for MySQL and to that slave only replicating one Database and few tables in that database

But when someone from my team trying create a procedure in other database on master

Statements tried to execute on slave also and throwing database not exist error

Slave SQL is stopping

Can anyone suggest and explain this

Hello everyone!

Why i haven’t binary /usr/bin/mysqld_safe ?

Who knows

I have production issue:
we did “alter table test add column varchar (16) null”
the column was added on the production but on replica i get this in the process list:
grouponi_groupon Connect 6701 Waiting for table metadata lock ALTER TABLE `tb_opportunity__deal_options` ADD `permanent_code` VARCHAR(16) NULL

it’s already like this more than 1.5 hour

Please help me, replication is lagging because this lock.

what is connection between both tables ?

Try without null

-> what does this symbol ro in linux

Anyone

Got answer

Above one bro

Have a doubt

there are three columns in a table event,user_id,time
none of them is a primary key
exmpl: user_id event time
4000 optin 04:03
4000 confirm 04:58
4000 react 05:50
8221 optin 06:56
6342 confirm 05:30
6342 optin 04:24

find user_id which contains only optin and not confirm

Any one from noida looking for php developer job.

create table test (user_id int,event text,
time text);

insert into test values
(4000,’optin’,’04:03′),
(4000,’confirm’,’04:58′),
(4000,’react’,’05:50′),
(8221,’optin’,’06:56′),
(8123,’react’,’07:10′),
(1234,’optin’,’08:17′),
(1234,’react’,’09:16′),
(6342,’confirm’,’05:30′),
(6342,’optin’,’04:24′);

select *
from test
where user_id in (
select distinct user_id
from test
where user_id not in
(select distinct user_id
from test
where event = ‘confirm’
)
and event = ‘optin’
)

Thank you soo much swapnil

But I’m getting react also

I need only optin

That was not mentioned explicitly in the requirement.

Anyway try below query

select distinct *
from test
where user_id not in
(select distinct user_id
from test
where event = ‘confirm’)
and event = ‘optin’

Yeah swapnil

It’s working