Navicat Premium/MY SQL

最新推荐文章于 2023-03-13 14:25:27 发布

愚昧之山绝望之谷开悟之坡

最新推荐文章于 2023-03-13 14:25:27 发布

阅读量219

点赞数

分类专栏：大数据

本文链接：https://blog.csdn.net/qq_15821487/article/details/115895355

版权

大数据专栏收录该内容

23 篇文章 0 订阅

订阅专栏

<header id="header" class="header" itemscope="" itemtype="http://schema.org/WPHeader">
  <div class="header-inner"><div class="site-brand-wrapper">

<div class="custom-logo-site-title">
  <a href="/" class="brand" rel="start" style="opacity: 1;">
    <span class="logo-line-before"><i class="" style="transform: translateX(100%);"></i></span>
    <span class="site-title" style="opacity: 1; top: 0px;">天寒地裂</span>
    <span class="logo-line-after"><i class="" style="transform: translateX(-100%);"></i></span>
  </a>
</div>
  
    <p class="site-subtitle" style="opacity: 1; top: 0px;"></p>

<ul id="menu" class="menu">
  
    
    <li class="menu-item menu-item-home" style="opacity: 1; transform: translateY(0px);">
      <a href="/" rel="section">
        
          <i class="menu-item-icon fa fa-fw fa-home"></i> <br>
        
        首页
      </a>
    </li>
  
    
    <li class="menu-item menu-item-about" style="opacity: 1; transform: translateY(0px);">
      <a href="/about/" rel="section">
        
          <i class="menu-item-icon fa fa-fw fa-user"></i> <br>
        
        关于
      </a>
    </li>
  
    
    <li class="menu-item menu-item-tags" style="opacity: 1; transform: translateY(0px);">
      <a href="/tags/" rel="section">
        
          <i class="menu-item-icon fa fa-fw fa-tags"></i> <br>
        
        标签
      </a>
    </li>
  
    
    <li class="menu-item menu-item-categories" style="opacity: 1; transform: translateY(0px);">
      <a href="/categories/" rel="section">
        
          <i class="menu-item-icon fa fa-fw fa-th"></i> <br>
        
        分类
      </a>
    </li>
  
    
    <li class="menu-item menu-item-archives" style="opacity: 1; transform: translateY(0px);">
      <a href="/archives/" rel="section">
        
          <i class="menu-item-icon fa fa-fw fa-archive"></i> <br>
        
        归档
      </a>
    </li>
  

  
    <li class="menu-item menu-item-search" style="opacity: 1; transform: translateY(0px);">
      
        <a href="javascript:;" class="popup-trigger">
      
        
          <i class="menu-item-icon fa fa-search fa-fw"></i> <br>
        
        搜索
      </a>
    </li>
  
</ul>



<div class="site-search">

<div class="algolia-results">
  <div id="algolia-stats"></div>
  <div id="algolia-hits"></div>
  <div id="algolia-pagination" class="algolia-pagination"></div>
</div>

<span class="popup-btn-close">
  <i class="fa fa-times-circle"></i>
</span>

</div>

<main id="main" class="main">
  <div class="main-inner">
    <div class="content-wrap">
      <div id="content" class="content">

<span hidden="" itemprop="author" itemscope="" itemtype="http://schema.org/Person">
  <meta itemprop="name" content="天寒地裂">
  <meta itemprop="description" content="">
  <meta itemprop="image" content="/images/avatar.gif">
</span>

<span hidden="" itemprop="publisher" itemscope="" itemtype="http://schema.org/Organization">
  <meta itemprop="name" content="天寒地裂">
