I am creating a table in MYSQL:
$sql="CREATE TABLE $URL(Image BLOB,Rating INT(30000),Id INT AUTO_INCREMENT)";
$result=mysql_query($sql);
Note: $URL is a randomized variable character string
However, nothing is happening. Does anyone know why?
Display width out of range for column 'Rating' (max = 255)
Furthermore let me paste you the definition of the optional display width
.
This optional display width may be used by applications to display integer values having a width less than the width specified for the column by left-padding them with spaces.
NOTE:
The display width does not constrain the range of values that can be stored in the column.
All INT
types will be from -2147483648
to 2147483647