思路
数据备份 -> 表删除 -> 表重建 -> 数据迁移 -> 备份删除
实现
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
| CREATE TEMPORARY TABLE temp1 AS
SELECT
group_number,
q_key,
q_message,
sender_number
FROM t_customize_message;
DROP TABLE t_customize_message;
CREATE TABLE t_customize_message (
group_number NUMERIC,
q_key NVARCHAR,
q_message NVARCHAR,
sender_number NUMERIC
);
INSERT INTO t_customize_message
(group_number,
q_key,
q_message,
sender_number)
SELECT
group_number,
q_key,
q_message,
sender_number
FROM temp1;
DROP TABLE temp1;
|
