0

I have two simple tables:

  • bazaa (ime VARCHAR(20),prezime VARCHAR(20))
  • bazab (ime VARCHAR(20),prezime VARCHAR(20))

Let's say bazaa contains 1 ime and 1 prezime and bazab contains 2 ime and 2 prezime.

I want to insert values into bazaa and those values should also be inserted into bazab but it shouldn't delete anything or mess up the positions of rows.

I tried with some triggers from answers on other questions but it doesn't work.

Any help would be much appreciated. Thanks.

Raidri
  • 17,258
  • 9
  • 62
  • 65
Sv1z3c
  • 1

1 Answers1

1

Try this

Insert into bazab select * from bazaa;
Sadikhasan
  • 18,365
  • 21
  • 80
  • 122