Triggers

[gkav]

Hi,

I am totally new to SQL and am trying to do a simple DB.

What I would like to do is have a main table that contains all the information, than a second table that is auto populated when a new record is added to table 1 using triggers.

Then in the second table I would like to coconate two fields of different data types. I.e name and phone number.

Would anyone have any ideas how to go about this?

Thanks in advance

[ronverdonk]

Triggers are available in MySQL beginning with MySQL 5.0.2. For an ample explanation on this subject I have to direct you to the MySQL documentation. They can explain it much better then I can. Look at Using MySQL triggers

Ronald :cool: