# How to run tables from database in MySQL?

**URL:** <https://forum.codewithmosh.com/t/how-to-run-tables-from-database-in-mysql/19086>\
**Category:** SQL\
**Created:** [March 23, 2023, 1:01pm UTC](https://forum.codewithmosh.com/t/how-to-run-tables-from-database-in-mysql/19086 "2023-03-23T13:01:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rojin](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@Rojin](https://forum.codewithmosh.com/u/Rojin)\
**Post date:** [March 23, 2023, 1:01pm UTC](https://forum.codewithmosh.com/t/how-to-run-tables-from-database-in-mysql/19086/1 "2023-03-23T13:01:41Z")

</div>

![Screenshot (328)](https://us1.discourse-cdn.com/flex020/uploads/codewithmosh/original/2X/2/259846c457f6e7eeb27422ecafa6c1caadb3f8b4.jpeg)

I wonder why should I write : sql\_store.orders instead of orders When I want to use order table?

Before I could just write orders as Mosh wrote in the videos. Since I closed Mysql once and opened it again I should write sql\_store. before any table that I want to use.

Thanks

---

<div class="post-metadata">

**Author:** ![keelo](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.codewithmosh.com/keelo/32/4592_2.png) [@keelo](https://forum.codewithmosh.com/u/keelo)\
**Post date:** [March 23, 2023, 2:25pm UTC](https://forum.codewithmosh.com/t/how-to-run-tables-from-database-in-mysql/19086/2 "2023-03-23T14:25:30Z")

</div>

If you don’t want to write sql\_store.orders  
You need to make sure to select the database you want to query prior to opening a new query tab.  
Or  
You can use the ‘USE’ statement  
example:

USE sql\_store; – or which ever database you want to query  
– Don’t forget to end the query with a semicolon

SELECT \*  
FROM orders  
JOIN customers  
ON orders.customer\_id = customers.customer\_id;

---

<div class="post-metadata">

**Author:** ![Rojin](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@Rojin](https://forum.codewithmosh.com/u/Rojin)\
**Post date:** [March 23, 2023, 3:33pm UTC](https://forum.codewithmosh.com/t/how-to-run-tables-from-database-in-mysql/19086/3 "2023-03-23T15:33:46Z")

</div>

Thanks for your reply!

How can I do this without ‘USE’ statement:

‘‘You need to make sure to select the database you want to query prior to opening a new query tab.’’  
?

---

<div class="post-metadata">

**Author:** ![keelo](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.codewithmosh.com/keelo/32/4592_2.png) [@keelo](https://forum.codewithmosh.com/u/keelo)\
**Post date:** [March 23, 2023, 4:05pm UTC](https://forum.codewithmosh.com/t/how-to-run-tables-from-database-in-mysql/19086/4 "2023-03-23T16:05:37Z")

</div>

Select the database you want to query from the schemas section in the navigator window on the left. - Make sure its in bold then select create new query tab

---

<div class="post-metadata">

**Author:** ![Rojin](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@Rojin](https://forum.codewithmosh.com/u/Rojin)\
**Post date:** [March 24, 2023, 1:42pm UTC](https://forum.codewithmosh.com/t/how-to-run-tables-from-database-in-mysql/19086/5 "2023-03-24T13:42:12Z")

</div>

Hi !  
Sure  
I selected sql\_store and then a new query tab above. But it will open my local disk instead of new query.

Thanks

 ![Screenshot (329)](https://us1.discourse-cdn.com/flex020/uploads/codewithmosh/original/2X/c/c9cb94d8c7792490a9bcdbd60df42ef5b047acaf.jpeg)

---

<div class="post-metadata">

**Author:** ![keelo](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.codewithmosh.com/keelo/32/4592_2.png) [@keelo](https://forum.codewithmosh.com/u/keelo)\
**Post date:** [March 24, 2023, 7:03pm UTC](https://forum.codewithmosh.com/t/how-to-run-tables-from-database-in-mysql/19086/6 "2023-03-24T19:03:35Z")

</div>

You have selected ‘open SQL Script’  
Select ‘Create new SQL tab’

 ![](https://us1.discourse-cdn.com/flex020/uploads/codewithmosh/original/2X/8/86b39db0bdac53a39da677818863e8c6b8aba652.png)

---

<div class="post-metadata">

**Author:** ![Rojin](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@Rojin](https://forum.codewithmosh.com/u/Rojin)\
**Post date:** [March 29, 2023, 3:00pm UTC](https://forum.codewithmosh.com/t/how-to-run-tables-from-database-in-mysql/19086/7 "2023-03-29T15:00:51Z")

</div>

Thank you , It worked very well !