MySQL - Data Types Introduction

preview_player
Показать описание

In MySQL, and other databases, you can set what type of data a value in a table can be. Whether it’s text, a number, or even a file. This is used to prevent bad data from being added to the database and stop issues such as “bob +2”.

There are numerous Data Types that can be used in MySQL. Even using a number can be an INT, FLOAT, DECIMAL and more.
You use the Data Type most appropriate not just for the current use of the database, but which you expect will work in the future.
You can create problems by using a Data Type setting that your use outgrows. So if you set a DECIMAL value to only accept 5 digits, but at some point you need to store 6 digits in that field this will case issues.
Front End Validation is used to try to prevent bad data from being sent to the database.
Acknowledgements from the MySQL database back end are used to prevent “silent failures” where data is not properly inserted into the database, but the user does not realize there is an issue.
  1. Eli the Computer Guy
  2. Eli
  3. the
  4. Computer
  5. Guy
  6. Repair
Рекомендации по теме
MySQL 24 - 0:05:33

MySQL 24 - Important Data Types

MySQL 101 - 0:05:04

MySQL 101 - Episode 07 : Data Types (English)

MySQL - Data 0:31:01

MySQL - Data Types Introduction

MySQL Data Types 0:13:42

MySQL Data Types | Introduction to Data Types in MySQL | MySQL Tutorial | Edureka

MySQL 23 - 0:06:24

MySQL 23 - Intro to Data Types

MySQL - The 0:17:17

MySQL - The Basics // Learn SQL in 23 Easy Steps

MySQL Data Types 0:05:18

MySQL Data Types 1 - Char and Varchar

SQL data types 0:00:17

SQL data types you should know! #sql #mysql #datatypes #ivyproschool

Introduction to MySQL 0:09:34

Introduction to MySQL for Beginners Malayalam | What is Data, Database, and DBMS?

MySQL 29 - 0:06:14

MySQL 29 - SET Data Type

DATATYPES IN SQL 0:16:02

DATATYPES IN SQL || SQL DATATYPES || INTEGER || NUMBER || VARCHAR || DATETIME || DBMS || SQL

MySQL Data Types 0:04:12

MySQL Data Types 2 - Text Types

MySQL Data Types 0:08:56

MySQL Data Types 5 - Integers

MySQL 5 Tutorial 0:03:02

MySQL 5 Tutorial | Intro Data Types

What are MySql 0:08:19

What are MySql Data Types - Explained with Examples | Tutorial for Beginners

Learning MySQL - 0:04:49

Learning MySQL - DataTypes for Time and Dates

SQL Explained in 0:02:23

SQL Explained in 100 Seconds

What is Data 0:05:55

What is Data Type and Its Types? | Programming Tutorial for Beginners - KnowledgeHut

Sql Data Types 0:09:43

Sql Data Types in Telugu

Learning MySQL - 0:06:35

Learning MySQL - Numeric DataTypes

MySQL Full Course 3:00:00

MySQL Full Course for free 🐬

#30 Introduction to 0:13:49

#30 Introduction to Data Types in MySQL | SQL Data Types in DBMS | Data Types in SQL | SQL in Hindi

Learning MySQL - 0:09:28

Learning MySQL - String and Binary Datatypes

Installing MySQL and 0:12:04

Installing MySQL and Creating Databases | MySQL for Beginners

Комментарии
Автор

man, i love it, I can do all lectures in one go that is how interesting it is. When I start earning more I will make sure to put in a recurring donation on your website for sure.

javidthewebguy
Автор

Eli!! I freakin love you! I'm glad your back.

jeremycornish-ford
Автор

"..He puts a Bob into a place a Bob should never be. And then all hell can break loose.." 🤣🤣🤣

eugeneshilow
Автор

Thank you very much for sharing your videos

stiank
Автор

Thanks Eli, great content...very helpful

mse
Автор

Awesome video! Helped me a lot to understand the terminology

deluke
Автор

. Thanks a lot, @Eli for the best MySQL course. anyone knows the best class for Lithium battery management?

sebahizilongin
Автор

Well, the good thing about this channel, a lot of the stuff you're teaching will be relevent for awhile so you'll always get views from your old videos, buuuut I wish the best for you and I subbed :P

NextazxzNoExuse
Автор

Eli please do some new classes on Azure and AWS

dynamicentry
Автор

30:21 Dude! Isn't that the "I Carly" lady on the left?😲

brandonfarfan
Автор

i dont know how els to leave a msg so that you will read it.

But wil you pretty please learn me more about ARP in cmd, and why is the last 4 ip, s (ipv4)
224.x.x.x
224.0.x.x.
234.0.x.x
239.255.x.x.


and thank you very much for all theses years

andrepotts
Автор

Can you please repeat 6 more times what will happen if wrong data type is entered in a field - e.g., if someone enters int instead of char because this topic is still absolutely unclear
thanks
PS this are lectures for 3 y.o. kids, how much money do they have and can they pay on Patreon?

forcanadaru