In MySQL version 5 onwards you can use Triggers<\/a>, triggers are a nice was of checking values within a insert\/update\/delete process. A trigger happens either just before the insert actually happens into the database, or just after<\/p>\n Lets say that you create a table as below<\/p>\n and then if you want to insert a name into the name column you could do<\/p>\n but you are not inserting the anything into the guid column because you can force a value into that column with a trigger (the id is already creating a value with the primary key, auto_increment).<\/p>\n To create a trigger you need to set the delimiter to “\/\/” because within sql you need to use the “;” which is the standard delimiter (when the MySQL will try and execute the query)<\/p>\n “CREATE TRIGGER” is just like creating a table, apart from you are creating a trigger, so the next value is the trigger name, normally it is the table name with what you are doing, e.g. inserting<\/p>\n “BEFORE INSERT ON” means before you actually insert the data into the database (it is in a hold area as such). the next value is the actual table that you are linking this trigger to.<\/p>\n “FOR EACH ROW” means each row of the insert, since you can insert x amount of lines into a table.<\/p>\n the sql code is between the “BEGIN” and “END”, and all is what is being set is the guid column within the “NEW” (this is the new row to be inserted) and setting that value to uuid<\/a>() which is a mysql function.<\/p>\n so before you would have inserted into a table and the table would have looked like<\/p>\n\r\ncreate table testTable \r\n(id int not null auto_increment, \r\n guid varchar(36), \r\n name varchar(100), \r\nprimary key (id));\r\n<\/pre>\n
\r\ninsert into testTable (name) values (\"thename\");\r\n<\/pre>\n
\r\ndelimiter \/\/\r\nCREATE TRIGGER testTable_insert \r\nBEFORE INSERT ON 'testTable' \r\nFOR EACH ROW \r\nBEGIN \r\n SET NEW.guid = uuid(); \r\nEND;\r\ndelimiter ;\r\n<\/pre>\n