sm_rename_column.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 16 行

CREATE TABLE  sm_temp AS
SELECT empid,name,salary,telno,address empaddress
FROM sm_emp;

desc sm_temp;

DROP TABLE sm_emp;

RENAME sm_temp TO sm_emp;

DESC sm_emp;

--在create table
CREATE TABLE  sm_temp2(id,name,sal,aa) AS
SELECT empid,name,salary,telno empaddress
FROM sm_emp;