- 4表示的是数据的最大长度【分数最大是100.0一共四位】
- 1表示的是小数点后的位数。
- 年龄字段 ——不会出现负数,且人的年龄不会太大。
- 所以写成:age tinyint unsigned。
字符串类型汇总
字符串类型中
,char 与 varchar 都可以描述字符串,char
是定长字符串
,指定长度多长,就占用多少个字符,和字段值的长度无关 。varchar
是变长字符串
,指定的长度为最大占用长度 。- 相对来说,char的性能会更高些。
- 例如:
- (1)
#mermaid-svg-6hGjnZxtGzPvToZh {font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-6hGjnZxtGzPvToZh .error-icon{fill:#552222;}#mermaid-svg-6hGjnZxtGzPvToZh .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-6hGjnZxtGzPvToZh .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-6hGjnZxtGzPvToZh .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-6hGjnZxtGzPvToZh .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-6hGjnZxtGzPvToZh .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-6hGjnZxtGzPvToZh .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-6hGjnZxtGzPvToZh .marker{fill:#333333;stroke:#333333;}#mermaid-svg-6hGjnZxtGzPvToZh .marker.cross{stroke:#333333;}#mermaid-svg-6hGjnZxtGzPvToZh svg{font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-6hGjnZxtGzPvToZh .label{font-family:“trebuchet ms”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-6hGjnZxtGzPvToZh .cluster-label text{fill:#333;}#mermaid-svg-6hGjnZxtGzPvToZh .cluster-label span{color:#333;}#mermaid-svg-6hGjnZxtGzPvToZh .label text,#mermaid-svg-6hGjnZxtGzPvToZh span{fill:#333;color:#333;}#mermaid-svg-6hGjnZxtGzPvToZh .node rect,#mermaid-svg-6hGjnZxtGzPvToZh .node circle,#mermaid-svg-6hGjnZxtGzPvToZh .node ellipse,#mermaid-svg-6hGjnZxtGzPvToZh .node polygon,#mermaid-svg-6hGjnZxtGzPvToZh .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-6hGjnZxtGzPvToZh .node .label{text-align:center;}#mermaid-svg-6hGjnZxtGzPvToZh .node.clickable{cursor:pointer;}#mermaid-svg-6hGjnZxtGzPvToZh .arrowheadPath{fill:#333333;}#mermaid-svg-6hGjnZxtGzPvToZh .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-6hGjnZxtGzPvToZh .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-6hGjnZxtGzPvToZh .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-6hGjnZxtGzPvToZh .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-6hGjnZxtGzPvToZh .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-6hGjnZxtGzPvToZh .cluster text{fill:#333;}#mermaid-svg-6hGjnZxtGzPvToZh .cluster span{color:#333;}#mermaid-svg-6hGjnZxtGzPvToZh div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-6hGjnZxtGzPvToZh :root{–mermaid-font-family:“trebuchet ms”,verdana,arial,sans-serif;}
用户名username
长度不定,最长不超过50
#mermaid-svg-neci9oqvXDiv30pB {font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-neci9oqvXDiv30pB .error-icon{fill:#552222;}#mermaid-svg-neci9oqvXDiv30pB .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-neci9oqvXDiv30pB .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-neci9oqvXDiv30pB .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-neci9oqvXDiv30pB .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-neci9oqvXDiv30pB .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-neci9oqvXDiv30pB .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-neci9oqvXDiv30pB .marker{fill:#333333;stroke:#333333;}#mermaid-svg-neci9oqvXDiv30pB .marker.cross{stroke:#333333;}#mermaid-svg-neci9oqvXDiv30pB svg{font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-neci9oqvXDiv30pB .label{font-family:“trebuchet ms”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-neci9oqvXDiv30pB .cluster-label text{fill:#333;}#mermaid-svg-neci9oqvXDiv30pB .cluster-label span{color:#333;}#mermaid-svg-neci9oqvXDiv30pB .label text,#mermaid-svg-neci9oqvXDiv30pB span{fill:#333;color:#333;}#mermaid-svg-neci9oqvXDiv30pB .node rect,#mermaid-svg-neci9oqvXDiv30pB .node circle,#mermaid-svg-neci9oqvXDiv30pB .node ellipse,#mermaid-svg-neci9oqvXDiv30pB .node polygon,#mermaid-svg-neci9oqvXDiv30pB .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-neci9oqvXDiv30pB .node .label{text-align:center;}#mermaid-svg-neci9oqvXDiv30pB .node.clickable{cursor:pointer;}#mermaid-svg-neci9oqvXDiv30pB .arrowheadPath{fill:#333333;}#mermaid-svg-neci9oqvXDiv30pB .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-neci9oqvXDiv30pB .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-neci9oqvXDiv30pB .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-neci9oqvXDiv30pB .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-neci9oqvXDiv30pB .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-neci9oqvXDiv30pB .cluster text{fill:#333;}#mermaid-svg-neci9oqvXDiv30pB .cluster span{color:#333;}#mermaid-svg-neci9oqvXDiv30pB div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-neci9oqvXDiv30pB :root{–mermaid-font-family:“trebuchet ms”,verdana,arial,sans-serif;}
username varchar(50)
- (2)
#mermaid-svg-kMvssWPGgMAO8Ig7 {font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-kMvssWPGgMAO8Ig7 .error-icon{fill:#552222;}#mermaid-svg-kMvssWPGgMAO8Ig7 .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-kMvssWPGgMAO8Ig7 .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-kMvssWPGgMAO8Ig7 .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-kMvssWPGgMAO8Ig7 .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-kMvssWPGgMAO8Ig7 .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-kMvssWPGgMAO8Ig7 .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-kMvssWPGgMAO8Ig7 .marker{fill:#333333;stroke:#333333;}#mermaid-svg-kMvssWPGgMAO8Ig7 .marker.cross{stroke:#333333;}#mermaid-svg-kMvssWPGgMAO8Ig7 svg{font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-kMvssWPGgMAO8Ig7 .label{font-family:“trebuchet ms”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-kMvssWPGgMAO8Ig7 .cluster-label text{fill:#333;}#mermaid-svg-kMvssWPGgMAO8Ig7 .cluster-label span{color:#333;}#mermaid-svg-kMvssWPGgMAO8Ig7 .label text,#mermaid-svg-kMvssWPGgMAO8Ig7 span{fill:#333;color:#333;}#mermaid-svg-kMvssWPGgMAO8Ig7 .node rect,#mermaid-svg-kMvssWPGgMAO8Ig7 .node circle,#mermaid-svg-kMvssWPGgMAO8Ig7 .node ellipse,#mermaid-svg-kMvssWPGgMAO8Ig7 .node polygon,#mermaid-svg-kMvssWPGgMAO8Ig7 .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-kMvssWPGgMAO8Ig7 .node .label{text-align:center;}#mermaid-svg-kMvssWPGgMAO8Ig7 .node.clickable{cursor:pointer;}#mermaid-svg-kMvssWPGgMAO8Ig7 .arrowheadPath{fill:#333333;}#mermaid-svg-kMvssWPGgMAO8Ig7 .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-kMvssWPGgMAO8Ig7 .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-kMvssWPGgMAO8Ig7 .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-kMvssWPGgMAO8Ig7 .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-kMvssWPGgMAO8Ig7 .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-kMvssWPGgMAO8Ig7 .cluster text{fill:#333;}#mermaid-svg-kMvssWPGgMAO8Ig7 .cluster span{color:#333;}#mermaid-svg-kMvssWPGgMAO8Ig7 div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-kMvssWPGgMAO8Ig7 :root{–mermaid-font-family:“trebuchet ms”,verdana,arial,sans-serif;}
性别gender
存储值,不是男,就是女
#mermaid-svg-ySkh09Udg1VjAA0Y {font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-ySkh09Udg1VjAA0Y .error-icon{fill:#552222;}#mermaid-svg-ySkh09Udg1VjAA0Y .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-ySkh09Udg1VjAA0Y .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-ySkh09Udg1VjAA0Y .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-ySkh09Udg1VjAA0Y .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-ySkh09Udg1VjAA0Y .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-ySkh09Udg1VjAA0Y .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-ySkh09Udg1VjAA0Y .marker{fill:#333333;stroke:#333333;}#mermaid-svg-ySkh09Udg1VjAA0Y .marker.cross{stroke:#333333;}#mermaid-svg-ySkh09Udg1VjAA0Y svg{font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-ySkh09Udg1VjAA0Y .label{font-family:“trebuchet ms”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-ySkh09Udg1VjAA0Y .cluster-label text{fill:#333;}#mermaid-svg-ySkh09Udg1VjAA0Y .cluster-label span{color:#333;}#mermaid-svg-ySkh09Udg1VjAA0Y .label text,#mermaid-svg-ySkh09Udg1VjAA0Y span{fill:#333;color:#333;}#mermaid-svg-ySkh09Udg1VjAA0Y .node rect,#mermaid-svg-ySkh09Udg1VjAA0Y .node circle,#mermaid-svg-ySkh09Udg1VjAA0Y .node ellipse,#mermaid-svg-ySkh09Udg1VjAA0Y .node polygon,#mermaid-svg-ySkh09Udg1VjAA0Y .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-ySkh09Udg1VjAA0Y .node .label{text-align:center;}#mermaid-svg-ySkh09Udg1VjAA0Y .node.clickable{cursor:pointer;}#mermaid-svg-ySkh09Udg1VjAA0Y .arrowheadPath{fill:#333333;}#mermaid-svg-ySkh09Udg1VjAA0Y .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-ySkh09Udg1VjAA0Y .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-ySkh09Udg1VjAA0Y .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-ySkh09Udg1VjAA0Y .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-ySkh09Udg1VjAA0Y .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-ySkh09Udg1VjAA0Y .cluster text{fill:#333;}#mermaid-svg-ySkh09Udg1VjAA0Y .cluster span{color:#333;}#mermaid-svg-ySkh09Udg1VjAA0Y div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-ySkh09Udg1VjAA0Y :root{–mermaid-font-family:“trebuchet ms”,verdana,arial,sans-serif;}
gender char(1)
- (3)
#mermaid-svg-isNja0O0CS1BAyYQ {font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-isNja0O0CS1BAyYQ .error-icon{fill:#552222;}#mermaid-svg-isNja0O0CS1BAyYQ .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-isNja0O0CS1BAyYQ .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-isNja0O0CS1BAyYQ .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-isNja0O0CS1BAyYQ .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-isNja0O0CS1BAyYQ .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-isNja0O0CS1BAyYQ .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-isNja0O0CS1BAyYQ .marker{fill:#333333;stroke:#333333;}#mermaid-svg-isNja0O0CS1BAyYQ .marker.cross{stroke:#333333;}#mermaid-svg-isNja0O0CS1BAyYQ svg{font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-isNja0O0CS1BAyYQ .label{font-family:“trebuchet ms”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-isNja0O0CS1BAyYQ .cluster-label text{fill:#333;}#mermaid-svg-isNja0O0CS1BAyYQ .cluster-label span{color:#333;}#mermaid-svg-isNja0O0CS1BAyYQ .label text,#mermaid-svg-isNja0O0CS1BAyYQ span{fill:#333;color:#333;}#mermaid-svg-isNja0O0CS1BAyYQ .node rect,#mermaid-svg-isNja0O0CS1BAyYQ .node circle,#mermaid-svg-isNja0O0CS1BAyYQ .node ellipse,#mermaid-svg-isNja0O0CS1BAyYQ .node polygon,#mermaid-svg-isNja0O0CS1BAyYQ .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-isNja0O0CS1BAyYQ .node .label{text-align:center;}#mermaid-svg-isNja0O0CS1BAyYQ .node.clickable{cursor:pointer;}#mermaid-svg-isNja0O0CS1BAyYQ .arrowheadPath{fill:#333333;}#mermaid-svg-isNja0O0CS1BAyYQ .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-isNja0O0CS1BAyYQ .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-isNja0O0CS1BAyYQ .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-isNja0O0CS1BAyYQ .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-isNja0O0CS1BAyYQ .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-isNja0O0CS1BAyYQ .cluster text{fill:#333;}#mermaid-svg-isNja0O0CS1BAyYQ .cluster span{color:#333;}#mermaid-svg-isNja0O0CS1BAyYQ div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-isNja0O0CS1BAyYQ :root{–mermaid-font-family:“trebuchet ms”,verdana,arial,sans-serif;}
手机phone
固定长度为11
#mermaid-svg-gJ4SJ5Tl72mXFjom {font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-gJ4SJ5Tl72mXFjom .error-icon{fill:#552222;}#mermaid-svg-gJ4SJ5Tl72mXFjom .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-gJ4SJ5Tl72mXFjom .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-gJ4SJ5Tl72mXFjom .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-gJ4SJ5Tl72mXFjom .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-gJ4SJ5Tl72mXFjom .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-gJ4SJ5Tl72mXFjom .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-gJ4SJ5Tl72mXFjom .marker{fill:#333333;stroke:#333333;}#mermaid-svg-gJ4SJ5Tl72mXFjom .marker.cross{stroke:#333333;}#mermaid-svg-gJ4SJ5Tl72mXFjom svg{font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-gJ4SJ5Tl72mXFjom .label{font-family:“trebuchet ms”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-gJ4SJ5Tl72mXFjom .cluster-label text{fill:#333;}#mermaid-svg-gJ4SJ5Tl72mXFjom .cluster-label span{color:#333;}#mermaid-svg-gJ4SJ5Tl72mXFjom .label text,#mermaid-svg-gJ4SJ5Tl72mXFjom span{fill:#333;color:#333;}#mermaid-svg-gJ4SJ5Tl72mXFjom .node rect,#mermaid-svg-gJ4SJ5Tl72mXFjom .node circle,#mermaid-svg-gJ4SJ5Tl72mXFjom .node ellipse,#mermaid-svg-gJ4SJ5Tl72mXFjom .node polygon,#mermaid-svg-gJ4SJ5Tl72mXFjom .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-gJ4SJ5Tl72mXFjom .node .label{text-align:center;}#mermaid-svg-gJ4SJ5Tl72mXFjom .node.clickable{cursor:pointer;}#mermaid-svg-gJ4SJ5Tl72mXFjom .arrowheadPath{fill:#333333;}#mermaid-svg-gJ4SJ5Tl72mXFjom .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-gJ4SJ5Tl72mXFjom .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-gJ4SJ5Tl72mXFjom .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-gJ4SJ5Tl72mXFjom .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-gJ4SJ5Tl72mXFjom .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-gJ4SJ5Tl72mXFjom .cluster text{fill:#333;}#mermaid-svg-gJ4SJ5Tl72mXFjom .cluster span{color:#333;}#mermaid-svg-gJ4SJ5Tl72mXFjom div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-gJ4SJ5Tl72mXFjom :root{–mermaid-font-family:“trebuchet ms”,verdana,arial,sans-serif;}
phone char(11)
BLOB
表示的是二进制类型的数据【例如:安装包,音频】TEXT
用于描述文本类型的数据。
日期时间类型
- 例如:
- (1)
#mermaid-svg-c3JTelzqa5g0GzIx {font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-c3JTelzqa5g0GzIx .error-icon{fill:#552222;}#mermaid-svg-c3JTelzqa5g0GzIx .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-c3JTelzqa5g0GzIx .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-c3JTelzqa5g0GzIx .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-c3JTelzqa5g0GzIx .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-c3JTelzqa5g0GzIx .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-c3JTelzqa5g0GzIx .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-c3JTelzqa5g0GzIx .marker{fill:#333333;stroke:#333333;}#mermaid-svg-c3JTelzqa5g0GzIx .marker.cross{stroke:#333333;}#mermaid-svg-c3JTelzqa5g0GzIx svg{font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-c3JTelzqa5g0GzIx .label{font-family:“trebuchet ms”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-c3JTelzqa5g0GzIx .cluster-label text{fill:#333;}#mermaid-svg-c3JTelzqa5g0GzIx .cluster-label span{color:#333;}#mermaid-svg-c3JTelzqa5g0GzIx .label text,#mermaid-svg-c3JTelzqa5g0GzIx span{fill:#333;color:#333;}#mermaid-svg-c3JTelzqa5g0GzIx .node rect,#mermaid-svg-c3JTelzqa5g0GzIx .node circle,#mermaid-svg-c3JTelzqa5g0GzIx .node ellipse,#mermaid-svg-c3JTelzqa5g0GzIx .node polygon,#mermaid-svg-c3JTelzqa5g0GzIx .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-c3JTelzqa5g0GzIx .node .label{text-align:center;}#mermaid-svg-c3JTelzqa5g0GzIx .node.clickable{cursor:pointer;}#mermaid-svg-c3JTelzqa5g0GzIx .arrowheadPath{fill:#333333;}#mermaid-svg-c3JTelzqa5g0GzIx .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-c3JTelzqa5g0GzIx .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-c3JTelzqa5g0GzIx .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-c3JTelzqa5g0GzIx .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-c3JTelzqa5g0GzIx .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-c3JTelzqa5g0GzIx .cluster text{fill:#333;}#mermaid-svg-c3JTelzqa5g0GzIx .cluster span{color:#333;}#mermaid-svg-c3JTelzqa5g0GzIx div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-c3JTelzqa5g0GzIx :root{–mermaid-font-family:“trebuchet ms”,verdana,arial,sans-serif;}
生日字段 birthday
birthday date
- (2)
#mermaid-svg-BEmawQFlx2bbnQgQ {font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-BEmawQFlx2bbnQgQ .error-icon{fill:#552222;}#mermaid-svg-BEmawQFlx2bbnQgQ .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-BEmawQFlx2bbnQgQ .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-BEmawQFlx2bbnQgQ .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-BEmawQFlx2bbnQgQ .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-BEmawQFlx2bbnQgQ .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-BEmawQFlx2bbnQgQ .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-BEmawQFlx2bbnQgQ .marker{fill:#333333;stroke:#333333;}#mermaid-svg-BEmawQFlx2bbnQgQ .marker.cross{stroke:#333333;}#mermaid-svg-BEmawQFlx2bbnQgQ svg{font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-BEmawQFlx2bbnQgQ .label{font-family:“trebuchet ms”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-BEmawQFlx2bbnQgQ .cluster-label text{fill:#333;}#mermaid-svg-BEmawQFlx2bbnQgQ .cluster-label span{color:#333;}#mermaid-svg-BEmawQFlx2bbnQgQ .label text,#mermaid-svg-BEmawQFlx2bbnQgQ span{fill:#333;color:#333;}#mermaid-svg-BEmawQFlx2bbnQgQ .node rect,#mermaid-svg-BEmawQFlx2bbnQgQ .node circle,#mermaid-svg-BEmawQFlx2bbnQgQ .node ellipse,#mermaid-svg-BEmawQFlx2bbnQgQ .node polygon,#mermaid-svg-BEmawQFlx2bbnQgQ .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-BEmawQFlx2bbnQgQ .node .label{text-align:center;}#mermaid-svg-BEmawQFlx2bbnQgQ .node.clickable{cursor:pointer;}#mermaid-svg-BEmawQFlx2bbnQgQ .arrowheadPath{fill:#333333;}#mermaid-svg-BEmawQFlx2bbnQgQ .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-BEmawQFlx2bbnQgQ .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-BEmawQFlx2bbnQgQ .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-BEmawQFlx2bbnQgQ .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-BEmawQFlx2bbnQgQ .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-BEmawQFlx2bbnQgQ .cluster text{fill:#333;}#mermaid-svg-BEmawQFlx2bbnQgQ .cluster span{color:#333;}#mermaid-svg-BEmawQFlx2bbnQgQ div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:“trebuchet ms”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-BEmawQFlx2bbnQgQ :root{–mermaid-font-family:“trebuchet ms”,verdana,arial,sans-serif;}
创建时间 createtime
createtime datetime
Exercises
表结构的创建
展示创建好的表
DDL语句修改表的操作
添加字段
ALTER TABLE 表名 ADD 字段名 类型(长度) [COMMENT 注释] [约束]; |
为刚刚创建的emp表添加一个新的字段 ‘昵称’ 为nickname,类型为varchar。
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。
深知大多数HarmonyOS鸿蒙开发工程师,想要提升技能,往往是自己摸索成长或者是报班学习,但对于培训机构动则几千的学费,着实压力不小。自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!
因此收集整理了一份《2024年HarmonyOS鸿蒙开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上HarmonyOS鸿蒙开发知识点,真正体系化!
由于文件比较大,这里只是将部分目录大纲截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新
如果你觉得这些内容对你有帮助,可以添加VX:vip204888 (备注鸿蒙获取)
一个人可以走的很快,但一群人才能走的更远。不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎扫码加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!
,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。**
[外链图片转存中…(img-8VTixXwv-1712869225557)]
[外链图片转存中…(img-tMhuF7Zt-1712869225558)]
[外链图片转存中…(img-pikgWphM-1712869225558)]
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上HarmonyOS鸿蒙开发知识点,真正体系化!
由于文件比较大,这里只是将部分目录大纲截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新
如果你觉得这些内容对你有帮助,可以添加VX:vip204888 (备注鸿蒙获取)
[外链图片转存中…(img-M3Nbqcit-1712869225558)]
一个人可以走的很快,但一群人才能走的更远。不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎扫码加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!