How do I do a MySQL Insert statement into 2 different tables?

Asked by fuze (17) January 28th, 2007

For instance, I want to do this: ------------- table A ------------- red blue ------------- table B ------------- apple blueberry and I want to insert Orange into table A and Carrot into table B.