Add same values in two different tables

Question

I have two tables 'order' & 'new-order', i need to add same values in both these table by using a single line of code.

My code is as follows:-

/To add value in first Table/

mysql_query("insert into order (display, project, keyword) values ('$cname','$pro','$kwrd')");

/To add same value in second Table/

mysql_query("insert intoneworder(display, project, keyword) values('$cname','$pro','$kwrd')");

Now can i use some thing like this:-

mysql_query("insert into order && neworder (display, project, keyword) values ('$cname','$pro','$kwrd')");

and if not then what should be the correct one.

Karthik Surianarayanan · Accepted Answer · 2014-02-07 05:55:59Z

2

You can read more about it from the MySQL Manual. In short, you cannot insert into multiple tables at once. This leaves you with three options:

answered Feb 7, 2014 at 5:55

6263 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1