• BIT data type can store up to 8 bytes from My SQL version 5.0.3
• BIT data type can be used only for binary data

MySQL BOOL, TINYINT and BIT - September 30, 2009 at 18:00 pm by Vidya SagarExplain the difference between BOOL, TINYINT and BIT in MySQL.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.

CHAR_LENGTH includes leading and trailing blanks and the string-termination character LENGTH excludes trailing blanks and the string-termination character. It does not exclude leading blanks.

MySQL CHAR_LENGTH and LENGTH - September 30, 2009 at 18:00 pm by Vidya SagarWhat is the difference between CHAR_LENGTH and LENGTH in MySQL?CHAR_LENGTH, as the name suggests, returns the number of characters / character count. The LENGTH returns the number of bytes / bytes count. To count the Latin characters, both lengths are the same. To count Unicode and other encodings, the lengths are different.

• Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available in Oracle and not in MySQL in versions less than 5.0
• Large Database size is supported more in Oracle in contrast to MySql.

MySQL vs. Oracle.

• Unlike oracle, mysql data types can store invalid dates and don’t support time zones.
• Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available in Oracle and not in MySQL in versions less than 5.0
• Large Database size is supported more in Oracle in contrast to MySql.
• Replication in oracle is two way while one way in mysql.

Query Cache in MySQL is used in scenarios when the same queries need to be executed on the same data set. These queries also return the same result. Query cache is most useful when there are tables that are not expected to change very often. It is important to note that the query cache does not return old data. If the tables are modified, any important entries in the query cache are flushed.

MySQL is a relational database management system which is an open source database.

Features:

• Because of its unique storage engine architecture MySQL performance is very high. 
• Supports large number of embedded applications which makes MySql very flexible.
• Use of Triggers, Stored procedures and views which allows the developer to give a higher productivity.
• Allows transactions to be rolled back, commit and crash recovery. 

FLOATs store floating point numbers with 8 place accuracy and take up 4 bytes. DOUBLEs store floating point numbers with 16 place accuracy and take up 8 bytes. REAL is a synonym of FLOAT for now.

Prior to MySQL 5.0.3: those are all synonyms. After MySQL 5.0.3: BIT data type can store 8 bytes of data and should be used for binary data.

It stops incrementing. It does not overflow to 0 to prevent data losses, but further inserts are going to produce an error, since the key has been used already.

BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT