mysql add column tinyint default 0
ALTER TABLE table1 ADD COLUMN foo INT DEFAULT 0;
mysql add column tinyint default 0
ALTER TABLE table1 ADD COLUMN foo INT DEFAULT 0;
mysql tinyint max value
-- SIGNED UNSIGNED
-- Min Max Min Max
TINYINT -128 127 0 255
SMALLINT -32767 32767 0 65535
MEDIUMINT -8388608 388608 0 16777215
INT -2147483648 2147483647 0 4294967295
INTEGER -2147483648 2147483647 0 4294967295
BIGINT -9223372036854775808 9223372036854775808 0 18446744073709551615
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us