sql server : select replace(newId(),'-','')
oracle :select sys_guid() from dual
1 SQL> select sys_guid() from dual; 2 SYS_GUID() 3 -------------------------------- 4 74CC7FA2ABF7437D9AC29798ACC3E129 5 6 SQL>
mysql :UUID()
JAVA 中获取UUID
1 import java.util.UUID; 2 3 import org.junit.Test; 4 5 public class getUUID { 6 @Test 7 public void getUuid(){ 8 UUID u = UUID.randomUUID(); 9 System.out.println(u.toString().replace("-", "")); 10 } 11 }