2. 添加外键 alter table orders add foreign key(goods_id) references goods(sid) on update cascade on delete cascade; on update cascade: 被引用行更新时,引用行自动更新; on update restrict: 被引用的行禁止更新; on delete cascade: 被引用行删除时,引用行也一起删除; on dellete restrict: 被引用的...
on update cascade # 同步更新 on delete cascade # 同步删除 ); #建立作者表 create table author( id int primary key auto_increment, name varchar(32), age int, book_id int, foreign key(book_id) references book(id) on update cascade # 同步更新 on delete cascade # 同步删除 ); """ 按照...
is_active | boolean | not null | plain 8 | |falseIndexes:"table_name_pkey"PRIMARY KEY, btree (id) Foreign keys:"table_name_user_id_fkey"FOREIGN KEY (user_id) REFERENCES"users"(id) ON DELETE CASCADE ON UPDATE CASCADE Check constraints:"table_name_check_user_id"CHECK (user_id IS NOT...
createtableug(uidint, gidint, uptimevarchar(30));CREATETRIGGERt_ug_updateTime AFTERINSERTORUPDATEONugFOREACHROWEXECUTEPROCEDUREfunc_ug_updateTime(); 可以看到直接删除触发器函数时,如果该触发器函数被某个触发器依赖,那么就会报错,此时需要在删除触发器函数的时候,添加cascade参数,从而将该触发器函数与依赖与...
ALTER TABLE "Post" ADD CONSTRAINT "Post_authorId_fkey" FOREIGN KEY ("authorId") REFERENCES "User"("id") ON DELETE SET NULL ON UPDATE CASCADE; 此时我们可以打开 PostgreSQL 客户端查看建表情况: 在这一节中,我们在 Prisma schema 中定义了数据模型,并使用 Prisma Migrate 创建了相应的数据库表。在下...
ON UPDATE CASCADE ON DELETE CASCADE ) """, """ CREATE TABLE vendor_parts ( vendor_id INTEGER NOT NULL, part_id INTEGER NOT NULL, PRIMARY KEY (vendor_id , part_id), FOREIGN KEY (vendor_id) REFERENCES vendors (vendor_id) ON UPDATE CASCADE ON DELETE CASCADE, ...
(part_id) ON UPDATE CASCADE ON DELETE CASCADE ) """, """ CREATE TABLE vendor_parts ( vendor_id INTEGER NOT NULL, part_id INTEGER NOT NULL, PRIMARY KEY (vendor_id , part_id), FOREIGN KEY (vendor_id) REFERENCES vendors (vendor_id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (...
beigang=# grantall on schema csm_ca to public;GRANT beigang=# revoke all on schema csm_ca frompublic;REVOKE 8、先创建⼀个⾓⾊xxx，再创建⼀个超级⽤户csm、普通⽤户csm_ca，csm⽤户创建⼀个数据库testdb，在这个数据库⾥创建⼀个schema：csm_ca，然后赋予普通⽤户csm_ca操作数据库...
DROP VIEW [ IF EXISTS ] name [ CASCADE | RESTRICT ]; 其中,IF EXISTS 可以避免删除一个不存在的视图时产生错误;CASCADE 表示级联删除依赖于该视图的对象;RESTRICT 表示如果存在依赖对象则提示错误信息,这是默认值。 我们将视图 emp_info_view 删除: ...
REVOKE [ GRANT OPTION FOR ] { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] } ON [ TABLE ] table_name [, ...] FROM { username | GROUP group_name | PUBLIC } [, ...] [ CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FOR ...