1.从两张表中查找相同的部分:
select A1.PHONE_NUMBER,A2.PHONE_NUMBER from records_121117 A1,records_new A2 where A1.start_time =A2.start_time;
//注意变量名要重新定义:此语句的意思是:从records_121117(重新命名为A1)和records_new (A2)找出start_time相同的表项
2.改变列的名称
ALTER TABLE 表的名字 RENAME COLUMN 列的旧名字 TO 列的新名字;