Why ";" doesnt work in MySQL?!!!!?

Question

I'm trying to use this command:
select * from table1; insert into table1('c1') values('asd');
but it shows me an error:
Failed to execute query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; insert into table1(\'c1\') values(\'asd\')'

Answer 1

The problem isn't with the;.

If you run the commands separately, you'll get an error with the insert into table1 part.

Take the single quotes away from the column name (c1) and it should work for you.

select * from table1; insert into table1(c1) values('asd');

Answer 2

execute them one at a time, one after the other, in two separate commands.

Answer 3

who knows lol