Is using Natural Join or Implicit column names not a good practice when writing SQL in a programming
- by Jian Lin
When we use Natural Join, we are joining the tables when both table have the same column names. But what if we write it in PHP and then the DBA add some more fields to both tables, then the Natural Join can break?
The same goes for Insert, if we do a
insert into gifts values (NULL, "chocolate", "choco.jpg", now());
then it will break the code…