Baron Schwartz wrote:
Hi,
Tim Milstead wrote:
Hello,
Is it possible to enforce data formatting in fields using something
like a regular expression?
varchar is great but does not stop someone putting in the wrong
reference number.
I suspect the answer is no, you have to do it at a higher level. What
aprroach would people suggest?
Perhaps another table with two fields - field_name and field_regex?
If you are using 5.x or greater, you can do some kinds of data
validation with a trigger.
Baron
I would argue that your data-validation should really not be done with
triggers - I would look more at the php/asp/whatever code to do this.
Shouldn't this be more efficient than using triggers? At the very least
doing validation on the web server will make it easier to add capacity
with multiple web servers.
Keith
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
