18.07.2017, 11:11
Why not just do
and why INT? I double anyone would store 2147483647 songs (which is the maximum value of int)
I would go with TINYINT UNSIGNED and get 255 slots
Reference: https://dev.mysql.com/doc/refman/5.7...ger-types.html
PHP Code:
CREATE TABLE `songs` (
`ID` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`Artist` text NOT NULL,
`Song` text NOT NULL,
`Link` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
I would go with TINYINT UNSIGNED and get 255 slots
Reference: https://dev.mysql.com/doc/refman/5.7...ger-types.html