select * into Booking2 from Booking;//备份表Booking到Booking2
drop table booking2;//删除表,数据无法恢复
drop from booking2;//删除表中数据(rows),删除数据有可能被找回
数据库权限:
授予其他用户权限
GRANT SELECT
ON TABLE
TO USER
[WITH GRANT OPTION]
撤回权限
REVOKE SELECT
ON TABLE
FROM USER
select * into Booking2 from Booking;//备份表Booking到Booking2
drop table booking2;//删除表,数据无法恢复
drop from booking2;//删除表中数据(rows),删除数据有可能被找回
数据库权限:
授予其他用户权限
GRANT SELECT
ON TABLE
TO USER
[WITH GRANT OPTION]
撤回权限
REVOKE SELECT
ON TABLE
FROM USER