Hi I have 2 environments, PROD and DEV
In DEV we are using:
1 x apache server (FE)
1 x mysql (BE) -8
PHP version : 7.3
PROD Environment:
1 x NGINX (FE)
1 x mysql (BE) 8
PHP Version 7.3
When I execute
Objectives :
Technical : execute the syntax without entering all the fields technical -Performance : by entering all the unused fields, it is acquiring 30 additonal bytes which i would like to reduce.
Alternatives :
By adding all the unused fields taking extra space how to avoid extra space, example: i have 7 fields in a table, but i want to insert 3 fields only in but in order to insert it is except all fields to fill which takes extra space. I am trying which not able to insert:
insert into emp(usrname, usrid) values('$usrname'.'$usrid');
which is working, but I don't want an extra field
insert into emp(usrname, usrid, location) values('$usrname','$usrid',' ');