posted 9 years ago
its like this my student_register table have regNo as primary key and sDay and name & more
in the same database i have semester table is primary key is also regNo and same columns (name / joint_date ) in the [u] sem table [/u]this common columns must update by single query is it possible and is their are any methods to do that plaz enlighten me
sql ="INSERT INTO student_register (regNo,name,sname,idNo,age,birthD,gen,national,relegion,fee,institute,pro,sDay,eMail,phnNo,address,img) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" ;
sqlSem="INSERT INTO sem (id,name,cu rSem,startDate,semEnd)VALUES(?,?,?,?,?)";