</span>


  <header class="post-header" style="opacity: 1; display: block; transform: translateY(0px);">

    
    
      <h1 class="post-title" itemprop="name headline">使用Navicat Premium for mac创建数据库及表</h1>
    

    <div class="post-meta">
      <span class="post-time">
        
          <span class="post-meta-item-icon">
            <i class="fa fa-calendar-o"></i>
          </span>
          
            <span class="post-meta-item-text">发表于</span>
          
          <time title="创建于" itemprop="dateCreated datePublished" datetime="2019-03-11T21:59:31+08:00">
            2019-03-11
          </time>
        

        

        
      </span>

      
        <span class="post-category">
        
          <span class="post-meta-divider">|</span>
        
          <span class="post-meta-item-icon">
            <i class="fa fa-folder-o"></i>
          </span>
          
            <span class="post-meta-item-text">分类于</span>
          
          
            <span itemprop="about" itemscope="" itemtype="http://schema.org/Thing">
              <a href="/categories/MySql/" itemprop="url" rel="index">
                <span itemprop="name">MySql</span>
              </a>
            </span>

            
            
          
        </span>
      

      
        
      

      
      
         <span id="/2019/03/11/Mac_NavicatPremium/" class="leancloud_visitors" data-flag-title="使用Navicat Premium for mac创建数据库及表">
           <span class="post-meta-divider">|</span>
           <span class="post-meta-item-icon">
             <i class="fa fa-eye"></i>
           </span>
           
             <span class="post-meta-item-text">阅读次数:</span>
           
             <span class="leancloud-visitors-count">267</span>
         </span>
      

      

      

      

    </div>
  </header>





<div class="post-body" itemprop="articleBody" style="opacity: 1; display: block; transform: translateY(0px);">

  
  

  
    <h1 id="使用Navicat-Premium-for-mac创建数据库及表"><a href="#使用Navicat-Premium-for-mac创建数据库及表" class="headerlink" title="使用Navicat Premium for mac创建数据库及表"></a>使用Navicat Premium for mac创建数据库及表</h1><p>[toc]</p>

连接MySQL

如果你给Mac配好MySQL环境后打开Premium(Navicat Premium太长了，简写)，点击连接(Connection),连接你的MySQL。

链接是出现这个。

连接后是这样的

如果数据库是灰的，右边显示没有连接，点击没反应，没关系，右键->打开连接，就好了。

创建数据库

右键MySql->新建数据库

生成数据库，在生成的数据库右键->打开数据库,就这样的了

创建表

右键表->新建表

表上面的按钮是对表的操作，保存，添加字段，插入字段，删除字段
点击保存

输入表名，生成一个表了

双击Student,开始插入数据

这里就是创建数据库和表就完成了

</div>




<div>
  
    
  
</div>




<div>
    <div>

    <div style="text-align:center;color: #ccc;font-size:14px;">-------------本文结束<i class="fa fa-paw"></i>感谢您的阅读-------------</div>

<footer class="post-footer">
  
    <div class="post-tags">
      
        <a href="/tags/MySql/" rel="tag"><i class="fa fa-tag"></i> MySql</a>
      
    </div>
  

  
  
  

  
    <div class="post-nav">
      <div class="post-nav-next post-nav-item">
        
          <a href="/2019/03/11/Mac_MySQL/" rel="next" title="Mac 下配置MySQL环境变量">
            <i class="fa fa-chevron-left"></i> Mac 下配置MySQL环境变量
          </a>
        
      </div>

      <span class="post-nav-divider"></span>

      <div class="post-nav-prev post-nav-item">
        
          <a href="/2019/05/10/idea_SpringbootWeb/" rel="prev" title="使用idea创建一个springboot的web项目">
            使用idea创建一个springboot的web项目 <i class="fa fa-chevron-right"></i>
          </a>
        
      </div>
    </div>
  

  
  
</footer>

<div class="post-spread">
  
</div>

      </div>
      


      


<div id="gitalk-container"><div class="gt-container"><div class="gt-no-init"><p>未找到相关的 <a href="https://github.com/Coldcrack/Coldcrack.github.io/issues">Issues</a> 进行评论</p><p>请联系 @Coldcrack 初始化创建</p><button class="gt-btn gt-btn-login"><span class="gt-btn-text">使用 GitHub 登录</span></button></div></div></div>





    </div>

