0
Sql data types
Hello guys, I am a newbie in sql and I wanna make a request which is for someone to email me all sql data types and their functions (preferably in PDF format) my email: mayowa.arowolo@aol.com I'll really appreciate if anyone hands me this favor. Sincere thanks!
3 Respuestas
0
int
integer
number(min, max)
real
float
char (len)
varchar (len)
bool
there are probs more. it also depends on what sql you are developing in. sql and mysql have different limitations. so be careful for that...
hope this helps
*sorry for not email
0
Char(n)
Varchar(n)
Varchar(max)
Text
Nchar
Nvarchar
Nvarchar(max)
Ntext
Bit
Binary(n)
Varbinary
Varbinary(max)
Image
0
Here are SQL data types:
Numeric Types:
INT (Integer)
SMALLINT (Small Integer)
TINYINT (Tiny Integer)
BIGINT (Big Integer)
DECIMAL or NUMERIC (Fixed-point numbers)
FLOAT (Floating-point number)
REAL (Real number)
Character String Types:
CHAR (Fixed-length character)
VARCHAR (Variable-length character)
TEXT (Variable-length character, typically for longer strings)
Date and Time Types:
DATE (Date only)
TIME (Time only)
DATETIME or TIMESTAMP (Date and time)
Boolean Type:
BOOLEAN or BOOL (Boolean)
find more here https://www.tutorialspoint.com/sql/sql-data-types.htm