Add multiple conditional statement in insert query

Question

To ensure some form of referential integrity in Myisam (Mysql) I am trying to do updates and insert using subqueries. For example for updating I use this:

update tbl_a
set col_a='test'
where ID=22 and '2' IN (SELECT ID FROM tbl_b) and '33' IN (SELECT ID FROM tbl_c)

However the same principle for inserts doesn't work; it tried something like this:

insert into tbl_a
(
a,
b,
c
)
values
(
  now(),
  select ID from tbl_b where ID=2,
  select ID from tbl_c where ID=23
)

Any idea how to specify (multiple) conditions during insert?

thanks Patrick

@Strawberry What's wrong with that syntax? Seems ok to me.

ypercubeᵀᴹ
– ypercubeᵀᴹ

2013-07-12 11:14:17 +00:00
Commented Jul 12, 2013 at 11:14 — ypercubeᵀᴹ
– ypercubeᵀᴹ, Commented Jul 12, 2013 at 11:14

Vesper · Accepted Answer · 2013-07-12 11:03:46Z

1

Consider this approach:

insert into tbl_a (a, b, c)
select now(), b.id, c.id from tbl_b b, tbl_c c where b.id=2 and c.id=23

answered Jul 12, 2013 at 11:03

Vesper

18.8k6 gold badges41 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gustav Bertram Over a year ago

INSERT ... SELECT is probably the way to go. dev.mysql.com/doc/refman/5.1/en/insert-select.html

Vesper Over a year ago

@user2022678 If it worked, please accept this answer by pressing the "tick" at its left.

Collectives™ on Stack Overflow

Add multiple conditional statement in insert query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related