MySQL String Data Types - MySQL Tutorial 10
Notes for You:: MySQL String Data Types - MySQL Tutorial 10
MySQL Data types:
While defining a column in a table; we must mention data type of the column.
Data type indicates which type of data and range of values a column can hold.
Data types in MySQL are mainly divided into 3 types.
They are string, numeric and date/time.
String Types: Textual Data.
char[(M)]:
indicates a fixed-length string that is always right-padded with spaces to the specified length.
M indicates length i.e. maximum number of characters a column can hold.
the range of M is 0 to 255.
varchar(M):
indicates a variable-length string. It stores only the characters that you insert.
M indicates maximum number of characters a column can hold.
the range of M is 0 to 255.
text[(M)]:
indicates a string of characters.
M indicates maximum number of characters a column can hold.
the range of M is 0 to 65535.
blob[(M)]: binary large object.
indicates a string of bits.
M indicates maximum number of bits a column can hold.
the range of M is 0 to 65535.
mediumtext[(M)]:
indicates a string of characters.
M indicates maximum number of characters a column can hold.
the range of M is 0 to 1,67,77,215 .
mediumblob[(M)]:
indicates a string of bits.
M indicates maximum number of bits a column can hold.
the range of M is 0 to 1,67,77,215 .
longtext[(M)]:
indicates a string of characters.
M indicates maximum number of characters a column can hold.
the range of M is 0 to 429,49,67,295.
longblob[(M)]:
indicates a string of bits.
M indicates maximum number of bits a column can hold.
the range of M is 0 to 429,49,67,295.
=========================================
Follow the link for next video:
MySQL Tutorial 11 - Numeric Data types in MySQL
• MySQL Numeric Data Types - MySQL Tuto...
Follow the link for previous video:
MySQL Tutorial 09 - How to Create Table in a MySQL Database
• MySQL CREATE TABLE Command - MySQL Tu...
=========================================
MySQL Tutorials Playlist:-
• MySQL Tutorials
=========================================
Watch My Other Useful Tutorials:-
PHP Tutorials Playlist:-
• PHP Tutorials
JavaScript Tutorials Playlist:-
• JavaScript Tutorials
HTML Quick Tutorials Playlist:-
• HTML Quick Tutorials
=========================================
► Subscribe to our YouTube channel:
/ chidrestechtutorials
► Visit our Website:
https://www.chidrestechtutorials.com
=========================================
Hash Tags:-
#ChidresTechTutorials #MySQL #MySQLTutorial
On this page of the site you can watch the video online MySQL String Data Types - MySQL Tutorial 10 with a duration of hours minute second in good quality, which was uploaded by the user ChidresTechTutorials 25 August 2020, share the link with friends and acquaintances, this video has already been watched 3,376 times on youtube and it was liked by 60 viewers. Enjoy your viewing!
