Data types for the database

Data types for the database

1. SQL

   • String data types
     • This datatype is for the different variations and uses for characters and numbers together
   • Numeric data types
     • This datatype allows for only integer values to be stored into that column of data, and there different possible applications and variations
   • Date and time data types
     • Due to SQL specificly dealing with databases, times and dates are used a lot in its applications
       • This is a data type specific to SQL, and as the name suggests, allows for specificly infomation concerning the time to be place within the column.

2. Python data types

   • Text type
     • String (str)
     • Numeric types
       • Integer (int), float, complex
   • Sequence types
     • list, tuple, range
   • Mapping type
     • dict
   • Set types
     • Set, frozenset
   • Boolean type
     • bool
   • Binary type
     • bytes, bytearray, memoryview
   • None type
     • Nonetype