O'Reilly logo

Building a Web Application with PHP and MariaDB: A Reference Guide by Sai Srinivas Sriparasa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The students table

Let us take a look at the following fields in the table and what work they perform:

Column name

Datatype

Comments

student_id

Int

This stores the unique identifier for a student

first_name

Varchar(60)

This stores the first name of the student

last_name

Varchar(60)

This stores the last name of the student

address

Varchar(255)

This stores the address of the student

city

Varchar(45)

This stores the name of the city

state

Char(2)

This stores the two letter abbreviation for states in the United States

zip_code

Char(5)

This stores the five digit zip code for an address in the United States

Note

It is advised to use a character datatype for fields such as zip codes or SSNs. Though the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required