<div class="sidebar-inner">

  

  
    <ul class="sidebar-nav motion-element" style="opacity: 1; display: block; transform: translateX(0px);">
      <li class="sidebar-nav-toc sidebar-nav-active" data-target="post-toc-wrap">
        文章目录
      </li>
      <li class="sidebar-nav-overview" data-target="site-overview-wrap">
        站点概览
      </li>
    </ul>
  

  <section class="site-overview-wrap sidebar-panel" style="">
    <div class="site-overview" style="max-height: 513.5px;">
      <div class="site-author motion-element" itemprop="author" itemscope="" itemtype="http://schema.org/Person" style="opacity: 1; display: block; transform: translateX(0px);">
        
          <img class="site-author-image" itemprop="image" src="/images/avatar.gif" alt="天寒地裂">
        
          <p class="site-author-name" itemprop="name">天寒地裂</p>
          <p class="site-description motion-element" itemprop="description" style="opacity: 1; display: block; transform: translateX(0px);">生活就像二进制，不是1就是0。</p>
      </div>

      <nav class="site-state motion-element" style="opacity: 1; display: block; transform: translateX(0px);">

        
          <div class="site-state-item site-state-posts">
          
            <a href="/archives/">
          
              <span class="site-state-item-count">59</span>
              <span class="site-state-item-name">日志</span>
            </a>
          </div>
        

        
          
          
          <div class="site-state-item site-state-categories">
            <a href="/categories/index.html">
              <span class="site-state-item-count">13</span>
              <span class="site-state-item-name">分类</span>
            </a>
          </div>
        

        
          
          
          <div class="site-state-item site-state-tags">
            <a href="/tags/index.html">
              <span class="site-state-item-count">13</span>
              <span class="site-state-item-name">标签</span>
            </a>
          </div>
        

      </nav>

      

      
        <div class="links-of-author motion-element" style="opacity: 1; display: block; transform: translateX(0px);">
            
              <span class="links-of-author-item">
                <a href="https://github.com/Coldcrack" target="_blank" title="GitHub">
                  
                    <i class="fa fa-fw fa-github"></i>GitHub</a>
              </span>
            
        </div>
      

      
      

      
      

      

    </div>
  </section>

  
  <!--noindex-->
    <section class="post-toc-wrap motion-element sidebar-panel sidebar-panel-active" style="opacity: 1; display: block; transform: translateX(0px);">
      <div class="post-toc" style="max-height: 513.5px;">

        
          
        

        
          <div class="post-toc-content"><ol class="nav"><li class="nav-item nav-level-1"><a class="nav-link" href="#使用Navicat-Premium-for-mac创建数据库及表"><span class="nav-number">1.</span> <span class="nav-text">使用Navicat Premium for mac创建数据库及表</span></a><ol class="nav-child"><li class="nav-item nav-level-2"><a class="nav-link" href="#连接MySQL"><span class="nav-number">1.1.</span> <span class="nav-text">连接MySQL</span></a></li><li class="nav-item nav-level-2"><a class="nav-link" href="#创建数据库"><span class="nav-number">1.2.</span> <span class="nav-text">创建数据库</span></a></li><li class="nav-item nav-level-2"><a class="nav-link" href="#创建表"><span class="nav-number">1.3.</span> <span class="nav-text">创建表</span></a></li></ol></li></ol></div>
        

      </div>
    </section>
  <!--/noindex-->
  

  

</div>

  </div>
</main>

<footer id="footer" class="footer">
  <div class="footer-inner">
    <div class="copyright">© <span itemprop="copyrightYear">2020</span>

天寒地裂

主题 — NexT.Mist v5.1.4

博客全站共34.8k字

<span class="site-uv">
  本站访客数
  <span class="busuanzi-value" id="busuanzi_value_site_uv">6133</span>
  人
</span>



<span class="site-pv">
  本站总访问量
  <span class="busuanzi-value" id="busuanzi_value_site_pv">9129</span>
  次
</span>

  </div>
</footer>


  <div class="back-to-top">
    <i class="fa fa-arrow-up"></i>
    
  </div>

愚昧之山绝望之谷开悟之坡

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Navicat Premium/MY SQL

<header id="header" class="header" itemscope="" itemtype="http://schema.org/WPHeader"> <div class="header-inner"><div class="site-brand-wrapper"> <div class="custom-logo-site-title"> <a href="/" class="brand" rel="s...
复制链接

扫一扫

专栏目录