Menu
Hello.
I’ve got this question. I have a database with one table ‘users’. Under these is a lot of columns, with almost 200+ records(rows).
Now my problem is I added a new field ‘elem_course’ and ‘high_course’. Of course it’s empty. Now I want all my records to have the value of “Primary” for the ‘elem_course’ and “Secondary” for the ‘high_course’?
How can I do this in SQL or PHP? I’m asking because I’m tired of editing all of them one by one in phpmyadmin of XAMPP ?
Thanks.