Categoría: Tecnología

Data Type From To Storage Space Example bigint -9,223,372,036,854,775,808 9,223,372,036,854,775,807 8 bytes Population bigint  int -2,147,483,648 2,147,483,647 4 bytes ID  int  smallint -32,768 32,767 2 bytes ID smallint  tinyint 0 255 1 byte Age tinyint  bit 0 1 1 bit Present bit  decimal -10^38 +1 10^38 -1 5 – 17 bytes Balance decimal(8,2)  numeric -10^38…

Data Relationships SQL term Relational database term Description Row Tuple or record A data set representing a single item Column Attribute or field A labeled element of a tuple, e.g. «Address» or «Date of birth» Table Relation or Base relvar A set of tuples sharing the same attributes; a set of columns and rows View or result set Derived relvar Any set of…

Selecting a MySQL database using the mysql client tool MySQL CREATE DATABASE statement MySQL DROP DATABASE statement The DROP DATABASE statement drops all tables in the database and deletes the database permanently. Therefore, you need to be very careful when using this statement.

DDL: Data definition language DML: Data manipulation language DCL: Data control language Designed for managing relational databases MySQL is versatile and can run on various platforms, including UNIX, Linux, and Windows. You can install it on a server or even on a desktop. What’s more, MySQL is renowned for its reliability, scalability, and speed. MySQL SELECT…