![]() For example, MySQL provides these possible integer data types: Most databases offer size variations for each type. Some databases (like MySQL) don’t have boolean data type and instead convert boolean values into integers (1=TRUE, 0 = FALSE) boolean: for boolean (true/false) values.varchar(n): for variable-length character strings, where the value in the parenthesis dictates the maximum accepted size of each entry.character(n):for fixed-length character strings, where the value in the parenthesis dictates the fixed size of each entry.timestamp / datetime: for date and time values.Commonly used for all real numbers except monetary fields Can be signed (allow positive and negative values) or unsigned (only allow positive numbers). float / doubles: for numbers with fractions not requiring exact precision.The user specifies the number of significant digits allowed overall (x) and after the decimal point (y) in the parentheses ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |