반응형 mysql3 [MySQL] smallint / tinyint / int / bigint Data Type Range Storage bigint -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807) 8 Bytes int -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) 4 Bytes smallint -2^15 (-32,768) to 2^15-1 (32,767) 2 Bytes tinyint 0 to 255 1 Byte 2023. 12. 18. MySQL 계정 생성, 권한 부여 CREATE USER 'DB'@'IP' IDENTIFIED BY 'PASSWORD'; 1) 특정 권한 GRANT SELECT, INSERT, UPDATE, DELETE ON DB .* TO 'DB'@'IP' ; 2) 모든 권한 GRANT ALL PRIVILEGES ON DB .* TO 'DB'@'IP' ; FLUSH PRIVILEGES; 2023. 12. 8. [MySQL] Table, Index size SELECT table_name, table_rows, data_length, index_length, data_free FROM information_schema.tables WHERE table_schema = 'your_database_name' AND table_name = 'your_table_name'; 2023. 11. 28. 이전 1 다음 반응형