如何查看我的laravel数据库？ [英] How to see my laravel database?

问题描述

我已经设置了功能laravel项目，数据库连接工作，我通过终端添加了一些表，但现在我想看到它，就像你可以看到一切与phpmyadmin，例如。

解决方案

在终端：

• 进入项目目录




• vagrant ssh <




• <$ c>

  $ c> mysql -u [username] -p [password] - 例如 mysql -uhomestead -ppassword

---

Vaala！您已连接到MySQL ...

---

• SHOW数据库;




• USE [Database Name]; code> use Homestead;




• DESCRIBE表; 查看所有表格




• SELECT * from [table]; - 例如 select *来自用户

I've set functional laravel project, database connection works, I've added some tables via terminal but now I'd like to see it just as you can see everything with phpmyadmin, for example. How to locate the database file and how to open it, by default?

解决方案

In Terminal:

• cd into Project directory

• vagrant ssh

• cd into Project directory in machine

• mysql -u[username] -p[password] - e.g mysql -uhomestead -ppassword

---

Vaala! You are connected to MySQL...

---

• SHOW databases;

• USE [Database Name]; - e.g use Homestead;

• DESCRIBE tables; to see all tables

• SELECT * from [table]; - e.g select * from users

这篇关于如何查看我的laravel数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！