Can I change the insert column names order?

Question

And if I change the INSERT INTO columns names? Go work?

ie: I have the following column names order: 'Name | Lastname | Age'. Can I change this, in INSERT statement, to 'Lastname | Name | Age'?

Answer 1

I found it is possible. In next lesson I learned if I change the values order, it works fine!

ie.

INSERT INTO (Lastname, Name, Age)
VALUES ('Lyrio Dalto', 'Franco', 35);