Select query as a vaule in mysql query

Question

0.00/5 (No votes)

See more:

I have two tables tb1 and tb2

there are four column in tb1 tb1c1,tb1c2,tb1c3,tb1c4

and three column in tb2

tb2c1,tb2c2,tb2c3

when i am inserting values into the tb1 then I want tb2c2 containt as value into the tb1c3 field

I though to do something like follows:

SQL

insert into tb1(tb1c1,tb1c2,tb1c3,tb1c4) values('1','2',select tb2c2 fromtb2 where tb1c1=1)

please help me in this query

What I have tried:

I have two tables tb1 and tb2

there are four column in tb1 tb1c1,tb1c2,tb1c3,tb1c4

and three column in tb2

tb2c1,tb2c2,tb2c3

when i am inserting values into the tb1 then I want tb2c2 containt as value into the tb1c3 field

I though to do something like follows:

SQL

insert into tb1(tb1c1,tb1c2,tb1c3,tb1c4) values('1','2',select tb2c2 fromtb2 where tb1c1=1)

please help me in this query

Posted 21-Apr-16 1:25am

Kishor-KW

Updated 21-Apr-16 1:55am

v3

Add a Solution

Comments

Herman<T>.Instance 21-Apr-16 7:38am

try this:
insert into tb1(tb1c1,tb1c2,tb1c3,tb1c4) values('1','2',(select tb2c2 fromtb2 where tb1c1=1))

Kishor-KW 21-Apr-16 7:47am

yep,it's working thanx

Kishor-KW 21-Apr-16 8:08am

yes it is woking but it returns more than one value in my case it returns 5 values it may be vary from 5 to 200 now how to handle this?
Thanx for reply

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2016-04-21T01:55:00

Solution 1

Digimanus gave you one way, personally I think that is a bad format to do it in. I suggest doing it similar but like this:

SQL

insert into tb1(tb1c1,tb1c2,tb1c3,tb1c4) 
SELECT '1','2', tb2c2, someValue
from tb2 
where tb1c1=1

Note you still need something for tblc4 but you didn't have anything in your code you posted.

Posted 21-Apr-16 1:55am

ZurdoDev

Comments

Kishor-KW 21-Apr-16 8:29am

its giving a error of syntax did you missed the values key word?

ZurdoDev 21-Apr-16 8:38am

No, see http://dev.mysql.com/doc/refman/5.7/en/insert-select.html