Insert into two columns..help

[meena latha]

Hi.
I am stuck while doing an insert.
How do i insert value into two columns in the same table using a single insert

For Example

INSERT titles(title_id, title)
VALUES ('BU1237', 'Get Going!') where columnid='1234'

INSERT titles(title_id, title)
VALUES ('BU1237', 'Get Going!') where columnid='1235'

I need to insert the value into these two columns (columnid='1234'and columnid='1235')using a single insert.

Any suggestion on this is most welcomed.
Thanks

[Aiglee Castillo]

Hi,

What you are trying to do is:

INSERT titles(title_id, title)
VALUES ('BU1237', 'Get Going!') where columnid='1234' or columnid='1235'

?

Because you said:

need to insert the value into these two columns (columnid='1234'and columnid='1235')using a single insert.

But in your original query you are not doing that either.

[meena latha]

I need to insert the same value into both the rows whose columnid is 1234 and 1235 using a single insert.

So after the insert it will look like this.

columnid titles_id title
1234 BU1237 Get Going
1235 BU1237 Get Going

i dont wat to do this using two insert,rather my single insert should insert value into these two rows.

[Aiglee Castillo]

I need to insert the same value into both the rows whose columnid is 1234 and 1235 using a single insert.

So after the insert it will look like this.

columnid titles_id title
1234 BU1237 Get Going
1235 BU1237 Get Going

If you already have in your table the rows with columnid 1234 and 1235 then you should use:
update titles set title_id = "BU1237", title = "Get Going!" where columnid = "1234" or columnid = "1235"

Because insert will only work if you are inserting a new row, so you dont have those values in columnid. In that case you should use:
insert into titles (title_id, title, columnid) values ("BU1237","Get Going!","1234")
insert into titles (title_id, title, columnid) values ("BU1237","Get Going!","1235")
Two rows is not to much but if you need a lot more, then please give us more background about the problem.