MySQL Tutorial for Beginners - Part 10 - Storage and Data Types Used in a MySQL Database

Get the full course on MySQL for Beginners here:

During this video, learn about the importance of data types for storing data in your MySQL database.

Selecting the appropriate data type for column values will optimize disk space utilization and increase performance.

The general data categories into which all data types are organized are:
- Collections of characters -- strings -- or collections of bytes
- Numeric
- Dates and times

There are trade-offs in the use of VARCHAR and CHAR data types.
- VARCHAR will reduce disk space requirements
- CHAR are fixed length making string manipulation easier
- Index searches are ~20% faster on CHAR versus VARCHAR
- VARCHAR has overhead of 1-2 bytes

Stay in touch:

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)

[lupissarra]

What about getting data into the DB and working with it? Not covered in the tutorial?!?

[Ashwkites]

could u please provide link of 11th on wards videos? I could not find here.