#MySQL数据类型

-- Using UNSIGNED

-- Using DECIMAL for exact values

-- DECIMAL examples

-- Query with boolean conditions

-- CHAR: Fixed-length, padded with spaces

-- VARCHAR: Variable-length, no padding

-- Observe the difference

-- TINYTEXT: Very short strings (up to 255 characters)

-- TEXT: Standard text (up to 65,535 bytes)

-- MEDIUMTEXT: Medium-length text (up to 16 MB)

-- LONGTEXT: Long text (up to 4 GB)

-- Binary data storage

-- Store SHA-256 hash

-- Define possible values

-- Invalid values will cause error
-- INSERT INTO enum_demo (status) VALUES ('invalid');  -- Error

-- Check valid values

-- Store multiple values from a defined set

-- Query using FIND_IN_SET

-- Date only (YYYY-MM-DD)

-- Date functions

-- Date arithmetic

-- Time only (HH:MM:SS or HH:MM:SS.microseconds)

-- Time functions

-- Date and time (YYYY-MM-DD HH:MM:SS)

-- DATETIME functions

-- DATETIME arithmetic

-- Timestamp (stored as UTC, displayed in session timezone)

-- TIMESTAMP characteristics
-- - Automatically converts between timezones
-- - Default value is CURRENT_TIMESTAMP
-- - Updates automatically on row modification
-- - Range limited to 1970-2038

-- Year value (4-digit format)

-- JSON type for structured data

-- Insert JSON data

-- JSON extraction

-- JSON validation

-- JSON comparison

-- Create JSON

-- Spatial data types

-- Insert spatial data

-- Spatial functions