i need some help with a SQL alter command. i am trying to add a field to my table, but when i do the field is filled with null in any existing rows. how can i just make it fill blank like the value ...

insert into student1 (rollno, name, marks, age) values (107, "Gargi", 68, 100); alter table student1 change age stu_age INT; alter table student1 drop column stu_age; alter table student1 rename to ...

The ALTER TABLE command works by modifying the SQL text of the schema stored in the sqlite_schema table. No changes are made to table content for renames or column addition without constraints.