I am new to using MYSQL usually use MSSQL.
I have a table called record
pk is record_uid (auto increments)
there is a column called record_uid_hash
this is a MD5 of record_uid
I want to create a trigger so when a new record is created the MD5 of
the record_uid is entered into the row.
MD5(record_uid)
I can't seem to get the syntax correct.
I use NAVACAT to admin the DB I am getting a message saying no such
trigger.
Any help would be appreciated.
Dan
--
Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
FMP, WiTango, EDI,SQL 2000, MySQL, PHP
[EMAIL PROTECTED]
www.dss-db.com
"The love of one's country is a splendid thing. But why should love
stop at the border? "
Pablo Casals
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf