Posts: 415
Threads: 145
Joined: Oct 2013
Reputation:
0
Why is newbienoob saving to mysql table variable ID in his tut? For what is it needed?
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation:
0
Searching through numbers is much faster than searching through text. It also comes into play when creating relations to different tables (yes, MySQL is a relational database!). You want to avoid duplicate data at all costs. Duplicating the name into different tables is a terrible practice. Other than that, the name may be changed. The ID won't.