hrsweb的博客

错误：Operand should contain 1 column(s)select * from role where id in (select * from users_role where userId = '111'); // 报错了原因：语法错误，where id in 后面只能跟一个字段，select * from查询结果为整张表的字段。修改后：select * from role where id in (select roleId from users_role where u

Oracle设置uuid比较简单，只要用 default SYS_GUID() 修饰字段id就行CREATE TABLE product( id varchar2(32) default SYS_GUID() PRIMARY KEY, productNum VARCHAR2(50) NOT NULL, productName VARCHAR2(50), cityName VARCHAR2(50), DepartureTime timestamp, productPric

约束