[snip]
Yes I do enjoy every day in which the manual makes my life easier. I
guess I
didn't work my question specifically enough however. I was actually
looking
for a way to 'ALTER' the table so that my State field data is always
upper.
In MSSQL you can apply a function to a field, which will then r
ay 10, 2005 10:58 AM
To: Matt Babineau; mysql@lists.mysql.com
Subject: RE: Field property question!
[snip]
Can I setup a table so that no matter how data is entered into it (web
form,
command line) The data in one of the columns ALWAYS gets converted to
uppercase? I remeber MSSQL had this feature of
[snip]
I think matt is thinking more automagically like having upper() called
on a column on insert for him instead of putting it into every query.
You can't do this yet. sorry.
[/snip]
Aha, I see. Needs a trigger or stored procedure.
--
MySQL General Mailing List
For list archives: http://list
I think matt is thinking more automagically like having upper() called
on a column on insert for him instead of putting it into every query.
You can't do this yet. sorry.
-Eric
Jay Blanchard wrote:
[snip]
Can I setup a table so that no matter how data is entered into it (web
form,
command line)
[snip]
Can I setup a table so that no matter how data is entered into it (web
form,
command line) The data in one of the columns ALWAYS gets converted to
uppercase? I remeber MSSQL had this feature of being able to apply a
function to a field in its configuration.
[/snip]
The manual, it is amazing
