hello guys...i have a class table in which there are two fields class_id and class_name and a student form in which there is a text field in which user will mention the student class and then hit add.this will retrieve class_id from class table instead of class name into student table.i want to retrieve the id of specfic field from one table and put it in the other table...is this possible with mysql queries to retrieve specfic id of the field from one table and input it into anonther table.if so please let me known.hope you understand my explaintion of my problem
Jump to Post
You mean like:
insert student(classId) select classId from class where...
All 5 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.