哪吒打字编程打字课 MYSQL[创建与管理]

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

电脑通识

编程通识

Python

JavaScript

HTML

Linux常用命令

C#入门

MYSQL编程

AI人工智能

Go语言

Rust编程

少儿编程



c

r

e

a

t

e

t

a

b

l

e

kriˈeɪt ˈteɪbl

创建数据表的关键字



d

r

o

p

t

a

b

l

e

drɒp ˈteɪbl

删除数据表的关键字



a

l

t

e

r

t

a

b

l

e

ˈɔːltə ˈteɪbl

修改数据表结构的关键字



r

e

n

a

m

e

t

a

b

l

e

ˌriːˈneɪm ˈteɪbl

重命名数据表的关键字



t

r

u

n

c

a

t

e

t

a

b

l

e

trʌŋˈkeɪt ˈteɪbl

清空数据表数据并重置自增的命令



t

a

b

l

e

s

t

r

u

c

t

u

r

e

ˈteɪbl ˈstrʌktʃə(r)

数据表结构，表的列、类型、约束等组成



c

o

l

u

m

n

n

a

m

e

ˈkɒləm neɪm

列名，数据表中列的标识



d

a

t

a

t

y

p

e

ˈdeɪtə taɪp

数据类型，列存储数据的类型



c

o

n

s

t

r

a

i

n

t

kənˈstreɪnt

约束，对列数据的限制条件



i

f

n

o

t

e

x

i

s

t

s

ɪf nɒt ɪɡˈzɪsts

创建表时判断是否存在的条件



i

f

e

x

i

s

t

s

ɪf ɪɡˈzɪsts

删除表时判断是否存在的条件



e

n

g

i

n

e

ˈendʒɪn

存储引擎，数据表的存储方式



c

h

a

r

s

e

t

ˈtʃɑːset

字符集，表中字符数据的编码方式



c

o

l

l

a

t

e

kəˈleɪt

校对规则，字符比较的规则



c

o

m

m

e

n

t

ˈkɒment

注释，对表或列进行说明的文字



s

h

o

w

t

a

b

l

e

s

ʃəʊ ˈteɪblz

显示当前数据库中所有表的命令



d

e

s

c

dɪˈskraɪb

查看数据表结构的命令



d

e

s

c

r

i

b

e

dɪˈskraɪb

与 desc 功能相同，查看数据表结构



s

h

o

w

c

r

e

a

t

e

t

a

b

l

e

ʃəʊ kriˈeɪt ˈteɪbl

查看创建表的 SQL 语句



a

d

d

c

o

l

u

m

n

æd ˈkɒləm

向表中添加新列



d

r

o

p

c

o

l

u

m

n

drɒp ˈkɒləm

从表中删除列



m

o

d

i

f

y

c

o

l

u

m

n

ˈmɒdɪfaɪ ˈkɒləm

修改列的数据类型或约束



c

h

a

n

g

e

c

o

l

u

m

n

tʃeɪndʒ ˈkɒləm

修改列名及数据类型等



r

e

n

a

m

e

c

o

l

u

m

n

ˌriːˈneɪm ˈkɒləm

重命名列



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ː

外键，关联其他表的列



u

n

i

q

u

e

juˈniːk

唯一约束，列值不可重复



n

o

t

n

u

l

l

nɒt nʌl

非空约束，列值不可为 null



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

自增，列值自动递增

