【MySQL】如何使用图形化界面DataGrip操作数据库

](https://img-blog.csdnimg.cn/21dd41dce63a4f2da07b9d879ad0120b.png#pic_center)

🌈个人主页: Aileen_0v0
🔥热门专栏: 华为鸿蒙系统学习|计算机网络|数据结构与算法
​💫个人格言:“没有罗马,那就自己创造罗马~”

#mermaid-svg-W5JDg0WA1tjEP66Y {font-family:"trebuchet ms",verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-W5JDg0WA1tjEP66Y .error-icon{fill:#552222;}#mermaid-svg-W5JDg0WA1tjEP66Y .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-W5JDg0WA1tjEP66Y .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-W5JDg0WA1tjEP66Y .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-W5JDg0WA1tjEP66Y .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-W5JDg0WA1tjEP66Y .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-W5JDg0WA1tjEP66Y .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-W5JDg0WA1tjEP66Y .marker{fill:#333333;stroke:#333333;}#mermaid-svg-W5JDg0WA1tjEP66Y .marker.cross{stroke:#333333;}#mermaid-svg-W5JDg0WA1tjEP66Y svg{font-family:"trebuchet ms",verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-W5JDg0WA1tjEP66Y .label{font-family:"trebuchet ms",verdana,arial,sans-serif;color:#333;}#mermaid-svg-W5JDg0WA1tjEP66Y .cluster-label text{fill:#333;}#mermaid-svg-W5JDg0WA1tjEP66Y .cluster-label span{color:#333;}#mermaid-svg-W5JDg0WA1tjEP66Y .label text,#mermaid-svg-W5JDg0WA1tjEP66Y span{fill:#333;color:#333;}#mermaid-svg-W5JDg0WA1tjEP66Y .node rect,#mermaid-svg-W5JDg0WA1tjEP66Y .node circle,#mermaid-svg-W5JDg0WA1tjEP66Y .node ellipse,#mermaid-svg-W5JDg0WA1tjEP66Y .node polygon,#mermaid-svg-W5JDg0WA1tjEP66Y .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-W5JDg0WA1tjEP66Y .node .label{text-align:center;}#mermaid-svg-W5JDg0WA1tjEP66Y .node.clickable{cursor:pointer;}#mermaid-svg-W5JDg0WA1tjEP66Y .arrowheadPath{fill:#333333;}#mermaid-svg-W5JDg0WA1tjEP66Y .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-W5JDg0WA1tjEP66Y .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-W5JDg0WA1tjEP66Y .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-W5JDg0WA1tjEP66Y .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-W5JDg0WA1tjEP66Y .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-W5JDg0WA1tjEP66Y .cluster text{fill:#333;}#mermaid-svg-W5JDg0WA1tjEP66Y .cluster span{color:#333;}#mermaid-svg-W5JDg0WA1tjEP66Y 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-W5JDg0WA1tjEP66Y :root{--mermaid-font-family:"trebuchet ms",verdana,arial,sans-serif;}
lt's the possibility of having a dream come true that makes life interesting.

文章目录

图形化界面工具DataGrip安装

datagrip安装包我放在

玲一爱编程

公众号，需要的小伙伴可以关注微信公众号

玲一爱编程

，私信回复

datagrip安装包

自行提取。

如何用图形化界面创建数据库和表

创建数据库

创建表结构

操作表

总结

#mermaid-svg-YegCyl62Qtk8YS1r {font-family:"trebuchet ms",verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-YegCyl62Qtk8YS1r .error-icon{fill:#552222;}#mermaid-svg-YegCyl62Qtk8YS1r .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-YegCyl62Qtk8YS1r .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-YegCyl62Qtk8YS1r .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-YegCyl62Qtk8YS1r .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-YegCyl62Qtk8YS1r .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-YegCyl62Qtk8YS1r .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-YegCyl62Qtk8YS1r .marker{fill:#333333;stroke:#333333;}#mermaid-svg-YegCyl62Qtk8YS1r .marker.cross{stroke:#333333;}#mermaid-svg-YegCyl62Qtk8YS1r svg{font-family:"trebuchet ms",verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-YegCyl62Qtk8YS1r .label{font-family:"trebuchet ms",verdana,arial,sans-serif;color:#333;}#mermaid-svg-YegCyl62Qtk8YS1r .cluster-label text{fill:#333;}#mermaid-svg-YegCyl62Qtk8YS1r .cluster-label span{color:#333;}#mermaid-svg-YegCyl62Qtk8YS1r .label text,#mermaid-svg-YegCyl62Qtk8YS1r span{fill:#333;color:#333;}#mermaid-svg-YegCyl62Qtk8YS1r .node rect,#mermaid-svg-YegCyl62Qtk8YS1r .node circle,#mermaid-svg-YegCyl62Qtk8YS1r .node ellipse,#mermaid-svg-YegCyl62Qtk8YS1r .node polygon,#mermaid-svg-YegCyl62Qtk8YS1r .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-YegCyl62Qtk8YS1r .node .label{text-align:center;}#mermaid-svg-YegCyl62Qtk8YS1r .node.clickable{cursor:pointer;}#mermaid-svg-YegCyl62Qtk8YS1r .arrowheadPath{fill:#333333;}#mermaid-svg-YegCyl62Qtk8YS1r .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-YegCyl62Qtk8YS1r .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-YegCyl62Qtk8YS1r .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-YegCyl62Qtk8YS1r .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-YegCyl62Qtk8YS1r .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-YegCyl62Qtk8YS1r .cluster text{fill:#333;}#mermaid-svg-YegCyl62Qtk8YS1r .cluster span{color:#333;}#mermaid-svg-YegCyl62Qtk8YS1r 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-YegCyl62Qtk8YS1r :root{--mermaid-font-family:"trebuchet ms",verdana,arial,sans-serif;}
本篇文章主要写了如何通过图形化界面DataGrip去访问MySQL数据库以及如何去创建数据库和操作数据库中的表。

](https://img-blog.csdnimg.cn/0ee6c4ec414740b0a0404c5161cdadc7.gif#pic_center)

](https://img-blog.csdnimg.cn/cc002cbd5c414c5393e19c5e0a0dbf20.gif#pic_center#pic_center)