Anthony Galpo Anthony Galpo - 7 months ago 9
PHP Question

Inserting a value into all rows in the column in php

Table

I wanted to overwrite all the values in the

Project1
column with
0
. Is there a way to do this ? Like all the students in
studentid
will all have
0
values in
Project1
.

Answer

You have to use an update query.

For your example:

UPDATE `TABLE_NAME` SET `Project1` = 0
Comments