Skip to main content

Data Types In SQL

 

Data Types In SQL

What is Data Type?

A data type as the name suggests it is the type or category to which the data belongs to. A data type specifies a particular type of data, such as integer, floating-point, Boolean, etc. In SQL, the data type defines the type of data to be stored in each column of a table.

SQL data types can be broadly divided into three categories

1.      Numeric Data Types

2.      String Data Types

3.      Data & Time Data Types

Numeric Data Types

String Data Types

Data&Time DataTypes

BIT

CHAR(SIZE)

DATE

TINYINT

VARCHAR(SIZE)

TIME

SMALLINT

TEXT(SIZE)

DATETIME

MEDIUMINT

TINYTEXT(SIZE)

TIMESTAMP

INT

MEDIUMTEXT(SIZE)

YEAR

BIGINT

LONGTEXT

 

FLOAT

BINARY

 

DOUBLE

ENUM

 

BOOLEAN

SET

 

 

Most commonly used data types

1.   INT :  The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295.

2.   CHAR Or VARCHAR : The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store. For example, CHAR(30) can hold up to 30 characters.

3.   DATE & TIME Data Types:

a)   DATE : Stores date in the format of YYY-MM-DD.

b)  TIME : Stores time in the format of HH:MI:SS.

c)    DATATIME : Stores date and time information in the format of    YYYY-MM-DD HH:MI:SS.

d)  TIMESTAMP : Stores number of second passed science the Unix epoch (‘1970-01-01 00:00:00’ UTC).

YEAR : MySQL displays YEAR values in YYYY format, with a range of 1901 to 2155, and 0000.

 

                                                                                                                 

Labels:

Comments

Post a Comment

Popular posts from this blog

Methods of String in java

  String in Java String:   A Java string is  a sequence of characters that exist as an object of the class java. lang. Here is  the list of important methods available in the java string class: Ø  startsWith ( ): It checks if the string starts with the given prefix. If yes then return true else false. Ø  endsWith () : It checks if the string ends with the given suffix. If yes then return true else false. Ø  substring(int begin index) : It return s  the substring of the string. The substring start s  with the character at the specified index. Ø   substring(Int begin index , int end index) : Returns the substring. The substring starts with the character at begin index and ends with the character at end index. Ø  toLowerCase() : It converts all  the character s  of the string into lower case(Small Letters).   Ø  toUpperCase() : It converts all the character s  of the string into upper case(Capital Let...
Post a Comment
Read more

Conditional Statements In Java

  Conditionals Statement   A conditional statement  is a set of rules performed if a certain condition is met. A conditional statement begins with the keyword if followed by parentheses. The result of the evaluation is true or false. ·       ‘ if ‘ statement ·       ‘ if-else ‘ statement ·         Nested ‘ if ‘ statement ·       ‘ if-else - if ‘ statement IF statement: ‘IF’ statement is the most basic and simple statement among all the statements. For example- if a value is less than 0, return “Negative value”. Let’s see an example- IF-ELSE statement: The if-else is statement is an extended version of If. Let’s see an example- Nested IF-ELSE statement : In Java, when there is an if statement inside another if statement then it is known as nested if-else. Let’s see an example- IF-ELSE-IF: ‘ if-else-if ’ statement is used when we need to check mul...
Post a Comment
Read more