MySQL saving "ID" to the table
#1

Why is newbienoob saving to mysql table variable ID in his tut? For what is it needed?
Reply
#2

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.
Reply
#3

I was just wondering if I cant just use check for names but now I know through numbers its faster.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)