What are the field types and properties of SQL datasheet

This article mainly introduces the SQL datasheet field types and attributes, the article is very detailed, has a certain reference value, interested friends must read it!

1.SQL field type

Type space size (bytes) actual size other tinyint (display) 10-255unsign, zerofillsmallint (display) 265535unsign, zerofillint (display) 44 billion unsign, zerofillfloat (MMague D) 46 precision unsign, zerofilldouble (MMague D) 816precision unsign, zerofilldecimal (MMague D) unsign, zerofillchar (actual) 40-255super long truncation, insufficient blanking varchar (actual) 1x 50-255super long truncation, deficiency does not deal with

2.SQL Field Properties

Not null

Default value

Primary key

Auto_increment

Foreign key

Foreign key (foreign key id) references table name (primary key id)

The above is all the content of the article "what are the field types and attributes of SQL datasheet?" Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!