MySQL Workbench Tutorial (2022)
Вставка
- Опубліковано 22 лип 2024
- 📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
MySQL Workbench is a popular MySQL editor. It's free and available from the official MySQL website.
If you're new to MySQL Workbench, then this tutorial will be helpful for you.
In this video, you'll learn a few things, from how to start with creating a connection, creating a database schema, running queries, and viewing some of the common features of the application.
This is my updated tutorial for 2022, with improved audio quality and updates to the tutorial based on feedback on the last video.
Timestamps:
00:00 What is MySQL Workbench?
01:09 Home tab
01:40 Create a new connection in MySQL Workbench
03:14 Edit connections in MySQL Workbench
04:02 Overview of the UI
05:32 Create a new schema
07:13 Write and run Create and Insert statements
09:57 Run a Select statement
11:07 Save an SQL file
12:11 Output panel
12:41 Object browser
13:44 Generate statements
14:31 Import and Export Data overview
15:28 Clean up code with Beautify
16:00 Snippets
16:35 Edit data from results panel - Наука та технологія
This video is fantastic! So clear, concise, and thorough. Sincerely appreciate it!
Glad it was helpful!
I'm just starting to learn SQL and this rly helps acquaint me with the tool. Thank you !
Great to hear!
perfect start with mysql workbench, thank you!
You're welcome!
That was really precise and useful to know when you're starting to work in MySQL workbench, Thanks!
Glad it was helpful!
Thank you so much for making this video. I was desperate to find myself being the only kid using macOS in my class. And all the tutorials from the teacher are on a Windows os. Luckily, I've got this! Cheers mate.
Awesome, glad I could help!
clear and concise. thank you for this, sir! i'll be revisiting this video often, i can tell
Glad it was helpful!
This video was so helpful! Thank you so much
Glad it was helpful!
Thanks a lot for this video. I need to do the project for my studies and this is helping me a lot!😀
Glad it was helpful!
It helped me. watched your videos those are awesome. Thanks for sharing!😎
Glad to help!
Thank you so much for such a detailed explanation❤
Thanks, glad you liked it!
Very, very well done! I really enjoyed your video. thank you...Bob👍
Thanks, I’m glad you liked it!
Thank you so much for this detailed and clear instruction! It helps a lot! 😁
Glad it was helpful!
Hello there, thank you for your sharing, such a great thing. I have a question please. Is there any chance to set the Light theme for MySQL Workbench since I still want to keep the Dark theme from system perspective. I just googled around but had no luck.
No problem! Not that I know of, I've only ever used the light theme.
Hi there! Bottom right corner of the Result Grid, I can only see 'Read Only'. I don't have Apply and Revert. How do I find it, I want to change data from the result panel? Thanks for the help.
I think it's because you haven't selected the primary key in your query, so MySQL Workbench can't work out which row you want to edit.
Fantastic tutorial.
Thanks!
This is a great tutorial clip.
Thanks!
Thank you. I used to use mysqlYog but moved over to Linux and thus needed something new, this was very helpful. I haven't watched the full video yet but I hope this program has the ability to export your databases as sql quarries for backups 🤔
Also a bit of a side note but do you know of any reputable mysql clients on Android? Nothing fancy, I just want to be able to quickly review the information when I'm out and about. 🤔
Glad you liked it. Yes I believe it can export to both formats. I don’t know any clients for android as I’ve never used sql on an android
How to disable UPDATE option in MySQL workbench for mac... I can't find the PREFERENCE option in it.
Do you mean disable updates for users? I don’t think this is a workbench setting. I think it can be done with user privileges.
what is the function of the tools tab in the workbench.... Please provide details
There are a range of features of Workbench that it gives you access to.
hi.
i wonder is it possible to kinda put a folder in where all the tables are? to make it more organized?
and also, i get an error if i remove all the records in the table. i wonder if its something i need to set, that allows a table to be empty. or maybe i just don't need to care about the error.
.
Good question about the folder for tables! I'm not aware of this feature but I can look into it.
Which error are you getting when you remove records? Is it something about a foreign key or parent records?
@@DatabaseStar i cant send a picture on it.
But here is the text:
"MySQL Workbench has encountered a problem Value of '0' is not valid for 'RowCount'. 'RowCount' must be greater than or equal to 1. Parameter name: RowCount We are sorry for the inconvenience but an unexpected exception has been raised by one of the MySQL Workbench modules. In order to fix this issue we would kindly ask you to file a bug report. You can do that by pressing the [Report Bug] button below.
Please make sure to include a detailed description of your actions that lead to this problem. Thanks a lot for taking the time to help us improve MySQL Workbench! The MySQL Workbench Team
"
Nice vid! So how to work on connecting the database to some python code that we wrote in our system? Say coding a login or logout page using python which uses database.
Thanks! Good question. I don’t have python experience but you would need to create a connection to the database in your code somewhere. Then use that connection to run your queries on the database (such as select user details, or insert into login history table)
@@DatabaseStar OK thanks!
I'm on mac silicon and the IDE keeps crashing when running the SELECT statement 10:14 ?? I dropped the schema and tried again, still crashing! Frustrated!
I actually just got an email from someone today with this same issue. I think it’s an issue with the latest version of Workbench (32 I believe). If you try a previous version, that may work.
@@DatabaseStar Thanks! Will try
@@DatabaseStar Yup, older (31) worked fine, thanks!
Why your key words color is blue,mine is gray. How could I switch to blue ?
Oh I’m not sure, I’ve only ever seen it blue. Perhaps it’s a setting in Preferences.
MySQL Workbench is so unintuitive and frustrating to work with. Thanks for making a video to make it a bit easier.
Yeah it can be tough to get things done.
10/10
Thanks!
why schools can't exlpain this much in a 3h class?
That's a shame the school doesn't teach you this stuff, but glad you like the video!
wrong instructions???... I've done everything, and ir didn't worked! therefore I needed to previously install mySQLSERVER and also mySQL connections....
What issue are you having? Which instructions are you referring to?
WHAT ACCENT DOES HE HAVE?
It’s an Australian accent 🇦🇺 😊