answersLogoWhite

0

For example, here are the different type that you store in a MySQL Database

Numeric :

  • TinyInt
  • SmallInt
  • MediumInt
  • Int
  • BigInt
  • Decimal
  • Float
  • Double
  • Boolean
  • Big
  • Bool
  • Serial

Date and Time

  • Date
  • DateTime
  • Year
  • TimeStamp
  • Time

String

  • Char
  • VarChar
  • TinyText
  • Text
  • MediumText
  • LongText
  • Binary
  • VarBinary
  • TinyBlob
  • Blob
  • MediumBlob
  • LongBlob
  • Enum
  • Set

Spatial

  • Goemetry
  • LineString
  • Point
  • Polygon
  • MultipleLineString
  • MultiplePoint
  • MultiplePolygon
  • GeometryCollection

In other databases, such as Miscrosoft SQL you can even store XML, Image, and much more

User Avatar

Wiki User

15y ago

What else can I help you with?

Continue Learning about Information Science

Difference between database and distributed database?

A database is nothing but simply a collection of records. The data can be stored all at a same place or can be distributed in different systems . When data is stored in different places that is distributed it is called distributed database.A database is normally stored in one place. That could be a physical location, like a particular office. A distributed database is one database that has different parts of it stored in different places. This is often for security and safety purposes. To a user, they still see all of the data they need on their screen, so they don't even realise that it is stored in different locations.


What allows you to store retrieve analyze and print information stored in a database?

A database management system (DBMS) is used to store, retrieve, analyze, and print information stored in a database. It provides functionalities to efficiently manage data, ensure data integrity, and support various operations such as querying and reporting on the data stored in the database.


What is a database field name?

A database field name is a unique identifier for a particular piece of data within a database table. It helps to organize and distinguish different types of information stored in the database. Each field name typically corresponds to a specific attribute or characteristic of the data being stored.


Information stored in a column of a database is called a?

attribute


What called a collection of records on a particular topic is stored?

A collection of records on a particular topic that is stored is called a database. A database is an organized collection of data that can be easily accessed, managed, and updated.

Related Questions

What is active database and cloud database?

The database we use in our daily life is called as active database . The data that is stored in the database which is further stored on the cloud is called cloud database.


Difference between flat file and database file?

DATABASE FILE - is one that is stored on a server and it is in the format that the database needs to read it. It is stored in the database catalog......


What order are files stored in the database?

simply files are stored in database in upper to lower order.


Where is a database stored?

ram


Hos is DBMS different from a Database?

DBMS is database management. Database is where the information is stored.


Are Highly structured and organized data is stored in database files?

are structured and organized data stored in database files


What is the difference between database and database administrator?

Database is the data stored in the server and Database administrator is the person who designs the database.


Enter on the database or in the database?

We would use in rather than on. Data is stored in a database, not on a database. Data is entered into a database not onto a database.


How is a Database organised?

A database contains forms and reports stored in tables


Differentiate DATA from a database?

A database is a collection of data. Data represents items that are stored within the database.


Is database window query?

yeah, database is a query language,, abd it is stored datas


Difference between database and distributed database?

A database is nothing but simply a collection of records. The data can be stored all at a same place or can be distributed in different systems . When data is stored in different places that is distributed it is called distributed database.A database is normally stored in one place. That could be a physical location, like a particular office. A distributed database is one database that has different parts of it stored in different places. This is often for security and safety purposes. To a user, they still see all of the data they need on their screen, so they don't even realise that it is stored in different locations.