Mariadb 分表

最新推荐文章于 2024-03-29 09:29:31 发布

OneGoal

最新推荐文章于 2024-03-29 09:29:31 发布

阅读量1k

点赞数

分类专栏： mariadb

本文链接：https://blog.csdn.net/OneGoal/article/details/77994508

版权

mariadb 专栏收录该内容

1 篇文章 0 订阅

订阅专栏



CREATE TABLE `tablename` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `to_message_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `to_user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `news_id` int(10) UNSIGNED NOT NULL,
  `message` text NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MERGE union=(tablename_message1s,tablename_message2s,tablename_message3s,tablename_message4s,tablename_message5s,tablename_message6s,tablename_message7s,tablename_message8s,tablename_message9s,tablename_message10s) INSERT_METHOD=LAST DEFAULT CHARSET=utf8;

ALTER TABLE `tablename`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tablename`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;