将主键值从一个表插入另一个表[关闭]

Question

i am new to mysql ,

i have an application in which i am getting dynamic values from mysql table say "TABLE A" into dropdown box, and want to insert this dropdown box value into another table say "TABLE B", while inserting want to insert related "primary key" value from "TABLE A" into "TABLE B".

can anyone give any sugessions or idea of how to do this.. thanks in advance for your reply.

Answer 1

From my understanding ,

i hope you 'd have the drop down values,

On insert you should use sub queries to select the id of values using where clause

Example:

   Insert into Table B (name ,id )values('name',(Select id from table A where Value==""))

Document for reference

Correct me if 'm wrong