[FilterScript] [MySQL-R39]Music Player
#2

Why not just do
PHP Code:

CREATE TABLE 
`songs` (
  `
IDint(11NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `
Artisttext NOT NULL,
  `
Songtext NOT NULL,
  `
Linktext NOT NULL
ENGINE=InnoDB DEFAULT CHARSET=latin1
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
Reply


Messages In This Thread
[MySQL-R39]Music Player - by Rolux - 18.07.2017, 10:41
Re: [MySQL-R39]Music Player - by Eoussama - 18.07.2017, 11:11
Re: [MySQL-R39]Music Player - by Rolux - 18.07.2017, 11:45

Forum Jump:


Users browsing this thread: 2 Guest(s)