BOOL : Used to store Boolean values, 0 being false and 1 being true. MySQL sets them as TINYINT type.
TINYINT : The range of this data type is -128 - +127 or 0 – 256 and occupies 1 byte.
BIT : Bit uses 8 bytes and stores only binary data.
Showing posts with label BOOL. Show all posts
Showing posts with label BOOL. Show all posts
Monday, 22 May 2017
Explain federated tables ?
A Federated Table is a table which points to a table in an other MySQL database instance (mostly on an other server). It can be seen as a view to this remote database table.
What are HEAP tables in MySQL ?
A heap is a table without a clustered index. One or more nonclustered indexes can be created on tables stored as a heap. Data is stored in the heap without specifying an order.
Subscribe to:
Posts (Atom)