I've been having this problem for a while and I cant find a fix around it now matter how hard I search. Basically in the old mysql I could assign a value to a text field automatically or I could just leave it blank now all that has changed.

When i do a query such as insert into `whatever` (`column1`) values ('whatever')
It will not work if I have any other columns which are text fiends in the same table. So for example column2 is a text field and column3 is a varchar but because I didn't specifically assign values to them during my query, the entire query will fail. Is there any way around this. It becomes a big issue if I wish to change my database structure later. Adding just 1 extra field will make my entire site unable to function until I change every single insert query. There has to be a way around this, I'm almost 100% sure that the guys behind MySQL are not stupid enough to miss this issue.