变更主键的表数据迁移

最新推荐文章于 2024-08-05 15:06:56 发布

qq_26909291

最新推荐文章于 2024-08-05 15:06:56 发布

阅读量695

点赞数 1

CC 4.0 BY-SA版权

分类专栏：技术

本文链接：https://blog.youkuaiyun.com/qq_26909291/article/details/73859182

技术专栏收录该内容

8 篇文章

订阅专栏

/**
 * 表数据迁移
 *
 * @param context
 */
public static final String TEMP_SQL_CREATE_TABLE_SUBSCRIBE = "alter table "
        + T_LOCAL_VIDEO + " rename to temp_" + T_LOCAL_VIDEO;
public static final String CREATE_NEW_TABLE = "CREATE TABLE IF NOT EXISTS " + T_LOCAL_VIDEO
        + "("
        + "id" + " INTEGER PRIMARY KEY autoincrement , "
        + XXX + " VARCHAR(32) , "
        + XXXX + " VARCHAR(32)  , "
        + XXXXX + " VARCHAR(32) , "
        + XXXXX + " VARCHAR(32) , "
        + XXXXXX + " VARCHAR(32) , "
        + XXXXXXX + " VARCHAR(32) , "
        + XXXXXXXX + " BIGINT "
        + ")";
public static final String DATA_TRANSFER = "INSERT INTO " + T_LOCAL_VIDEO + " SELECT " + "null," + XXX + "," + XXXX + "," + XXXXX +
        "," + XXXXXX + "," + XXXXXXX + "," + XXXXXXXX + "," + XXXXXXXXX + " FROM temp_" + T_LOCAL_VIDEO;


public static final String DELETE_TEMP_TABLE = "DROP TABLE IF EXISTS temp_" + T_LOCAL_VIDEO;