哪吒打字编程打字课 MYSQL[数据类型与]

时间： 00:00:00 速度： 0CPM 进度： 0% 总字数： 0准确率： 0%

电脑通识

编程通识

Python

JavaScript

HTML

Linux常用命令

C#入门

MYSQL编程

AI人工智能

Go语言

Rust编程

少儿编程



d

a

t

a

t

y

p

e

ˈdeɪtə taɪp

数据类型，决定列可存储数据的种类和范围



n

u

m

e

r

i

c

njuːˈmerɪk

adj. 数值的，表示数字类型的数据



i

n

t

e

g

e

r

ˈɪntɪdʒə(r)

整数，没有小数部分的数字类型



i

n

t

ɪnt

整数类型，常用的整数数据类型



t

i

n

y

i

n

t

ˈtaɪni ɪnt

微整数类型，范围较小的整数



s

m

a

l

l

i

n

t

smɔːl ɪnt

小整数类型，范围中等的整数



m

e

d

i

u

m

i

n

t

ˈmiːdiəm ɪnt

中整数类型，范围较大的整数



b

i

g

i

n

t

bɪɡ ɪnt

大整数类型，范围最大的整数



d

e

c

i

m

a

l

ˈdesɪml

十进制类型，精确的小数类型



f

l

o

a

t

fləʊt

单精度浮点型，近似的小数类型



d

o

u

b

l

e

ˈdʌbl

双精度浮点型，精度更高的近似小数类型



s

t

r

i

n

g

strɪŋ

字符串，由字符组成的序列



c

h

a

r

tʃɑː(r)

定长字符串类型，长度固定的字符串



v

a

r

c

h

a

r

ˈvɑːtʃə(r)

变长字符串类型，长度可变的字符串



t

i

n

y

t

e

x

t

ˈtaɪni tekst

微文本类型，存储短文本



t

e

x

t

tekst

文本类型，存储较长文本



m

e

d

i

u

m

t

e

x

t

ˈmiːdiəm tekst

中文本类型，存储中等长度文本



l

o

n

g

t

e

x

t

lɒŋ tekst

长文本类型，存储极长文本



b

i

n

a

r

y

ˈbaɪnəri

二进制类型，存储二进制数据



v

a

r

b

i

n

a

r

y

ˈvɑːbaɪnəri

变长二进制类型，长度可变的二进制数据



d

a

t

e

deɪt

日期类型，存储年、月、日



t

i

m

e

taɪm

时间类型，存储时、分、秒



d

a

t

e

t

i

m

e

ˈdeɪt taɪm

日期时间类型，存储年、月、日、时、分、秒



t

i

m

e

s

t

a

m

p

ˈtaɪmstæmp

时间戳类型，存储从 1970 年开始的秒数



y

e

a

r

jɪə(r)

年份类型，存储年份



e

n

u

m

ɪˈnjuːm

枚举类型，只能从预定义值中选择



s

e

t

set

集合类型，可从预定义值中选择多个



c

o

n

s

t

r

a

i

n

t

kənˈstreɪnt

约束，限制列中数据的规则



n

o

t

n

u

l

l

nɒt nʌl

非空约束，列不能存储空值



n

u

l

l

nʌl

空值，表示没有值



u

n

i

q

u

e

juˈniːk

唯一约束，列中的值必须唯一



p

r

i

m

a

r

y

k

e

y

ˈpraɪməri kiː

主键约束，唯一标识表中记录的列



f

o

r

e

i

g

n

k

e

y

ˈfɒrən kiː

外键约束，关联两个表的列



c

h

e

c

k

tʃek

检查约束，限制列中值的范围



d

e

f

a

u

l

t

dɪˈfɔːlt

默认值约束，列的默认值



a

u

t

o

_

i

n

c

r

e

m

e

n

t

ˈɔːtəʊ ˈɪŋkrəmənt

自增约束，列的值自动递增



u

