Example:
INSERT INTO staff( firstName, lastName, address, homePhone, cellPhone, latitude, longitude )
SELECT firstName, lastName, address, homePhone, cellPhone, latitude, longitude
FROM gfxContact
Example:
INSERT INTO staff( firstName, lastName, address, homePhone, cellPhone, latitude, longitude )
SELECT firstName, lastName, address, homePhone, cellPhone, latitude, longitude
FROM gfxContact
I read about “database normalization” today in the book “PHP Essentials”, which introduces three of the five (?) “normal forms”. I don’t quite get it but I am glad that I came across it:)
I got some similar articles when smart googling “database normalization”. Here are some of them: