What is SQL? What are the main data types?
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?
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?
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.
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)
Notifications