2
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 1 year has passed since last update.

MySQLにて行サイズを無視してテーブル作成

Posted at
set session innodb_strict_mode = OFF;

ここでcreate文

set session innodb_strict_mode = ON;

strict mode確認

SHOW VARIABLES LIKE 'innodb_strict_mode';

※ 本来やらない作業だが前任者が無理やり無茶なテーブルをつくってしまい
引き継いだ私がカラムのAdd ,カラムのDropもできなくなった。

(Dropしたあとでも行サイズが制限超えるため Dropすらエラーになった。。。)

ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not coun
ting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some
 columns to TEXT or BLOBs
2
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
2
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?