What do you remember from previous lesson?
SQLDatabaseAdvantages and disadvantages
Everyone knows what is datatype from previous courses, but does anyone know what datatypes are used in SQL?
SQL Data Types define the type of value that can be stored in a table column.
Number(Integer) – datatype that define a whole, not a fraction number.
Date, Time, Datetime
Date, Time and Datetime are a datatypes that stores (obviously) date and time. Often, the rule of storing data for Date is “mm.dd.yy” and for Time is “hh:mm:ss”.
Varchar (also a Text, short text or long text) is a datatype that stores a list of character (string in other words). “Hello World!” is a sentence with “text” datatype.
Name: JohnSurname: SmithDate of birth: 11.05.1998Age: 29Blood group: A
Give any 3 example on each datatype you’ve learned today.
Thanks for the attention!
© ООО «Знанио»