469,931 Members | 1,831 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,931 developers. It's quick & easy.

Triggers

1
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
Dec 20 '06 #1
1 1238
ronverdonk
4,258 Expert 4TB
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:
Dec 22 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by raulgz | last post: by
1 post views Thread by jason_s_ford | last post: by
4 posts views Thread by Mark Flippin | last post: by
1 post views Thread by tim.pascoe | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
4 posts views Thread by --CELKO-- | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.