how to insert records in 2 mysql tables

Question

I'm trying to insert records on multiple mysql tables with similar entities(a normalized table) I tried to do this but I get an error. I've also seen joins but it seems to work only when retrieving data.

      insert into t1(pnum, hospnum) values('117', '656')
      insert into t2(TELNUM, HOSPNUM) values('9981235', '676')

Answer 1

I suspect your fields are numbers not strings, try this:

insert into t1(pnum, hospnum) values(117, 656)
insert into t2(TELNUM, HOSPNUM) values(9981235, 676)

No need to use quotes for numbers otherwise you will get an error.

Answer 2

If you are executing these statements in a batch, you may need a semicolon to separate/terminate them:

insert into t1(pnum, hospnum) values(117, 656);
insert into t2(TELNUM, HOSPNUM) values(9981235, 676);

Answer 3

MySQL does not support a statement that inserts into two different tables.

The only option is to use a trigger on t1 that inserts to t2, but of course you don't have access to the telnum value in a trigger; you only have the columns of t1. So this won't work in your situation.

You must execute the two inserts as separate SQL statements.