Question

How can I insert the values in columns without specifying the names of the column in MySQL INSERT INTO statement?

Answer 1

create table abc(name varchar(20), age int(2));
insert into abc values ( "xyz", 2);