Php - alter table column after insert

Question

is it possible adding a column into a database table after an insert? If yes kindly give me an example code for it i don't know how to make of it

Answer 1

yes it is possible for example :

CREATE TABLE my_table (
     id         integer(10),
     fname  varchar(50) );

and insert the values :

INSERT INTO `my_table`(`id`, `fname`) VALUES (1,'edverd');

see the value is added here

NOW Alter the Table

ALTER TABLE my_table ADD COLUMN lname varchar(50);

see the table is altered here

but the values in the added column will be null for every row present in that table.

now you can simply add the values in the added column

INSERT INTO `my_table`( `lname`) VALUES ('cullen');

Answer 2

To Answer Your Question: Yes you totally can.Just an FYI Insert Is basically Creating a Brand New row.(If there is something already present in the row You use UPDATE) to add Column to the database the syntax remains the same, if you are using mysql this is something your code should look like

$query="ALTER TABLE Users ADD COLUMN PASSWORD VARCHAR(100)";
$result= $mysqli->query($query);
if(!$result) echo "Failed to Add column TO The database";

BUT: 1.What you are trying to do isn't a good practice. 2.Read More about Php, You can get a course on udemy or just buy books on Php one of which is Learning PHP MYsql and Javascript By Robin Nixon, or just read more from the php manual, or mysql manual. 3.Nobody is Rude here, but lack of effort is something nobody appreciates. 4.Lastly don't get disheartened,Work Hard