What is SQL? What are the main data types?

Asked By 10 points N/A Posted on -
qa-featured

Hello,

I am following a degree in computer science and I just started it. I want to know what is sql? , what are the main data types in SQL?

SHARE
Best Answer by Howard william
Answered By 0 points N/A #162530

What is SQL? What are the main data types?

qa-featured

Hello,

Sql stand for Structured Query Language and It is a programming language that use for manipulate data from Databases.

Main Data Types in Sql

1.   Char (8)- for characters, store text data

2.   Varchar(10) – for characters, store text data

3.   Int(10) – whole numbers

4.   Decimal (10,2) – for decimal numbers

Data type’s length can be different from one data type to another data type.

Hope this will help you,

Thank You

John Major.

Best Answer
Best Answer
Answered By 0 points N/A #162531

What is SQL? What are the main data types?

qa-featured

HI,

SQL or structured query language is a kind of language which is used to manipulate data and table definitions in database. SQL statements are not case sensitive and it can be written on one or more line. A database can be accessed or modified by SQL.

 

The main data types used in SQL are:

 

1.   Int (30); for integer numbers

2.   Varchar(30); for characters and strings

3.   Numeric(20,2) for floating numbers

4.   Blob(5MB) for images, files uploads

5.   Date (YYYY-MM-DD HH:MM:SS)

 

 

Related Questions