Cant set desired values in column.. (ex. 1.jpg)
On my personal test server I have a MySQL Datatabase, and one of the fields is a type VarChar(45). For this column I have the default value set as 0.jpg.
Now, on the server provided to me on the internet I cannot select VarChar(45), and all of the ones I have tried only allow me to enter in 0 as thhe default value.
This is a problem as I need to store the filename in this column, ex 1.jpg, 2.jpg, etc.. etc..
Does anyone know a way around this, or what other MySQL columns accept these kinds of values?
chown linux:users\ /world
First, make sure you are using sinigle quotes around the default value.
Second, what table type are you using on your local machine and on the remote host?