Part 6 : SQL Tutorials || Discuss on MYSQL Datatypes || String Data Types
@Lifewithtanianirban presents this topic is about discussion on MYSQL Data Types. There are three Datatypes in MYSQL
1) Strings
2) Numeric
3) Date and Time Data Types
These three data Types, Today we discuss on String Data Types.
1) CHAR(size) : A FIXED length string (can contain letters, numbers, and special characters). The size parameter specifies the column length in characters - can be from 0 to 255. Default is 1
2) VARCHAR(size) : A VARIABLE length string (can contain letters, numbers, and special characters). The size parameter specifies the maximum string length in characters - can be from 0 to 65535
3) BINARY(size) : Equal to CHAR(), but stores binary byte strings. The size parameter specifies the column length in bytes. Default is 1
4) TINYTEXT : Holds a string with a maximum length of 255 characters
5) TEXT(size) : Holds a string with a maximum length of 65,535 bytes
6) MEDIUMTEXT : Holds a string with a maximum length of 16,777,215 characters
7) LONGTEXT : Holds a string with a maximum length of 4,294,967,295 characters
Any Queries regarding this topic, Please write in the comment box. I will help you !!
On this page of the site you can watch the video online Part 6 : SQL Tutorials || Discuss on MYSQL Datatypes || String Data Types with a duration of hours minute second in good quality, which was uploaded by the user Life with Tania&Anirban 07 September 2022, share the link with friends and acquaintances, this video has already been watched 32 times on youtube and it was liked by 0 viewers. Enjoy your viewing!
