This was a true beginners guide! I feel that most beginner guides skip over the fundamentals. They cover the basics, but if you don't know the fundamentals, then Goodluck
I love this video and had to subscribe. The voice is soothing and you get straight to the point. Thanks so much for your efforts in providing us all with this content. Peace and much success for you.
Thank you so much! I am very new to SQL and needed some help with running SQL commands. The book I use is outdated as I have an MacBook with Apple Silicon. Thank you so much for your help! Great video, short and sweet.
Thanks for the tutorial! Btw, don't forget to mention that you have to have an sql server running to make all of this work. I missed that step. 7/14/22, 11:39 p.m.
This is great explanation! I just wanted to understand something better and would appreciate if you could help - When I click Save button at the top left corner of the editor pane, what does it save? Does it save the queries typed into editor or does it save the database? If I insert new data into tables, how do I save that?
Glad you liked it! Good question. This saves the queries typed into the editor. Those queries are saved into a file, just like a text file. This means you can open that file in the future and your queries will be saved. The results won't be shown, but you can run the query again to get the results. Inserting data into a table is saved when the statement is run successfully. There's a concept called a "transaction", which allows a database to either save or undo changes made. To save these changes, you click the Commit button, but I think MySQL Workbench may ask you when you exit if you want to commit your changes.
@@DatabaseStar Hi, please I need your help. I am trying to save the result of an inner join as a new table to perform further queries on but unable to figure out how to do it. Any suggestion on how to go about it?
You can use a concept called Create Table as Select. That will create a new database table using the results (both columns and rows) of a Select query. You can look up the syntax for it.
@@DatabaseStar Please two more thing, I have a date like this: '08-08-2018 08:38' but data type is text. I tried to use this code: SELECT CONVERT(order_purchase_timestamp, datetime) FROM olist_delivery_dataset; to change the datatype to datetime but all the fields returnd NULL. Any guidiance on this. By the also used this SELECT CAST(order_purchase_timestamp AS datetime) FROM olist_delivery_dataset; but also got NULL. (2). What is the right datatype for something like this: 41ce2a54c0b03bf3443c3d931a367089? I am sorry for my too many questions. I am new to this.
Hi, I think we need a tutorial on how to design ERD, create tables and populate an empty (new) database. Most of the tutorials are on existing databases. I am using Dbeaver. Had issues with WorkBench on Linux. Just a simple database would do. Thanks & Best Regards Michael
Good suggestion! I have a few articles and videos on ERDs and creating tables, and some sample databases on my website. I've also got a few courses on my website on creating tables from scratch as well.
To select the database, type > "use databasename;" make sure to terminate with ';' to make sure that statement runs 1st before interacting with the database tables/views etc.
Yeah, you will need a local server such as XAMPP. Or you could install just the MySQL database by downloading the installation files from the MySQL website.
This is a sample database that I created. You can find the steps and all of the SQL scripts to create and populate the database here: www.databasestar.com/sample-bookstore-database/
Anyone know what to make of this error message? 'Command to start the server is not configured. Please set the command that must be used to start the server in the remote management section of this connections settings.'
If it doesn't work, you should get some kind of error message. I usually Google the error and get some good results on sites like StackOverflow. Are you getting an error?
Thanks for the feedback! Yeah, many of my videos from this time (and earlier) were quiet, but since then I've got a new microphone and improved the audio quality and volume, so newer videos should be better.
Do you want to save time while using MySQL Workbench? Get my Timesaver Guide to MySQL Workbench here: www.databasestar.com/timesaver-mysqlwb/?
You have no idea how much I have been struggling with SQL since the beginning of the semester, you have been a GREAT help! Thank you!
That’s great to hear I’ve been helpful with the videos! Is there any particular topic you are struggling with and want me to create a video on?
Thank you so much. I’ve started a course and the instructor didn’t teach how to use the work bench. You’re a lifesaver
Happy to help!
Amazing learning video! Exactly what is needed for a beginner in MySQL Workbench...quick, straight to the point! Congratulations!
Awesome, glad you liked the video!
This was a true beginners guide! I feel that most beginner guides skip over the fundamentals. They cover the basics, but if you don't know the fundamentals, then Goodluck
Glad you like it!
I love this video and had to subscribe. The voice is soothing and you get straight to the point. Thanks so much for your efforts in providing us all with this content. Peace and much success for you.
Thanks! I’m glad you like it. I try to get to the point in my videos as I know a lot of people (me included) dislike long intros to videos.
Most relevant 15-minute about workbench. Made simple :)
Glad it was helpful!
This is so easy to understand! It makes things so simple and quick. Best video on the topic so far.
Glad it was helpful!
very clear, very simple intro video. I just dowloaded mysql workbench so this was very helpful for me. Thanks
Glad it was helpful!
Thank you so much! I am very new to SQL and needed some help with running SQL commands. The book I use is outdated as I have an MacBook with Apple Silicon. Thank you so much for your help! Great video, short and sweet.
Thanks! Glad it was helpful!
More than Crystal clear if you ask me. Really nice DONE! It's kind of meditation/pleasure when you listen to it.. THANK YOU...
Thanks, I'm glad you liked it!
Crystal clear guide, Thank you so much for this great job!
Glad it was helpful!
You're a great teacher. It was simple to understand. Thank you!
You're very welcome!
Amazing tutorial on MySQL workbench !! Thank You So Much .
You are welcome!
Thank you so much!! You have helped me restore my confidence in myself. I was beyond lost in class. ❤❤
No problem, glad it was helpful!
This is a great introductory guide, thank you very much!
Glad it was helpful!
A precise and clear tutorial.
Thumbs up man !!
Thanks!
Absolute lifesaver. Youre amazing for this.
Thanks!
Whole the video was awesome,
Thank you man : )
Glad you liked it!
Thanks for the tutorial! Btw, don't forget to mention that you have to have an sql server running to make all of this work. I missed that step.
7/14/22, 11:39 p.m.
Thanks! Yes, you'll need to have access to a MySQL database to use this software.
This is great explanation! I just wanted to understand something better and would appreciate if you could help - When I click Save button at the top left corner of the editor pane, what does it save? Does it save the queries typed into editor or does it save the database? If I insert new data into tables, how do I save that?
Glad you liked it! Good question. This saves the queries typed into the editor. Those queries are saved into a file, just like a text file. This means you can open that file in the future and your queries will be saved. The results won't be shown, but you can run the query again to get the results.
Inserting data into a table is saved when the statement is run successfully. There's a concept called a "transaction", which allows a database to either save or undo changes made. To save these changes, you click the Commit button, but I think MySQL Workbench may ask you when you exit if you want to commit your changes.
@@DatabaseStar Your response was super helpful! Thank you again!
Very clear introduction to MySql Workbench...Cheers
Glad you liked the video!
You are truly a database star as shown in your channel name...thank you!
Thanks for the nice comment! Glad it was helpful!
@@DatabaseStar Hi, please I need your help. I am trying to save the result of an inner join as a new table to perform further queries on but unable to figure out how to do it. Any suggestion on how to go about it?
You can use a concept called Create Table as Select. That will create a new database table using the results (both columns and rows) of a Select query. You can look up the syntax for it.
@@DatabaseStar Successful! Thank you so much.
@@DatabaseStar Please two more thing, I have a date like this: '08-08-2018 08:38' but data type is text. I tried to use this code: SELECT CONVERT(order_purchase_timestamp, datetime)
FROM olist_delivery_dataset; to change the datatype to datetime but all the fields returnd NULL. Any guidiance on this. By the also used this SELECT CAST(order_purchase_timestamp AS datetime)
FROM olist_delivery_dataset; but also got NULL. (2). What is the right datatype for something like this: 41ce2a54c0b03bf3443c3d931a367089? I am sorry for my too many questions. I am new to this.
Hi,
I think we need a tutorial on how to design ERD, create tables and populate an empty (new) database. Most of the tutorials are on existing databases. I am using Dbeaver. Had issues with WorkBench on Linux. Just a simple database would do.
Thanks & Best Regards
Michael
Good suggestion! I have a few articles and videos on ERDs and creating tables, and some sample databases on my website. I've also got a few courses on my website on creating tables from scratch as well.
Nice video! Your voice is very soothing.
Thanks!
can you please link the video that tells you how to set up the database needed in this video?
Sure, I think it's one of my sample databases, so if I have a video for it I'll link to it in the description.
This is great! Very helpful!
Thanks, glad you like it!
Thanks for the tutorial, it is very helpful, easy to understand and simple.
Glad it was helpful!
Where Were you when i needed you the most
Glad you liked this
Failed to Connect to MySQL at 127.0.0.1:8889 with user root. Please help
Is MySQL running on your computer? Is the password correct? What other message are you getting?
To select the database, type > "use databasename;" make sure to terminate with ';' to make sure that statement runs 1st before interacting with the database tables/views etc.
Thanks for the tip!
very helpful for me. easy to understand, keep sharing. Thanks.
Glad to hear it was helpful!
Thank you for your great video! It is so helpful!!!!
Thanks, glad it was useful!
Thank you so much. Do I need XAMPP or any other local server if I have Workbench?
Yeah, you will need a local server such as XAMPP. Or you could install just the MySQL database by downloading the installation files from the MySQL website.
5:28 I want to know how do we create those tables
This is a sample database that I created. You can find the steps and all of the SQL scripts to create and populate the database here: www.databasestar.com/sample-bookstore-database/
Your voice is so calm and beautiful
Thanks!
Thanks so much for this video! It was very useful and well explained
Glad it was helpful!
Very informative video. Thank you!
Glad it was helpful!
I tried to find more MySQL Workbench tutorial videos on your channel and it doesnt seem there is any. or was I not able to find them?
Hey, this is the only one I have at the moment. What did you want to know more about?
@@DatabaseStar I tried to find a mysql tutorial using mysql workbench, but its fine i decided to use popsql in the end
Could you please help me in setting up the Mysql database ( while connecting) video link
You can write a Create Database command after you connect. Is that what you're looking for?
You are a Hero 🦸♂
Thanks!
Anyone know what to make of this error message?
'Command to start the server is not configured. Please set the command that must be used to start the server in the remote management section of this connections settings.'
Needed to install mysql on mac using brew. Google has instructions on search page.
Glad you got it resolved!
thanks man, was very clear and helpful
Glad it helped!
As soon as I open the Snippets tab, workbench closes. Any solution on that?
That sounds strange. I would guess it's an issue with that version of MySQL Workbench. Are there any solutions when you search Google?
your work is valuable 🙏
Glad you think so!
Hi, I'm getting an error message access denied for user on localhost how can I solve this do I need to grant permission or what?
Yeah it could be a permission issue, or perhaps the password is incorrect. Are you using the default root user or someone else?
Super nice introduction. Really helpful.
Glad it was helpful!
Thanks, love your channel!
Glad you enjoy it!
a well deserved like and sub.
Thanks!
Awesome video, thanks
Glad you liked it!
Lovely!
Thanks!
Thankyou so much for this help👍
You’re welcome!
How do you extract the dataset?
I think there’s a table data export wizard on the database entry on the object explorer or in one of the menus.
Great work 👏 👍
Thanks!
What do I do if testing the connection doesn't work?
If it doesn't work, you should get some kind of error message. I usually Google the error and get some good results on sites like StackOverflow.
Are you getting an error?
Awsome tutorial. Thx!
Glad you enjoyed it!
Very nice.
Thank you!
nice job explaining it.
Thanks!
Also, I don't like idea of coloring again and again. In soft soft mobile, just pick a color and it colors the track, the soft, and the setuper
I’m not sure what this means?
how is it so far .. i've just started and im really overwheld
Hopefully this video can help with understanding the tool!
you're a star! :)
Thanks!
thanks for this video , really helpfull
Glad you liked it!
Which version is this
This is version 8.0, I'm not sure which version specifically.
THANK YOU!!
You're welcome!
how to create a new database?
You can use the Create Database command. I think there is a button on the toolbar too.
Thank you!
You're welcome!
Great VIdeo. Thanks
Glad you liked it!
So easy to understang
Thanks!
LIKE, THANKS BRUH!
No problem!
Thanks!
No problem!
Great tutorial..But shhhhhh be quiet...the baby is sleeping in the next room while Im recording this video
Thanks! Yeah I've since improved how I process audio so my recent videos should be at a better volume.
Thank u
You're welcome!
thank you bro thank you
You’re welcome!
What is pasword , i dont no
You would have set this when you set up the database.
I love your voice bro
Thanks!
amazing
Thanks!
cheers!
No problem!
Thx
No problem!
So hard to understand workbench, not user friendly
Yeah, it can be confusing to learn, and hasn't changed much in a while.
👍👍
Thanks!
I can show you how! Let know!
What do you want to show?
this video is very quiet
Thanks for the feedback! Yeah, many of my videos from this time (and earlier) were quiet, but since then I've got a new microphone and improved the audio quality and volume, so newer videos should be better.
@@DatabaseStar Thank you , keep doing the good work.
Hindi mein kariye
You could use the subtitles for Hindi... I don't speak Hindi unfortunately.
OMG, this guy's voice makes me break stuff with my fists. Can't listen
Thanks for the feedback! I’ve since put a lot of effort into improving my audio quality so hopefully you prefer my newer videos!
This workbench looks like piece of trash compared to PhpMyAdmin. I have been using it for 30 minutes and already hate it.
Oh, you prefer phpMyAdmin to MySQL Workbench? That's good to know. Most comments I've seen are from people who don't like phpMyAdmin!
stop whispering
Thanks! Yeah my older videos such as this one had pretty average sound quality and I apple softer. My newer videos I think are much clearer.