Best Data Types

[F_Danials]

Hello,

I'm new to databases and MySQL, and would very much like to know, what the most efficient/suitable Data Types would be used with the following data:?

Account Details:

• Email Address

• Password

• Email Updates?

• Interested Sites (6 Check Boxes Max)

Personal Details:

• Title (Mr, Mrs, Miss, Ms, Dr)

• First Name

• Last Name

• Image Title

• Upload Image

Address:

• Property Name/Number

• Street Name

• Location

• Town/City

• Country

• Postcode

• Telephone

• Work

• Mobile

[NogDog]

Generally:

• If a field will store variable length text: VARCHAR.

• If fixed-length (or usually at or close to max length) text: CHAR.

• Boolean (yes/no, true/false): TINYINT (1 = true, 0 = false)

• Title could be an ENUM type.

Note: It might make more sense to create a separate, relational table for "interested sites", which would then have (at least) 2 fields: a foreign key to the account table (or user table or whatever you're calling it) and the site of interest.

[Piranha]

I agree with NogDog, but have a few more things to say.

Images should normally not be saved in the database. Save it in the file system and save the path in the database.

I think that you should read up on "database normalization", it is the way to design databases to make them easy to work with and easy to expand.

[F_Danials]

OK, Cheers for the advice 🙂