Hi,
I'm using MySQL 5.1.
How do we create a constraint on char column to accept only character
'A' -
'Z'?
MySQL doesn't have CHECK constraints, I think the only way to do this
is via a BEFORE INSERT trigger.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
