# SQL **URL:** https://forum.codewithmosh.com/c/sql/10.md?page=4 [Latest](https://forum.codewithmosh.com/latest.md) · [Categories](https://forum.codewithmosh.com/categories.md) **Page:** 5 --- ## [mySQL installation problems](https://forum.codewithmosh.com/t/mysql-installation-problems/20147)
**Author:** [@Rosalyta](https://forum.codewithmosh.com/u/Rosalyta)\ **Replies:** 3\ **Last updated:** [May 15, 2023, 4:20pm UTC](https://forum.codewithmosh.com/t/mysql-installation-problems/20147 "2023-05-15T16:20:06Z")
Hello everyone! I am completely new to mySQL and I am following the steps to install for Windows. When I try to install I get a different screen to the one that Mosh gets, and then when I click “next” it shows me the fol… --- ## [Sql Course tables](https://forum.codewithmosh.com/t/sql-course-tables/19996)
**Author:** [@Ahmet\_Kemali](https://forum.codewithmosh.com/u/Ahmet_Kemali)\ **Replies:** 0\ **Last updated:** [May 2, 2023, 3:58pm UTC](https://forum.codewithmosh.com/t/sql-course-tables/19996 "2023-05-02T15:58:10Z")
Hi, I am new enrolled in sql course, what I found there is a diffrence between the tables on the Application , that I have installed, and what are you teaching us in the course, For instance , I can Find the customers ta… --- ## [Issues during Installing MySQL on windows](https://forum.codewithmosh.com/t/issues-during-installing-mysql-on-windows/19946)
**Author:** [@orazbek](https://forum.codewithmosh.com/u/orazbek)\ **Replies:** 0\ **Last updated:** [April 29, 2023, 2:51pm UTC](https://forum.codewithmosh.com/t/issues-during-installing-mysql-on-windows/19946 "2023-04-29T14:51:49Z")
Hey dears, I need your support to understand my issue. So let me explain first what’s going on: I had some problems with connection of DB to the VS Code during the Django lessons, but I had already installed MySQL a co… --- ## [Task in Stored Procedure - Solution](https://forum.codewithmosh.com/t/task-in-stored-procedure-solution/19952)
**Author:** [@Davit](https://forum.codewithmosh.com/u/Davit)\ **Replies:** 0\ **Last updated:** [April 29, 2023, 8:33pm UTC](https://forum.codewithmosh.com/t/task-in-stored-procedure-solution/19952 "2023-04-29T20:33:32Z")
Hi Everyone, I am doing SQL mastery course, which is great. At the moment, I am learning how stored procedures are created. I had an exercise with following requirements: Write a stored procedure called get\_payments … --- ## [Information needed](https://forum.codewithmosh.com/t/information-needed/19930)
**Author:** [@sun01egb](https://forum.codewithmosh.com/u/sun01egb)\ **Replies:** 0\ **Last updated:** [April 28, 2023, 11:56pm UTC](https://forum.codewithmosh.com/t/information-needed/19930 "2023-04-28T23:56:04Z")
When installing my MySQL in windows. The Demo you use in teaching. How does the information get into MySQL workbench. Or do we have to create our own database Table to personally practice and make queries to execute. --- ## [Error with stored procedures](https://forum.codewithmosh.com/t/error-with-stored-procedures/19755)
**Author:** [@emmav](https://forum.codewithmosh.com/u/emmav)\ **Replies:** 1\ **Last updated:** [April 21, 2023, 8:49am UTC](https://forum.codewithmosh.com/t/error-with-stored-procedures/19755 "2023-04-21T08:49:17Z")
PLEASE help! --- ## [Did sql course cover "with recursive" command?](https://forum.codewithmosh.com/t/did-sql-course-cover-with-recursive-command/19568)
**Author:** [@someone](https://forum.codewithmosh.com/u/someone)\ **Replies:** 0\ **Last updated:** [April 14, 2023, 6:56am UTC](https://forum.codewithmosh.com/t/did-sql-course-cover-with-recursive-command/19568 "2023-04-14T06:56:21Z")
i have a doubt about it but cannot find the video for it so i can learn it… if it is or not there please reply --- ## [SQLWorkshop crashes when I click on customer table](https://forum.codewithmosh.com/t/sqlworkshop-crashes-when-i-click-on-customer-table/18015)
**Author:** [@Stehaney24](https://forum.codewithmosh.com/u/Stehaney24)\ **Replies:** 3\ **Last updated:** [April 12, 2023, 7:24pm UTC](https://forum.codewithmosh.com/t/sqlworkshop-crashes-when-i-click-on-customer-table/18015 "2023-04-12T19:24:58Z")
When I click on the icon in the red circle my SQLWorkshop crashes. I am new to SQL. Does anyone know how to fix this issue? My error message says: “Termination Reason: Namespace SIGNAL, Code 4 Illegal instruction: … --- ## [Sql force closes everytime i try to execute file](https://forum.codewithmosh.com/t/sql-force-closes-everytime-i-try-to-execute-file/19334)
**Author:** [@thekiranpoudel](https://forum.codewithmosh.com/u/thekiranpoudel)\ **Replies:** 1\ **Last updated:** [April 3, 2023, 9:01pm UTC](https://forum.codewithmosh.com/t/sql-force-closes-everytime-i-try-to-execute-file/19334 "2023-04-03T21:01:08Z")
My SQL application force closes everytime I open the database and then open the customer from Sql\_Store -----Tables—Customers. Does anyone has similar issue? i am using MAC --- ## [Run SQL Course Materials in MySQL](https://forum.codewithmosh.com/t/run-sql-course-materials-in-mysql/19059)
**Author:** [@Rojin](https://forum.codewithmosh.com/u/Rojin)\ **Replies:** 2\ **Last updated:** [March 29, 2023, 3:10pm UTC](https://forum.codewithmosh.com/t/run-sql-course-materials-in-mysql/19059 "2023-03-29T15:10:12Z")
Hi EVEN though I could run these files before in MYSQL I can’t anymore. Here I can not open Tabels in sql\_store. I have followed all the course instructions to download SQL Course Materials Thanks --- ## [How to run tables from database in MySQL?](https://forum.codewithmosh.com/t/how-to-run-tables-from-database-in-mysql/19086)
**Author:** [@Rojin](https://forum.codewithmosh.com/u/Rojin)\ **Replies:** 6\ **Last updated:** [March 29, 2023, 3:00pm UTC](https://forum.codewithmosh.com/t/how-to-run-tables-from-database-in-mysql/19086 "2023-03-29T15:00:51Z")
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 shoul… --- ## [Workbench Crashing when executing a Query](https://forum.codewithmosh.com/t/workbench-crashing-when-executing-a-query/19111)
**Author:** [@unofant](https://forum.codewithmosh.com/u/unofant)\ **Replies:** 5\ **Last updated:** [March 25, 2023, 1:44am UTC](https://forum.codewithmosh.com/t/workbench-crashing-when-executing-a-query/19111 "2023-03-25T01:44:57Z")
I successfully downloaded MySQL and Workbench. I successfully downloaded, extracted, and ran the create databases SQL query. I refreshed the schema tab and the databases are present. However, if I execute any type of que… --- ## [SQL Database Unable Open](https://forum.codewithmosh.com/t/sql-database-unable-open/19098)
**Author:** [@Lyndia](https://forum.codewithmosh.com/u/Lyndia)\ **Replies:** 2\ **Last updated:** [March 24, 2023, 6:04am UTC](https://forum.codewithmosh.com/t/sql-database-unable-open/19098 "2023-03-24T06:04:24Z")
Hello Everyone. I’m beginner in learning the SQL, yesterday I already download the SQL software but when I want to open the SQL material that provide in the video and it show as picture so it make me unable input the dat… --- ## [Complete SQL Masteryyy](https://forum.codewithmosh.com/t/complete-sql-masteryyy/18839)
**Author:** [@molly](https://forum.codewithmosh.com/u/molly)\ **Replies:** 11\ **Last updated:** [March 21, 2023, 4:54pm UTC](https://forum.codewithmosh.com/t/complete-sql-masteryyy/18839 "2023-03-21T16:54:53Z")
Hi Im on the SQL course On the first section Getting Started, 5th video, I can’t CLICK on the YELLOW THUNDER BUTTON AT ALLLLLLLLLLL!!! What’s the problem??? It’s greyed out!!! THANKS!!! --- ## [How to change fonts in SQL](https://forum.codewithmosh.com/t/how-to-change-fonts-in-sql/18879)
**Author:** [@Rojin](https://forum.codewithmosh.com/u/Rojin)\ **Replies:** 7\ **Last updated:** [March 20, 2023, 3:24pm UTC](https://forum.codewithmosh.com/t/how-to-change-fonts-in-sql/18879 "2023-03-20T15:24:46Z")
I installed SQL by following the same instruction which was on the SQL course. I need to change the font size in SQL, however, (Tool ) tab in my SQL doesn’t have (Option) so I can’t change the font size. I use windows … --- ## [How to hide curriculum part of the course videos?](https://forum.codewithmosh.com/t/how-to-hide-curriculum-part-of-the-course-videos/18877)
**Author:** [@Rojin](https://forum.codewithmosh.com/u/Rojin)\ **Replies:** 0\ **Last updated:** [March 17, 2023, 4:06pm UTC](https://forum.codewithmosh.com/t/how-to-hide-curriculum-part-of-the-course-videos/18877 "2023-03-17T16:06:54Z")
Thanks for the great SQL course! I am wondering if I can hide the curriculum part of the page while I am watching the videos? I write the code in SQL while I watch the course videos; therefore, I can’t watch full scree… --- ## [SQL - Need help](https://forum.codewithmosh.com/t/sql-need-help/18824)
**Author:** [@Vivian80](https://forum.codewithmosh.com/u/Vivian80)\ **Replies:** 0\ **Last updated:** [March 16, 2023, 4:38am UTC](https://forum.codewithmosh.com/t/sql-need-help/18824 "2023-03-16T04:38:58Z")
My unzip file is not the same as the instructor, therefore my next steps are not similar to as well. Can anyone help for solving the problem?Thanks. --- ## [Attached files on web courses](https://forum.codewithmosh.com/t/attached-files-on-web-courses/12507)
**Author:** [@Santiago\_Pera](https://forum.codewithmosh.com/u/Santiago_Pera)\ **Replies:** 4\ **Last updated:** [March 16, 2023, 5:31am UTC](https://forum.codewithmosh.com/t/attached-files-on-web-courses/12507 "2023-03-16T05:31:02Z")
Please anyone knows where to find attached pdf files or scripts in SQL web course? --- ## [Alias reference in SQL](https://forum.codewithmosh.com/t/alias-reference-in-sql/18478)
**Author:** [@rohit4334](https://forum.codewithmosh.com/u/rohit4334)\ **Replies:** 0\ **Last updated:** [March 1, 2023, 12:46pm UTC](https://forum.codewithmosh.com/t/alias-reference-in-sql/18478 "2023-03-01T12:46:34Z")
i am in the " subquery in select Clause " chapter to SQL module just wanted to confirm or correct my understanding that, the ALIAS used for a subquery can be used in calculation of difference using SELECT and alias name… --- ## [Difference between GROUP BY and conditional subsqueries in WHERE clause](https://forum.codewithmosh.com/t/difference-between-group-by-and-conditional-subsqueries-in-where-clause/18476)
**Author:** [@rohit4334](https://forum.codewithmosh.com/u/rohit4334)\ **Replies:** 0\ **Last updated:** [March 1, 2023, 8:40am UTC](https://forum.codewithmosh.com/t/difference-between-group-by-and-conditional-subsqueries-in-where-clause/18476 "2023-03-01T08:40:56Z")
I am currently in Correlated Subqueries chapter of SQL and both of the following code is giving same result, i wanted to know whether that stands true in all the scenarios or functioning of both the functions are differe… --- ## [Understanding more on topic "Self Join"](https://forum.codewithmosh.com/t/understanding-more-on-topic-self-join/18427)
**Author:** [@rohit4334](https://forum.codewithmosh.com/u/rohit4334)\ **Replies:** 4\ **Last updated:** [February 27, 2023, 6:04pm UTC](https://forum.codewithmosh.com/t/understanding-more-on-topic-self-join/18427 "2023-02-27T18:04:24Z")
In the self join turotial, i understand the code, but do not undrestand how sql is doing what doing it and unable to graps the concept how thing work in background, so that i can use it any other scenario other than mat… --- ## [Error in "synchronize model with database"](https://forum.codewithmosh.com/t/error-in-synchronize-model-with-database/18388)
**Author:** [@ght](https://forum.codewithmosh.com/u/ght)\ **Replies:** 0\ **Last updated:** [February 23, 2023, 12:43pm UTC](https://forum.codewithmosh.com/t/error-in-synchronize-model-with-database/18388 "2023-02-23T12:43:06Z")
Hi all, in one of the lessons proposed by Mosh he was teaching how to update databases from models. Unfortunately, the procedure he uses “synchronize model with database” tool in MySQL workbench (v8.0) is not working on… --- ## [Forward Engineering Progress Error Prompt](https://forum.codewithmosh.com/t/forward-engineering-progress-error-prompt/18349)
**Author:** [@ibrahimbioabubakar](https://forum.codewithmosh.com/u/ibrahimbioabubakar)\ **Replies:** 0\ **Last updated:** [February 20, 2023, 8:29pm UTC](https://forum.codewithmosh.com/t/forward-engineering-progress-error-prompt/18349 "2023-02-20T20:29:31Z")
Hello, Can someone assist, I get their error prompt in the attached when i try to use the “Forward Engineering Progress” after creating a Physical model. Kindly assist with how I can reverse the error. Thanks --- ## [Post MySQL update, executing any command causes MySQL to crash on a Mac](https://forum.codewithmosh.com/t/post-mysql-update-executing-any-command-causes-mysql-to-crash-on-a-mac/18136)
**Author:** [@jackprescott](https://forum.codewithmosh.com/u/jackprescott)\ **Replies:** 2\ **Last updated:** [February 14, 2023, 3:05am UTC](https://forum.codewithmosh.com/t/post-mysql-update-executing-any-command-causes-mysql-to-crash-on-a-mac/18136 "2023-02-14T03:05:07Z")
Well, I have updated to MySQL version 8.0.32, running on mac monterey. After this update, the navigator panel temporarily disappeared, but that problem has been solved. Now however, executing any query whatsoever will … --- ## [DATA-MODEL correction](https://forum.codewithmosh.com/t/data-model-correction/18195)
**Author:** [@karu](https://forum.codewithmosh.com/u/karu)\ **Replies:** 0\ **Last updated:** [February 12, 2023, 2:43pm UTC](https://forum.codewithmosh.com/t/data-model-correction/18195 "2023-02-12T14:43:58Z")
is this model correct? --- ## [SQL Notes confirmation](https://forum.codewithmosh.com/t/sql-notes-confirmation/18172)
**Author:** [@karu](https://forum.codewithmosh.com/u/karu)\ **Replies:** 0\ **Last updated:** [February 10, 2023, 2:38pm UTC](https://forum.codewithmosh.com/t/sql-notes-confirmation/18172 "2023-02-10T14:38:57Z")
Hey guys, did Mosh sir give any notes for sql course? i wasn’t able to find. please answer with one word atleast yes or no. thanks a lot. --- ## [Unable to fetch the databases tables](https://forum.codewithmosh.com/t/unable-to-fetch-the-databases-tables/17446)
**Author:** [@marc\_tannous](https://forum.codewithmosh.com/u/marc_tannous)\ **Replies:** 3\ **Last updated:** [February 9, 2023, 12:02pm UTC](https://forum.codewithmosh.com/t/unable-to-fetch-the-databases-tables/17446 "2023-02-09T12:02:53Z")
Hello, I am unable to fetch all databases from the file , only one database is fetching , while 3 are not as in the screenshot below : Can someone help me to troubleshoot or fix this issue please ? Thank you ! --- ## [SQL update deleted all schemas](https://forum.codewithmosh.com/t/sql-update-deleted-all-schemas/18021)
**Author:** [@jackprescott](https://forum.codewithmosh.com/u/jackprescott)\ **Replies:** 4\ **Last updated:** [February 3, 2023, 1:08am UTC](https://forum.codewithmosh.com/t/sql-update-deleted-all-schemas/18021 "2023-02-03T01:08:21Z")
I just updated to MySQL version 8.0.32, running on mac monterey. Previously I had completed Mosh’s SQL course, and all the databases were stored in the workbench. After updating, however, not only have all schemas been… --- ## [Unable to open customers data](https://forum.codewithmosh.com/t/unable-to-open-customers-data/17996)
**Author:** [@Stehaney24](https://forum.codewithmosh.com/u/Stehaney24)\ **Replies:** 2\ **Last updated:** [February 1, 2023, 12:58am UTC](https://forum.codewithmosh.com/t/unable-to-open-customers-data/17996 "2023-02-01T00:58:57Z")
When I click on the customers data my app crashes every time. Please advise with a way to fix this as I am a SQL beginner. This is the second step in Part 5- Creating the Databases. --- ## [SQL Query MAX, MIN and AVG](https://forum.codewithmosh.com/t/sql-query-max-min-and-avg/17582)
**Author:** [@Naivedya](https://forum.codewithmosh.com/u/Naivedya)\ **Replies:** 2\ **Last updated:** [January 29, 2023, 1:17pm UTC](https://forum.codewithmosh.com/t/sql-query-max-min-and-avg/17582 "2023-01-29T13:17:00Z")
I seem to be getting an error stating there is LIMIT 0 to 1000 when I apply the MAX or MIN operators. Any idea why this is happening? This is happening after restoring the database. If anyone has had a similar proble… [Previous page](https://forum.codewithmosh.com/c/sql/10.md?page=3) [Next page](https://forum.codewithmosh.com/c/sql/10.md?page=5)