So i have tried inserting the values without mentioning the column name in the code..
After some searching, I have found that it is possible by passing the value as null as mentioned here.But when I did it, it threw some errors.
The code i have used
CREATE TABLE Persons
ID int NOT NULL AUTO_INCREMENT,
LastName varchar(255) NOT NULL,
PRIMARY KEY (ID)
insert into Persons values (NULL,1);
If this is just for experimental purposes yes you can:
INSERT INTO Persons VALUES (NULL, 'Lastname', 'Firstname', 'Address test', 'city of angels');
But I strongly urge you to not make it a habit of doing this. Always add columns, as eloquently stated by David's answer.
INSERT INTO Persons (LastName, FirstName, Address, City) VALUES ('Last', 'First', 'Add', 'City');