Can I use aliases in an INSERT statement?

Question

Can we use aliases with insert into syntax?

None of the following work:

INSERT INTO tableblabla AS bla
INSERT INTO bla tableblabla
INSERT INTO tableblabla bla

I can't seem to find any information about this; is there a valid way to use aliases in an INSERT statement?

About the possible reasons: http://bugs.mysql.com/bug.php?id=3275

Thanks in advance,
MEM

Answer 1

The INSERT syntax doesn't allow for aliases. Why would you need one in an INSERT statement anyways? You can only INSERT into one table at a time.