想把表名字从 pp 改为 person
方法一: ALTER TABLE pp RENAME TO person
方法二:RENAME pp TO person
方法三:建一张新表包含原始表数据,然后把旧表删除 CREATE TABLE person AS SELECT * FROM pp ; DROP TABLE pp
想把表名字从 pp 改为 person
方法一: ALTER TABLE pp RENAME TO person
方法二:RENAME pp TO person
方法三:建一张新表包含原始表数据,然后把旧表删除 CREATE TABLE person AS SELECT * FROM pp ; DROP TABLE pp