0
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 3 years have passed since last update.

カラムの型早見表

Posted at

早見表

概要
primary_key プライマリキー
string 文字列(1〜255文字)
text 長い文字列(1〜4294967296文字)
integer 整数(4バイト)
smallint 値の範囲が-32768~32767の整数を扱うデータ型
bigint 整数(8バイト)
float 浮動小数
decimal 精度の高い少数
numeric 数値
datetime 日時
timestamp 更新時間
binary バイナリーデータ
boolean 真偽値
char 固定長文字列のこと。0~255まで
vachar 可変長文字列のこと。0~65535まで
0
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
0
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?