Archive for May, 2006

How to copy columns from one table into another table

May 8, 2006

Example:

INSERT INTO staff( firstName, lastName, address, homePhone, cellPhone, latitude, longitude )
SELECT firstName, lastName, address, homePhone, cellPhone, latitude, longitude
FROM gfxContact

Advertisements

Data normalization

May 6, 2006

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: