September 2017
Intermediate to advanced
244 pages
6h 44m
English
A users table can have the following fields:
id: It will have type integer, which will be unique and will have auto-incremented values. id will be the primary key of the users table.
name: It will have type VARCHAR with a length of 100 characters. In the case of VARCHAR 100, 100 characters is the limit. If the title in one entry will be less than 100 characters, let's say only 13 character's, then it will occupy 14 characters space. This is how VARCHAR works. It occupies one character more than the actual characters in the value.
email: Email address will have type VARCHAR with a length of 50. And the email field will be unique.
password: Password will have type VARCHAR with a length of 50. We will be ...
Read now
Unlock full access