Listing of All Mysql Data Types and Syntax For All Settings

Question

I'm looking for a listing of all MySQL data types and the available settings for each option for each data type.

After a bit of googling I couldn't find anything quite like that.

Answer 1

here you can find a quick summary of mysql data types, with range, attributes and default value

Answer 2

For completeness' sake, don't forget the MySQL documentation.

Although the list is broken across multiple pages, often with a lot of commentary in between, it's a useful resource when you need to check some aspect of a particular type. There are also overviews of the basic types, but again, there's a lot of cruft mixed in with it.