MySQL-自动递增到guid [英] MySQL - autoincrement to guid

问题描述

我有一个带有自动递增ID字段的表，如下所示.

I have a table with an auto-increment ID field as shown below.

+------------+-------------------------------------+
| company_id | name                                |
+------------+-------------------------------------+
|          1 | International Client                |
|          2 | Oracle                              |
|          3 | test                                |
|          4 | testabc                             |
|          5 | testdef                             |
|          6 | abcd                                |
+------------+-------------------------------------+

我想使用

uuid()

函数将ID列更新为GUID.

function.

此外，如何将外键引用更新为正确的GUID?

Additionally, how do I update the foreign key references to the correct GUID?

推荐答案

使用触发器.

CREATE TABLE `tbl_test` (
  `GUID` char(40) NOT NULL,
  `Name` varchar(50) NOT NULL,
  PRIMARY KEY (`GUID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

表和pk，现在触发..

table and pk, now trigger..

DELIMITER //
CREATE TRIGGER `t_GUID` BEFORE INSERT ON `tbl_test`
 FOR EACH ROW begin
 SET new.GUID = uuid();
end//
DELIMITER ;

现在尝试，

insert into tbl_test(Name) value('trigger happy...');

致谢， /t

这篇关于MySQL-自动递增到guid的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！