Operand should contain 1 column(s) I'm getting this error while executing delete query

Question

this is my sql query

delete FROM 
SubMaster_test1 
where SubMasterId in (select * 
from SubMaster_test1 where AgentId 
not in (select distinct
introducer from SubMaster_test1 
where introducer is not null))

i'm getting following error

[Err] 1241 - Operand should contain 1 column(s)

Possible duplicate of [MySQL - Operand should contain 1 column(s)](http://stackoverflow.com/questions/14046838/mysql-operand-should-contain-1-columns) — , Jan 11 '17 at 08:46

score 0 · Accepted Answer · answered Jan 11 '17 at 08:45

0

you should wright only "id" on "*"

delete FROM 
    SubMaster_test1 
    where SubMasterId in (select SubMasterId
    from SubMaster_test1 where AgentId 
    not in (select distinct
    introducer from SubMaster_test1 
    where introducer is not null))

answered Jan 11 '17 at 08:45

krishn Patel

2,579
1
19
30

[Err] 1093 - You can't specify target table 'SubMaster_test1' for update in FROM clause... getting this error – anjali jibhakate Jan 11 '17 at 08:48
I know it.make a temp table with only one column with id and insert this SubMasterId into it then use this table to delete data – krishn Patel Jan 11 '17 at 08:57
insert into temp select SubMasterId from SubMaster_test1 where AgentId not in (select distinct introducer from SubMaster_test1 where introducer is not null) – krishn Patel Jan 11 '17 at 08:57
ok i have created the tem table and inserted the data... what next? – anjali jibhakate Jan 11 '17 at 09:26
delete FROM SubMaster_test1 where SubMasterId in (select id from temp) – krishn Patel Jan 11 '17 at 09:28
have you insert SubMasterId id only ? let me know if it's works – krishn Patel Jan 11 '17 at 09:29
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/132894/discussion-between-krishn-patel-and-anjali-jibhakate). – krishn Patel Jan 11 '17 at 09:51

Operand should contain 1 column(s) I'm getting this error while executing delete query

1 Answers1