Hello i have this sql structure
Rows( ID ,CLASS, DURATION ,CREDIT ,PROFESSOR ,STUDENT) there are many rows in the same structure just different ID and data. I am using java and im trying to make a sql query where students can input one class ID and when press submit their name is added on the STUDENT. So basically the STUDENT i want it to he always updated by having names added not replaced. Is it possible to do it? I tried to make a query that looks like this string sql = INSERT INTO CS (STUDENTS) WHERE ID = x VALUES(student_name);
Is it possible to be made such thing?
Thank you in advance.