String & Text Data type in MySQL -CHAR,VARCHAR,MEDIUMTEXT,LONGTEXT,TINYTEXT,TEXT
Date & Time Data type in MySQL -DATE, TIME, DATETIME, TIMESTAMP, YEAR
#mysql #datatype #string #strings #date #text #text datatype #time #date #sql #data
*************************************************************************
𝌞 TABLE of CONTENT
0:00 STRING and TEXT Data types.
01:28 Examples of STRING and TEXT Datatype-MySQL Workbench.
03:20 DATE and TIME Data type.
04:24 DATE() Functions
06:08 Examples of DATE and TIME Datatype-MySQL Workbench.
***************************************************************************
⚙️ How to install MySQL server, here is the link: • How to install MySQL on macOS and inv...
⚙️ How to install MySQL Workbench and import sample Database : • How to download and install MySQL Wor...
📀 Here is the complete playlist for MySQl so far completed topics : • MySQL Complete course from beginners ...
📕 Workbench Keyboard shortcuts guideline:https://drive.google.com/file/d/13WEo...
📒 Sample Database for practice, here is the link to download :https://drive.google.com/file/d/1o6cE...
❤️ For more video like this one, just subscribe to Littletek Pro Channel : / @littletekpro
👀 DO NOT FORGET TO VISIT:
Website: https://littletekpro.github.io/
Facebook : / littletekpro
Instagram: / pramod.prad
Twitter : / pramodp68379475
#mysql #datatype #STRING #TEXT #DATE #TIME #String #Text #Date #Time #string #text #date #time
***************************************************************************
Following queries answers can be found from this video and Data type Part 1
What is the data type for date and time in MySQL?
Is there a time data type for MySQL?
Is date a string in MySQL?
What is text data type in MySQL?
What is the data type for time?
What data type is date?
What is MySQL time?
How can create date and time table in MySQL?
How does MySQL store time format?
What is text data type?
Is VARCHAR a text?
Should I use text or VARCHAR?
What is date type in SQL?
What is time type in SQL?
Is date a string?
Is time a data type in SQL?
Which data type is used for string?
Is time function in SQL?
How can get date in dd mm yyyy format in MySQL?
Which function is used for date in MySQL?
What is string function in MySQL?
What is date format in MySQL?
How do I insert a date field in SQL?
What is date and time function?
How do I query a date in SQL?
What is current date SQL?
How do I find a string in MySQL?
Does MySQL have varchar?
What are the types of functions in MySQL?