{"title":"\u521b\u5efa\u4e0e\u7ba1\u7406\u6570\u636e\u8868","type":"worden","split":"word","text":["create table#kri\u02c8e\u026at \u02c8te\u026abl#\u521b\u5efa\u6570\u636e\u8868\u7684\u5173\u952e\u5b57","drop table#dr\u0252p \u02c8te\u026abl#\u5220\u9664\u6570\u636e\u8868\u7684\u5173\u952e\u5b57","alter table#\u02c8\u0254\u02d0lt\u0259 \u02c8te\u026abl#\u4fee\u6539\u6570\u636e\u8868\u7ed3\u6784\u7684\u5173\u952e\u5b57","rename table#\u02ccri\u02d0\u02c8ne\u026am \u02c8te\u026abl#\u91cd\u547d\u540d\u6570\u636e\u8868\u7684\u5173\u952e\u5b57","truncate table#tr\u028c\u014b\u02c8ke\u026at \u02c8te\u026abl#\u6e05\u7a7a\u6570\u636e\u8868\u6570\u636e\u5e76\u91cd\u7f6e\u81ea\u589e\u7684\u547d\u4ee4","table structure#\u02c8te\u026abl \u02c8str\u028ckt\u0283\u0259(r)#\u6570\u636e\u8868\u7ed3\u6784\uff0c\u8868\u7684\u5217\u3001\u7c7b\u578b\u3001\u7ea6\u675f\u7b49\u7ec4\u6210","column name#\u02c8k\u0252l\u0259m ne\u026am#\u5217\u540d\uff0c\u6570\u636e\u8868\u4e2d\u5217\u7684\u6807\u8bc6","data type#\u02c8de\u026at\u0259 ta\u026ap#\u6570\u636e\u7c7b\u578b\uff0c\u5217\u5b58\u50a8\u6570\u636e\u7684\u7c7b\u578b","constraint#k\u0259n\u02c8stre\u026ant#\u7ea6\u675f\uff0c\u5bf9\u5217\u6570\u636e\u7684\u9650\u5236\u6761\u4ef6","if not exists#\u026af n\u0252t \u026a\u0261\u02c8z\u026asts#\u521b\u5efa\u8868\u65f6\u5224\u65ad\u662f\u5426\u5b58\u5728\u7684\u6761\u4ef6","if exists#\u026af \u026a\u0261\u02c8z\u026asts#\u5220\u9664\u8868\u65f6\u5224\u65ad\u662f\u5426\u5b58\u5728\u7684\u6761\u4ef6","engine#\u02c8end\u0292\u026an#\u5b58\u50a8\u5f15\u64ce\uff0c\u6570\u636e\u8868\u7684\u5b58\u50a8\u65b9\u5f0f","charset#\u02c8t\u0283\u0251\u02d0set#\u5b57\u7b26\u96c6\uff0c\u8868\u4e2d\u5b57\u7b26\u6570\u636e\u7684\u7f16\u7801\u65b9\u5f0f","collate#k\u0259\u02c8le\u026at#\u6821\u5bf9\u89c4\u5219\uff0c\u5b57\u7b26\u6bd4\u8f83\u7684\u89c4\u5219","comment#\u02c8k\u0252ment#\u6ce8\u91ca\uff0c\u5bf9\u8868\u6216\u5217\u8fdb\u884c\u8bf4\u660e\u7684\u6587\u5b57","show tables#\u0283\u0259\u028a \u02c8te\u026ablz#\u663e\u793a\u5f53\u524d\u6570\u636e\u5e93\u4e2d\u6240\u6709\u8868\u7684\u547d\u4ee4","desc#d\u026a\u02c8skra\u026ab#\u67e5\u770b\u6570\u636e\u8868\u7ed3\u6784\u7684\u547d\u4ee4","describe#d\u026a\u02c8skra\u026ab#\u4e0e desc \u529f\u80fd\u76f8\u540c\uff0c\u67e5\u770b\u6570\u636e\u8868\u7ed3\u6784","show create table#\u0283\u0259\u028a kri\u02c8e\u026at \u02c8te\u026abl#\u67e5\u770b\u521b\u5efa\u8868\u7684 SQL \u8bed\u53e5","add column#\u00e6d \u02c8k\u0252l\u0259m#\u5411\u8868\u4e2d\u6dfb\u52a0\u65b0\u5217","drop column#dr\u0252p \u02c8k\u0252l\u0259m#\u4ece\u8868\u4e2d\u5220\u9664\u5217","modify column#\u02c8m\u0252d\u026afa\u026a \u02c8k\u0252l\u0259m#\u4fee\u6539\u5217\u7684\u6570\u636e\u7c7b\u578b\u6216\u7ea6\u675f","change column#t\u0283e\u026and\u0292 \u02c8k\u0252l\u0259m#\u4fee\u6539\u5217\u540d\u53ca\u6570\u636e\u7c7b\u578b\u7b49","rename column#\u02ccri\u02d0\u02c8ne\u026am \u02c8k\u0252l\u0259m#\u91cd\u547d\u540d\u5217","primary key#\u02c8pra\u026am\u0259ri ki\u02d0#\u4e3b\u952e\uff0c\u552f\u4e00\u6807\u8bc6\u8868\u4e2d\u8bb0\u5f55\u7684\u5217","foreign key#\u02c8f\u0252r\u0259n ki\u02d0#\u5916\u952e\uff0c\u5173\u8054\u5176\u4ed6\u8868\u7684\u5217","unique#ju\u02c8ni\u02d0k#\u552f\u4e00\u7ea6\u675f\uff0c\u5217\u503c\u4e0d\u53ef\u91cd\u590d","not null#n\u0252t n\u028cl#\u975e\u7a7a\u7ea6\u675f\uff0c\u5217\u503c\u4e0d\u53ef\u4e3a null","default#d\u026a\u02c8f\u0254\u02d0lt#\u9ed8\u8ba4\u503c\uff0c\u5217\u7684\u9ed8\u8ba4\u6570\u636e","auto_increment#\u02c8\u0254\u02d0t\u0259\u028a \u02c8\u026a\u014bkr\u0259m\u0259nt#\u81ea\u589e\uff0c\u5217\u503c\u81ea\u52a8\u9012\u589e"],"name":"\u521b\u5efa\u4e0e\u7ba1\u7406\u6570\u636e\u8868","uri":"4-8-003","lock":"","pages":[{"type":"worden","label":"","text":"","chars":"","lock":"","speed":0,"accuracy":0,"focus":"","split":"word","lines":[[{"sound":"kri\u02c8e\u026at \u02c8te\u026abl","label":"\u521b\u5efa\u6570\u636e\u8868\u7684\u5173\u952e\u5b57","text":"create table","chars":"create table","pinyin":[{"label":"","chars":"c","text":"c"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"e","text":"e"},{"label":"","chars":" ","text":" "},{"label":"","chars":"t","text":"t"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"b","text":"b"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"dr\u0252p \u02c8te\u026abl","label":"\u5220\u9664\u6570\u636e\u8868\u7684\u5173\u952e\u5b57","text":"drop table","chars":"drop table","pinyin":[{"label":"","chars":"d","text":"d"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"p","text":"p"},{"label":"","chars":" ","text":" "},{"label":"","chars":"t","text":"t"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"b","text":"b"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"\u02c8\u0254\u02d0lt\u0259 \u02c8te\u026abl","label":"\u4fee\u6539\u6570\u636e\u8868\u7ed3\u6784\u7684\u5173\u952e\u5b57","text":"alter table","chars":"alter table","pinyin":[{"label":"","chars":"a","text":"a"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"r","text":"r"},{"label":"","chars":" ","text":" "},{"label":"","chars":"t","text":"t"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"b","text":"b"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"\u02ccri\u02d0\u02c8ne\u026am \u02c8te\u026abl","label":"\u91cd\u547d\u540d\u6570\u636e\u8868\u7684\u5173\u952e\u5b57","text":"rename table","chars":"rename table","pinyin":[{"label":"","chars":"r","text":"r"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"e","text":"e"},{"label":"","chars":" ","text":" "},{"label":"","chars":"t","text":"t"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"b","text":"b"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"tr\u028c\u014b\u02c8ke\u026at \u02c8te\u026abl","label":"\u6e05\u7a7a\u6570\u636e\u8868\u6570\u636e\u5e76\u91cd\u7f6e\u81ea\u589e\u7684\u547d\u4ee4","text":"truncate table","chars":"truncate table","pinyin":[{"label":"","chars":"t","text":"t"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"c","text":"c"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"e","text":"e"},{"label":"","chars":" ","text":" "},{"label":"","chars":"t","text":"t"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"b","text":"b"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"\u02c8te\u026abl \u02c8str\u028ckt\u0283\u0259(r)","label":"\u6570\u636e\u8868\u7ed3\u6784\uff0c\u8868\u7684\u5217\u3001\u7c7b\u578b\u3001\u7ea6\u675f\u7b49\u7ec4\u6210","text":"table structure","chars":"table structure","pinyin":[{"label":"","chars":"t","text":"t"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"b","text":"b"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"e","text":"e"},{"label":"","chars":" ","text":" "},{"label":"","chars":"s","text":"s"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"c","text":"c"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"\u02c8k\u0252l\u0259m ne\u026am","label":"\u5217\u540d\uff0c\u6570\u636e\u8868\u4e2d\u5217\u7684\u6807\u8bc6","text":"column name","chars":"column name","pinyin":[{"label":"","chars":"c","text":"c"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"n","text":"n"},{"label":"","chars":" ","text":" "},{"label":"","chars":"n","text":"n"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"\u02c8de\u026at\u0259 ta\u026ap","label":"\u6570\u636e\u7c7b\u578b\uff0c\u5217\u5b58\u50a8\u6570\u636e\u7684\u7c7b\u578b","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":"k\u0259n\u02c8stre\u026ant","label":"\u7ea6\u675f\uff0c\u5bf9\u5217\u6570\u636e\u7684\u9650\u5236\u6761\u4ef6","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":"\u026af n\u0252t \u026a\u0261\u02c8z\u026asts","label":"\u521b\u5efa\u8868\u65f6\u5224\u65ad\u662f\u5426\u5b58\u5728\u7684\u6761\u4ef6","text":"if not exists","chars":"if not exists","pinyin":[{"label":"","chars":"i","text":"i"},{"label":"","chars":"f","text":"f"},{"label":"","chars":" ","text":" "},{"label":"","chars":"n","text":"n"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"t","text":"t"},{"label":"","chars":" ","text":" "},{"label":"","chars":"e","text":"e"},{"label":"","chars":"x","text":"x"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"s","text":"s"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"s","text":"s"}]}],[{"sound":"\u026af \u026a\u0261\u02c8z\u026asts","label":"\u5220\u9664\u8868\u65f6\u5224\u65ad\u662f\u5426\u5b58\u5728\u7684\u6761\u4ef6","text":"if exists","chars":"if exists","pinyin":[{"label":"","chars":"i","text":"i"},{"label":"","chars":"f","text":"f"},{"label":"","chars":" ","text":" "},{"label":"","chars":"e","text":"e"},{"label":"","chars":"x","text":"x"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"s","text":"s"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"s","text":"s"}]}],[{"sound":"\u02c8end\u0292\u026an","label":"\u5b58\u50a8\u5f15\u64ce\uff0c\u6570\u636e\u8868\u7684\u5b58\u50a8\u65b9\u5f0f","text":"engine","chars":"engine","pinyin":[{"label":"","chars":"e","text":"e"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"g","text":"g"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"\u02c8t\u0283\u0251\u02d0set","label":"\u5b57\u7b26\u96c6\uff0c\u8868\u4e2d\u5b57\u7b26\u6570\u636e\u7684\u7f16\u7801\u65b9\u5f0f","text":"charset","chars":"charset","pinyin":[{"label":"","chars":"c","text":"c"},{"label":"","chars":"h","text":"h"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"s","text":"s"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"k\u0259\u02c8le\u026at","label":"\u6821\u5bf9\u89c4\u5219\uff0c\u5b57\u7b26\u6bd4\u8f83\u7684\u89c4\u5219","text":"collate","chars":"collate","pinyin":[{"label":"","chars":"c","text":"c"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"\u02c8k\u0252ment","label":"\u6ce8\u91ca\uff0c\u5bf9\u8868\u6216\u5217\u8fdb\u884c\u8bf4\u660e\u7684\u6587\u5b57","text":"comment","chars":"comment","pinyin":[{"label":"","chars":"c","text":"c"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"t","text":"t"}]}],[{"sound":"\u0283\u0259\u028a \u02c8te\u026ablz","label":"\u663e\u793a\u5f53\u524d\u6570\u636e\u5e93\u4e2d\u6240\u6709\u8868\u7684\u547d\u4ee4","text":"show tables","chars":"show tables","pinyin":[{"label":"","chars":"s","text":"s"},{"label":"","chars":"h","text":"h"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"w","text":"w"},{"label":"","chars":" ","text":" "},{"label":"","chars":"t","text":"t"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"b","text":"b"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"s","text":"s"}]}],[{"sound":"d\u026a\u02c8skra\u026ab","label":"\u67e5\u770b\u6570\u636e\u8868\u7ed3\u6784\u7684\u547d\u4ee4","text":"desc","chars":"desc","pinyin":[{"label":"","chars":"d","text":"d"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"s","text":"s"},{"label":"","chars":"c","text":"c"}]}],[{"sound":"d\u026a\u02c8skra\u026ab","label":"\u4e0e desc \u529f\u80fd\u76f8\u540c\uff0c\u67e5\u770b\u6570\u636e\u8868\u7ed3\u6784","text":"describe","chars":"describe","pinyin":[{"label":"","chars":"d","text":"d"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"s","text":"s"},{"label":"","chars":"c","text":"c"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"b","text":"b"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"\u0283\u0259\u028a kri\u02c8e\u026at \u02c8te\u026abl","label":"\u67e5\u770b\u521b\u5efa\u8868\u7684 SQL \u8bed\u53e5","text":"show create table","chars":"show create table","pinyin":[{"label":"","chars":"s","text":"s"},{"label":"","chars":"h","text":"h"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"w","text":"w"},{"label":"","chars":" ","text":" "},{"label":"","chars":"c","text":"c"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"t","text":"t"},{"label":"","chars":"e","text":"e"},{"label":"","chars":" ","text":" "},{"label":"","chars":"t","text":"t"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"b","text":"b"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"e","text":"e"}]}],[{"sound":"\u00e6d \u02c8k\u0252l\u0259m","label":"\u5411\u8868\u4e2d\u6dfb\u52a0\u65b0\u5217","text":"add column","chars":"add column","pinyin":[{"label":"","chars":"a","text":"a"},{"label":"","chars":"d","text":"d"},{"label":"","chars":"d","text":"d"},{"label":"","chars":" ","text":" "},{"label":"","chars":"c","text":"c"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"n","text":"n"}]}],[{"sound":"dr\u0252p \u02c8k\u0252l\u0259m","label":"\u4ece\u8868\u4e2d\u5220\u9664\u5217","text":"drop column","chars":"drop column","pinyin":[{"label":"","chars":"d","text":"d"},{"label":"","chars":"r","text":"r"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"p","text":"p"},{"label":"","chars":" ","text":" "},{"label":"","chars":"c","text":"c"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"n","text":"n"}]}],[{"sound":"\u02c8m\u0252d\u026afa\u026a \u02c8k\u0252l\u0259m","label":"\u4fee\u6539\u5217\u7684\u6570\u636e\u7c7b\u578b\u6216\u7ea6\u675f","text":"modify column","chars":"modify column","pinyin":[{"label":"","chars":"m","text":"m"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"d","text":"d"},{"label":"","chars":"i","text":"i"},{"label":"","chars":"f","text":"f"},{"label":"","chars":"y","text":"y"},{"label":"","chars":" ","text":" "},{"label":"","chars":"c","text":"c"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"n","text":"n"}]}],[{"sound":"t\u0283e\u026and\u0292 \u02c8k\u0252l\u0259m","label":"\u4fee\u6539\u5217\u540d\u53ca\u6570\u636e\u7c7b\u578b\u7b49","text":"change column","chars":"change column","pinyin":[{"label":"","chars":"c","text":"c"},{"label":"","chars":"h","text":"h"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"g","text":"g"},{"label":"","chars":"e","text":"e"},{"label":"","chars":" ","text":" "},{"label":"","chars":"c","text":"c"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"n","text":"n"}]}],[{"sound":"\u02ccri\u02d0\u02c8ne\u026am \u02c8k\u0252l\u0259m","label":"\u91cd\u547d\u540d\u5217","text":"rename column","chars":"rename column","pinyin":[{"label":"","chars":"r","text":"r"},{"label":"","chars":"e","text":"e"},{"label":"","chars":"n","text":"n"},{"label":"","chars":"a","text":"a"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"e","text":"e"},{"label":"","chars":" ","text":" "},{"label":"","chars":"c","text":"c"},{"label":"","chars":"o","text":"o"},{"label":"","chars":"l","text":"l"},{"label":"","chars":"u","text":"u"},{"label":"","chars":"m","text":"m"},{"label":"","chars":"n","text":"n"}]}],[{"sound":"\u02c8pra\u026am\u0259ri ki\u02d0","label":"\u4e3b\u952e\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\uff0c\u5173\u8054\u5176\u4ed6\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":"ju\u02c8ni\u02d0k","label":"\u552f\u4e00\u7ea6\u675f\uff0c\u5217\u503c\u4e0d\u53ef\u91cd\u590d","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":"n\u0252t n\u028cl","label":"\u975e\u7a7a\u7ea6\u675f\uff0c\u5217\u503c\u4e0d\u53ef\u4e3a null","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":"d\u026a\u02c8f\u0254\u02d0lt","label":"\u9ed8\u8ba4\u503c\uff0c\u5217\u7684\u9ed8\u8ba4\u6570\u636e","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\uff0c\u5217\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"}]}]]}],"section":"MYSQL\u7f16\u7a0b","section_id":"8","course_id":"4","course_type":0,"pre_uri":"4-8-002","next_uri":"4-8-004"}

鼠标点我 或按 空格键 开始