n

s

i

g

n

e

d

ʌnˈsaɪnd

无符号约束，数值类型只能存储非负数



z

e

r

o

f

i

l

l

ˈzɪərəʊ fɪl

零填充约束，数值类型不足位数时用 0 填充

{"title":"\u6570\u636e\u7c7b\u578b\u4e0e\u7ea6\u675f","type":"worden","split":"word","text":["data type#\u02c8de\u026at\u0259 ta\u026ap#\u6570\u636e\u7c7b\u578b\uff0c\u51b3\u5b9a\u5217\u53ef\u5b58\u50a8\u6570\u636e\u7684\u79cd\u7c7b\u548c\u8303\u56f4","numeric#nju\u02d0\u02c8mer\u026ak#adj. \u6570\u503c\u7684\uff0c\u8868\u793a\u6570\u5b57\u7c7b\u578b\u7684\u6570\u636e","integer#\u02c8\u026ant\u026ad\u0292\u0259(r)#\u6574\u6570\uff0c\u6ca1\u6709\u5c0f\u6570\u90e8\u5206\u7684\u6570\u5b57\u7c7b\u578b","int#\u026ant#\u6574\u6570\u7c7b\u578b\uff0c\u5e38\u7528\u7684\u6574\u6570\u6570\u636e\u7c7b\u578b","tinyint#\u02c8ta\u026ani \u026ant#\u5fae\u6574\u6570\u7c7b\u578b\uff0c\u8303\u56f4\u8f83\u5c0f\u7684\u6574\u6570","smallint#sm\u0254\u02d0l \u026ant#\u5c0f\u6574\u6570\u7c7b\u578b\uff0c\u8303\u56f4\u4e2d\u7b49\u7684\u6574\u6570","mediumint#\u02c8mi\u02d0di\u0259m \u026ant#\u4e2d\u6574\u6570\u7c7b\u578b\uff0c\u8303\u56f4\u8f83\u5927\u7684\u6574\u6570","bigint#b\u026a\u0261 \u026ant#\u5927\u6574\u6570\u7c7b\u578b\uff0c\u8303\u56f4\u6700\u5927\u7684\u6574\u6570","decimal#\u02c8des\u026aml#\u5341\u8fdb\u5236\u7c7b\u578b\uff0c\u7cbe\u786e\u7684\u5c0f\u6570\u7c7b\u578b","float#fl\u0259\u028at#\u5355\u7cbe\u5ea6\u6d6e\u70b9\u578b\uff0c\u8fd1\u4f3c\u7684\u5c0f\u6570\u7c7b\u578b","double#\u02c8d\u028cbl#\u53cc\u7cbe\u5ea6\u6d6e\u70b9\u578b\uff0c\u7cbe\u5ea6\u66f4\u9ad8\u7684\u8fd1\u4f3c\u5c0f\u6570\u7c7b\u578b","string#str\u026a\u014b#\u5b57\u7b26\u4e32\uff0c\u7531\u5b57\u7b26\u7ec4\u6210\u7684\u5e8f\u5217","char#t\u0283\u0251\u02d0(r)#\u5b9a\u957f\u5b57\u7b26\u4e32\u7c7b\u578b\uff0c\u957f\u5ea6\u56fa\u5b9a\u7684\u5b57\u7b26\u4e32","varchar#\u02c8v\u0251\u02d0t\u0283\u0259(r)#\u53d8\u957f\u5b57\u7b26\u4e32\u7c7b\u578b\uff0c\u957f\u5ea6\u53ef\u53d8\u7684\u5b57\u7b26\u4e32","tinytext#\u02c8ta\u026ani tekst#\u5fae\u6587\u672c\u7c7b\u578b\uff0c\u5b58\u50a8\u77ed\u6587\u672c","text#tekst#\u6587\u672c\u7c7b\u578b\uff0c\u5b58\u50a8\u8f83\u957f\u6587\u672c","mediumtext#\u02c8mi\u02d0di\u0259m tekst#\u4e2d\u6587\u672c\u7c7b\u578b\uff0c\u5b58\u50a8\u4e2d\u7b49\u957f\u5ea6\u6587\u672c","longtext#l\u0252\u014b tekst#\u957f\u6587\u672c\u7c7b\u578b\uff0c\u5b58\u50a8\u6781\u957f\u6587\u672c","binary#\u02c8ba\u026an\u0259ri#\u4e8c\u8fdb\u5236\u7c7b\u578b\uff0c\u5b58\u50a8\u4e8c\u8fdb\u5236\u6570\u636e","varbinary#\u02c8v\u0251\u02d0ba\u026an\u0259ri#\u53d8\u957f\u4e8c\u8fdb\u5236\u7c7b\u578b\uff0c\u957f\u5ea6\u53ef\u53d8\u7684\u4e8c\u8fdb\u5236\u6570\u636e","date#de\u026at#\u65e5\u671f\u7c7b\u578b\uff0c\u5b58\u50a8\u5e74\u3001\u6708\u3001\u65e5","time#ta\u026am#\u65f6\u95f4\u7c7b\u578b\uff0c\u5b58\u50a8\u65f6\u3001\u5206\u3001\u79d2","datetime#\u02c8de\u026at ta\u026am#\u65e5\u671f\u65f6\u95f4\u7c7b\u578b\uff0c\u5b58\u50a8\u5e74\u3001\u6708\u3001\u65e5\u3001\u65f6\u3001\u5206\u3001\u79d2","timestamp#\u02c8ta\u026amst\u00e6mp#\u65f6\u95f4\u6233\u7c7b\u578b\uff0c\u5b58\u50a8\u4ece 1970 \u5e74\u5f00\u59cb\u7684\u79d2\u6570","year#j\u026a\u0259(r)#\u5e74\u4efd\u7c7b\u578b\uff0c\u5b58\u50a8\u5e74\u4efd","enum#\u026a\u02c8nju\u02d0m#\u679a\u4e3e\u7c7b\u578b\uff0c\u53ea\u80fd\u4ece\u9884\u5b9a\u4e49\u503c\u4e2d\u9009\u62e9","set#set#\u96c6\u5408\u7c7b\u578b\uff0c\u53ef\u4ece\u9884\u5b9a\u4e49\u503c\u4e2d\u9009\u62e9\u591a\u4e2a","constraint#k\u0259n\u02c8stre\u026ant#\u7ea6\u675f\uff0c\u9650\u5236\u5217\u4e2d\u6570\u636e\u7684\u89c4\u5219","not null#n\u0252t n\u028cl#\u975e\u7a7a\u7ea6\u675f\uff0c\u5217\u4e0d\u80fd\u5b58\u50a8\u7a7a\u503c","null#n\u028cl#\u7a7a\u503c\uff0c\u8868\u793a\u6ca1\u6709\u503c","unique#ju\u02c8ni\u02d0k#\u552f\u4e00\u7ea6\u675f\uff0c\u5217\u4e2d\u7684\u503c\u5fc5\u987b\u552f\u4e00","primary key#\u02c8pra\u026am\u0259ri ki\u02d0#\u4e3b\u952e\u7ea6\u675f\uff0c\u552f\u4e00\u6807\u8bc6\u8868\u4e2d\u8bb0\u5f55\u7684\u5217","foreign key#\u02c8f\u0252r\u0259n ki\u02d0#\u5916\u952e\u7ea6\u675f\uff0c\u5173\u8054\u4e24\u4e2a\u8868\u7684\u5217","check#t\u0283ek#\u68c0\u67e5\u7ea6\u675f\uff0c\u9650\u5236\u5217\u4e2d\u503c\u7684\u8303\u56f4","default#d\u026a\u02c8f\u0254\u02d0lt#\u9ed8\u8ba4\u503c\u7ea6\u675f\uff0c\u5217\u7684\u9ed8\u8ba4\u503c","auto_increment#\u02c8\u0254\u02d0t\u0259\u028a \u02c8\u026a\u014bkr\u0259m\u0259nt#\u81ea\u589e\u7ea6\u675f\uff0c\u5217\u7684\u503c\u81ea\u52a8\u9012\u589e","unsigned#\u028cn\u02c8sa\u026and#\u65e0\u7b26\u53f7\u7ea6\u675f\uff0c\u6570\u503c\u7c7b\u578b\u53ea\u80fd\u5b58\u50a8\u975e\u8d1f\u6570","zerofill#\u02c8z\u026a\u0259r\u0259\u028a f\u026al#\u96f6\u586b\u5145\u7ea6\u675f\uff0c\u6570\u503c\u7c7b\u578b\u4e0d\u8db3\u4f4d\u6570\u65f6\u7528 0 \u586b\u5145"],"name":"\u6570\u636e\u7c7b\u578b\u4e0e\u7ea6\u675f","uri":"4-8-002","lock":"","pages":[{"type":"worden","label":"","text":"","chars":"","lock":"","speed":0,"accuracy":0,"focus":"","split":"word","lines":[[{"sound":"\u02c8de\u026at\u0259 ta\u026ap","label":"\u6570\u636e\u7c7b\u578b\uff0c\u51b3\u5b9a\u5217\u53ef\u5b58\u50a8\u6570\u636e\u7684\u79cd\u7c7b\u548c\u8303\u56f4","text":"data type","chars":"data type","pinyin":[{"label":"","chars":"d","text":"d"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"a","text":"a"},{"label":"","chars":" ","text":" "},{"label":"","chars":"t","text":"t"},{"label":"","chars":"y","text":"y"},{"label":"","chars":"p","text":"p"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"nju\u02d0\u02c8mer\u026ak","label":"adj. \u6570\u503c\u7684\uff0c\u8868\u793a\u6570\u5b57\u7c7b\u578b\u7684\u6570\u636e","text":"numeric","chars":"numeric","pinyin":[{"label":"","chars":"n","text":"n"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"c","text":"c"}]}],[{"sound":"\u02c8\u026ant\u026ad\u0292\u0259(r)","label":"\u6574\u6570\uff0c\u6ca1\u6709\u5c0f\u6570\u90e8\u5206\u7684\u6570\u5b57\u7c7b\u578b","text":"integer","chars":"integer","pinyin":[{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"g","text":"g"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"r","text":"r"}]}],[{"sound":"\u026ant","label":"\u6574\u6570\u7c7b\u578b\uff0c\u5e38\u7528\u7684\u6574\u6570\u6570\u636e\u7c7b\u578b","text":"int","chars":"int","pinyin":[{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"\u02c8ta\u026ani \u026ant","label":"\u5fae\u6574\u6570\u7c7b\u578b\uff0c\u8303\u56f4\u8f83\u5c0f\u7684\u6574\u6570","text":"tinyint","chars":"tinyint","pinyin":[{"label":"","chars":"t","text":"t"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"y","text":"y"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"sm\u0254\u02d0l \u026ant","label":"\u5c0f\u6574\u6570\u7c7b\u578b\uff0c\u8303\u56f4\u4e2d\u7b49\u7684\u6574\u6570","text":"smallint","chars":"smallint","pinyin":[{"label":"","chars":"s","text":"s"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"\u02c8mi\u02d0di\u0259m \u026ant","label":"\u4e2d\u6574\u6570\u7c7b\u578b\uff0c\u8303\u56f4\u8f83\u5927\u7684\u6574\u6570","text":"mediumint","chars":"mediumint","pinyin":[{"label":"","chars":"m","text":"m"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"d","text":"d"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"b\u026a\u0261 \u026ant","label":"\u5927\u6574\u6570\u7c7b\u578b\uff0c\u8303\u56f4\u6700\u5927\u7684\u6574\u6570","text":"bigint","chars":"bigint","pinyin":[{"label":"","chars":"b","text":"b"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"g","text":"g"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"\u02c8des\u026aml","label":"\u5341\u8fdb\u5236\u7c7b\u578b\uff0c\u7cbe\u786e\u7684\u5c0f\u6570\u7c7b\u578b","text":"decimal","chars":"decimal","pinyin":[{"label":"","chars":"d","text":"d"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"c","text":"c"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"l","text":"l"}]}],[{"sound":"fl\u0259\u028at","label":"\u5355\u7cbe\u5ea6\u6d6e\u70b9\u578b\uff0c\u8fd1\u4f3c\u7684\u5c0f\u6570\u7c7b\u578b","text":"float","chars":"float","pinyin":[{"label":"","chars":"f","text":"f"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"\u02c8d\u028cbl","label":"\u53cc\u7cbe\u5ea6\u6d6e\u70b9\u578b\uff0c\u7cbe\u5ea6\u66f4\u9ad8\u7684\u8fd1\u4f3c\u5c0f\u6570\u7c7b\u578b","text":"double","chars":"double","pinyin":[{"label":"","chars":"d","text":"d"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"b","text":"b"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"str\u026a\u014b","label":"\u5b57\u7b26\u4e32\uff0c\u7531\u5b57\u7b26\u7ec4\u6210\u7684\u5e8f\u5217","text":"string","chars":"string","pinyin":[{"label":"","chars":"s","text":"s"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"g","text":"g"}]}],[{"sound":"t\u0283\u0251\u02d0(r)","label":"\u5b9a\u957f\u5b57\u7b26\u4e32\u7c7b\u578b\uff0c\u957f\u5ea6\u56fa\u5b9a\u7684\u5b57\u7b26\u4e32","text":"char","chars":"char","pinyin":[{"label":"","chars":"c","text":"c"},{"label":"","chars":"h","text":"h"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"r","text":"r"}]}],[{"sound":"\u02c8v\u0251\u02d0t\u0283\u0259(r)","label":"\u53d8\u957f\u5b57\u7b26\u4e32\u7c7b\u578b\uff0c\u957f\u5ea6\u53ef\u53d8\u7684\u5b57\u7b26\u4e32","text":"varchar","chars":"varchar","pinyin":[{"label":"","chars":"v","text":"v"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"c","text":"c"},{"label":"","chars":"h","text":"h"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"r","text":"r"}]}],[{"sound":"\u02c8ta\u026ani tekst","label":"\u5fae\u6587\u672c\u7c7b\u578b\uff0c\u5b58\u50a8\u77ed\u6587\u672c","text":"tinytext","chars":"tinytext","pinyin":[{"label":"","chars":"t","text":"t"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"y","text":"y"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"x","text":"x"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"tekst","label":"\u6587\u672c\u7c7b\u578b\uff0c\u5b58\u50a8\u8f83\u957f\u6587\u672c","text":"text","chars":"text","pinyin":[{"label":"","chars":"t","text":"t"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"x","text":"x"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"\u02c8mi\u02d0di\u0259m tekst","label":"\u4e2d\u6587\u672c\u7c7b\u578b\uff0c\u5b58\u50a8\u4e2d\u7b49\u957f\u5ea6\u6587\u672c","text":"mediumtext","chars":"mediumtext","pinyin":[{"label":"","chars":"m","text":"m"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"d","text":"d"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"x","text":"x"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"l\u0252\u014b tekst","label":"\u957f\u6587\u672c\u7c7b\u578b\uff0c\u5b58\u50a8\u6781\u957f\u6587\u672c","text":"longtext","chars":"longtext","pinyin":[{"label":"","chars":"l","text":"l"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"g","text":"g"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"x","text":"x"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"\u02c8ba\u026an\u0259ri","label":"\u4e8c\u8fdb\u5236\u7c7b\u578b\uff0c\u5b58\u50a8\u4e8c\u8fdb\u5236\u6570\u636e","text":"binary","chars":"binary","pinyin":[{"label":"","chars":"b","text":"b"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"y","text":"y"}]}],[{"sound":"\u02c8v\u0251\u02d0ba\u026an\u0259ri","label":"\u53d8\u957f\u4e8c\u8fdb\u5236\u7c7b\u578b\uff0c\u957f\u5ea6\u53ef\u53d8\u7684\u4e8c\u8fdb\u5236\u6570\u636e","text":"varbinary","chars":"varbinary","pinyin":[{"label":"","chars":"v","text":"v"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"b","text":"b"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"y","text":"y"}]}],[{"sound":"de\u026at","label":"\u65e5\u671f\u7c7b\u578b\uff0c\u5b58\u50a8\u5e74\u3001\u6708\u3001\u65e5","text":"date","chars":"date","pinyin":[{"label":"","chars":"d","text":"d"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"ta\u026am","label":"\u65f6\u95f4\u7c7b\u578b\uff0c\u5b58\u50a8\u65f6\u3001\u5206\u3001\u79d2","text":"time","chars":"time","pinyin":[{"label":"","chars":"t","text":"t"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"\u02c8de\u026at ta\u026am","label":"\u65e5\u671f\u65f6\u95f4\u7c7b\u578b\uff0c\u5b58\u50a8\u5e74\u3001\u6708\u3001\u65e5\u3001\u65f6\u3001\u5206\u3001\u79d2","text":"datetime","chars":"datetime","pinyin":[{"label":"","chars":"d","text":"d"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"\u02c8ta\u026amst\u00e6mp","label":"\u65f6\u95f4\u6233\u7c7b\u578b\uff0c\u5b58\u50a8\u4ece 1970 \u5e74\u5f00\u59cb\u7684\u79d2\u6570","text":"timestamp","chars":"timestamp","pinyin":[{"label":"","chars":"t","text":"t"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"s","text":"s"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"p","text":"p"}]}],[{"sound":"j\u026a\u0259(r)","label":"\u5e74\u4efd\u7c7b\u578b\uff0c\u5b58\u50a8\u5e74\u4efd","text":"year","chars":"year","pinyin":[{"label":"","chars":"y","text":"y"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"r","text":"r"}]}],[{"sound":"\u026a\u02c8nju\u02d0m","label":"\u679a\u4e3e\u7c7b\u578b\uff0c\u53ea\u80fd\u4ece\u9884\u5b9a\u4e49\u503c\u4e2d\u9009\u62e9","text":"enum","chars":"enum","pinyin":[{"label":"","chars":"e","text":"e"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"m","text":"m"}]}],[{"sound":"set","label":"\u96c6\u5408\u7c7b\u578b\uff0c\u53ef\u4ece\u9884\u5b9a\u4e49\u503c\u4e2d\u9009\u62e9\u591a\u4e2a","text":"set","chars":"set","pinyin":[{"label":"","chars":"s","text":"s"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"k\u0259n\u02c8stre\u026ant","label":"\u7ea6\u675f\uff0c\u9650\u5236\u5217\u4e2d\u6570\u636e\u7684\u89c4\u5219","text":"constraint","chars":"constraint","pinyin":[{"label":"","chars":"c","text":"c"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"s","text":"s"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"n\u0252t n\u028cl","label":"\u975e\u7a7a\u7ea6\u675f\uff0c\u5217\u4e0d\u80fd\u5b58\u50a8\u7a7a\u503c","text":"not null","chars":"not null","pinyin":[{"label":"","chars":"n","text":"n"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"t","text":"t"},{"label":"","chars":" ","text":" "},{"label":"","chars":"n","text":"n"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"l","text":"l"}]}],[{"sound":"n\u028cl","label":"\u7a7a\u503c\uff0c\u8868\u793a\u6ca1\u6709\u503c","text":"null","chars":"null","pinyin":[{"label":"","chars":"n","text":"n"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"l","text":"l"}]}],[{"sound":"ju\u02c8ni\u02d0k","label":"\u552f\u4e00\u7ea6\u675f\uff0c\u5217\u4e2d\u7684\u503c\u5fc5\u987b\u552f\u4e00","text":"unique","chars":"unique","pinyin":[{"label":"","chars":"u","text":"u"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"q","text":"q"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"\u02c8pra\u026am\u0259ri ki\u02d0","label":"\u4e3b\u952e\u7ea6\u675f\uff0c\u552f\u4e00\u6807\u8bc6\u8868\u4e2d\u8bb0\u5f55\u7684\u5217","text":"primary key","chars":"primary key","pinyin":[{"label":"","chars":"p","text":"p"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"y","text":"y"},{"label":"","chars":" ","text":" "},{"label":"","chars":"k","text":"k"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"y","text":"y"}]}],[{"sound":"\u02c8f\u0252r\u0259n ki\u02d0","label":"\u5916\u952e\u7ea6\u675f\uff0c\u5173\u8054\u4e24\u4e2a\u8868\u7684\u5217","text":"foreign key","chars":"foreign key","pinyin":[{"label":"","chars":"f","text":"f"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"g","text":"g"},{"label":"","chars":"n","text":"n"},{"label":"","chars":" ","text":" "},{"label":"","chars":"k","text":"k"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"y","text":"y"}]}],[{"sound":"t\u0283ek","label":"\u68c0\u67e5\u7ea6\u675f\uff0c\u9650\u5236\u5217\u4e2d\u503c\u7684\u8303\u56f4","text":"check","chars":"check","pinyin":[{"label":"","chars":"c","text":"c"},{"label":"","chars":"h","text":"h"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"c","text":"c"},{"label":"","chars":"k","text":"k"}]}],[{"sound":"d\u026a\u02c8f\u0254\u02d0lt","label":"\u9ed8\u8ba4\u503c\u7ea6\u675f\uff0c\u5217\u7684\u9ed8\u8ba4\u503c","text":"default","chars":"default","pinyin":[{"label":"","chars":"d","text":"d"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"f","text":"f"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"\u02c8\u0254\u02d0t\u0259\u028a \u02c8\u026a\u014bkr\u0259m\u0259nt","label":"\u81ea\u589e\u7ea6\u675f\uff0c\u5217\u7684\u503c\u81ea\u52a8\u9012\u589e","text":"auto_increment","chars":"auto_increment","pinyin":[{"label":"","chars":"a","text":"a"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"_","text":"_"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"c","text":"c"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"\u028cn\u02c8sa\u026and","label":"\u65e0\u7b26\u53f7\u7ea6\u675f\uff0c\u6570\u503c\u7c7b\u578b\u53ea\u80fd\u5b58\u50a8\u975e\u8d1f\u6570","text":"unsigned","chars":"unsigned","pinyin":[{"label":"","chars":"u","text":"u"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"s","text":"s"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"g","text":"g"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"d","text":"d"}]}],[{"sound":"\u02c8z\u026a\u0259r\u0259\u028a f\u026al","label":"\u96f6\u586b\u5145\u7ea6\u675f\uff0c\u6570\u503c\u7c7b\u578b\u4e0d\u8db3\u4f4d\u6570\u65f6\u7528 0 \u586b\u5145","text":"zerofill","chars":"zerofill","pinyin":[{"label":"","chars":"z","text":"z"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"f","text":"f"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"l","text":"l"}]}]]}],"section":"MYSQL\u7f16\u7a0b","section_id":"8","course_id":"4","course_type":0,"pre_uri":"4-8-001","next_uri":"4-8-003"}

鼠标点我 或按 空格键 开始