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
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Difference between database and distributed database?
A database is a collection of related data organized for quick search and retrieval, usually stored on a single computer system. A distributed database is a database in which parts of the database are stored in multiple locations but managed by a centralized control. Distributed databases are used to improve performance, reliability, and scalability by allowing data to be spread across multiple servers or 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?
Data.
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.
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
Are Highly structured and organized data is stored in database files?
are structured and organized data stored in database files
Hos is DBMS different from a Database?
DBMS is database management. Database is where the information is stored.
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
What does the term database refer to and how does it work?
Database is a storage of information. Depending on the company or individual creating this database, what is stored in the database can vary greatly. The information stored in a database is kept in a systematic way, making it easy to retrieve necessary information.
Differentiate DATA from a database?
A database is a collection of data. Data represents items that are stored within the database.
Difference between database and distributed database?
A database is a collection of related data organized for quick search and retrieval, usually stored on a single computer system. A distributed database is a database in which parts of the database are stored in multiple locations but managed by a centralized control. Distributed databases are used to improve performance, reliability, and scalability by allowing data to be spread across multiple servers or locations.
