Im wondering how to declare an array in a mysql table.
The following code is what I tryed
CREATE TABLE Stats (ID INT NOT NULL AUTO_INCREMENT,Day DATE,Hour[23] INT);
I also tryed round brackets and put them after the int and every variation in between and it doesnt work
I am looking to have 24 variables in the hour column (Ill need to set them all to zero later, but right now just declaring the array is what im stuck at)
Thanks in advance
The following code is what I tryed
CREATE TABLE Stats (ID INT NOT NULL AUTO_INCREMENT,Day DATE,Hour[23] INT);
I also tryed round brackets and put them after the int and every variation in between and it doesnt work
I am looking to have 24 variables in the hour column (Ill need to set them all to zero later, but right now just declaring the array is what im stuck at)
Thanks in advance