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
Go To Solution
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.

About John major
Questions
1
Answers
106
Best Answers
47
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)

 

 

About Howard william
Questions
3
Answers
52
Best Answers
16

How to find css Facebook like chat bar tutorial?

Previous

Database for Mailing list templates

Next

Related Questions