This tutorial is my favorite I've found so far! Others I've found just brush over Workbench while focusing on MySQL scripting in the command line. This is clear and helpful!
Thank you so much! It really helps! With a minor issue, the default port for my Mac is 3307. I only find it out after I follow other guidance which told me to type SHOW GLOBLE VARIABLE LIKE 'PORT' in the terminal! Again, thank you sir!
I am a beginner and am finding this a very useful course. I am still a bit confused on how to get back to this main screen when I have done some work but am sure that will come with time.
Les, which version of Workbench do you have here? I have My sql Workbench 6.3 and I am trying to work through this video. This version of Workbench has a lot of different bits than the version you are using. Thank you for your video!
+Anthony Starfield Right now, I'm running Workbench 6.3.5 build 201 CE - but this video was made back in 2013, so I expect that was an older version. Some stuff will have moved around a.
I learned a lot Les Bell. But, how to SQL combine the two tables showing TITLE, AUTHOR, PUBLISHER, CITY, that shows only the books published by O'REILLY and ASSOCIATES? Thanks.
+ANTHONY TAN Oh, that's easy - you just an additional condition to the WHERE clause: SELECT title AS Title, author AS Author, coname as Publisher FROM book,publisher WHERE publisher.prfnbr = book.prfnbr AND coname = 'O''Reilly'; (There's no city column in this simple example schema, but if there was one, it would just be added in like this: SELECT title AS Title, author AS Author, coname as Publisher, city AS City FROM book,publisher WHERE publisher.prfnbr = book.prfnbr AND coname = 'O''Reilly'; )
+Les Bell Many thanks, you are my project savior! Very clear instruction and explanation. I hope you can write a book on programming, and more instructional video for a newbie like me :) I am trying now to do a Data Entry Database thru MS DataGrid Control 6.0 (OLEDB) and update MyQL Database. Hope you keep in touch if I need more help. Thanks again a lot. God Bless :)
Hi Les, I'm sorry to bother you but having some problems with MySQL Workbench:I cannot create the physical tables, I've checked permissions, there ok (DBA ticked)I forward engineer the database, no errors, but no tables that I enter data into?Have you any ideas how to fix this?Regards Mark
+Mark James Are you using Workbench to enter your data, or doing it at the command line? Or using program code? One common problem I've seen is creating a user with syntax like CREATE USER 'fred' IDENTIFIED BY 'password'; but then being unable to connect from localhost - you need something like CREATE USER 'fred'@'localhost' IDENTIFIED BY 'password';.
Tell me please when we create table in MySQL Workbanch, there are primary keys. And if it is necessary that there were alternative keys. How to do it, where you define this property?
Apologies for not replying earlier - I'm not a huge UA-cam user, and I missed your question until this morning. I made the video using MySQL Workbench 5.x, and I've only just updated to 6.2.3. They're really hidden "Edit Table Data" well in this version! I eventually found it - in the "Schemas" pane at centre-left of the MySQL Workbench window, click on the twisty triangle to the left of the schema of interest, then click again on the twisty to the left of tables. You'll get a list of tables, and if you hover your mouse over a table name, you'll see three small icons appear to the right - an information icon, a spanner (tools icon), and a table with a pencil on it. That last one is the "Edit Table Data" icon - click it and the result grid will appear in the central pane. From there, you're good to go! Again, apologies for not answering earlier. :(
Julie Camille Esteban Apologies for not replying earlier - I hope you've now seen my answer on the video page, and I also hope that you figured it out without me! Good luck with your course!
Oh - I see what you mean. Oracle moved this option in MySQL Workbench 6.x, as we discussed in the comments below. You need to connect to the database, and then in the "Schemas" pane at centre-left of the MySQL Workbench window, click on the twisty triangle to the left of the schema of interest, then click again on the twisty to the left of tables. You'll get a list of tables, and if you hover your mouse over a table name, you'll see three small icons appear to the right - an information icon, a spanner (tools icon), and a table with a pencil on it. That last one is the "Edit Table Data" icon - click it and the result grid will appear in the central pane. You should be able to enter and edit data from there.
This tutorial is my favorite I've found so far! Others I've found just brush over Workbench while focusing on MySQL scripting in the command line. This is clear and helpful!
Well spoken and very elaborate tutorial. Excellent work.
I am happy. I found this excellent video tutorial the first time around. Thank you Les.
Excellent video, this is exactly the information I was looking for and your explanation is great.
Awesome video. Incredibly clear and helpful.
Edson Cabral Thanks, Edson. I really ought to re-do this one, with a later version of MySQL Workbench. . .
Excellent Tutorial Les.
Thanks for your very kind comment!
Great tutorial Les;
Much better than Oracle videos on this subject. Thanks
very clear.good work and thanks alot
Thanks for your very kind comment!
Excellent info. thank you
Thanks for video it really helped me a lot
Hello, it would be nice to comment the type of relationship you use at 7:00 .
Should not it be an Identifying-relationship between book and publisher?
Love the word 'twit'. We don't use it enough in North America.
Thank you so much! It really helps!
With a minor issue, the default port for my Mac is 3307. I only find it out after I follow other guidance which told me to type SHOW GLOBLE VARIABLE LIKE 'PORT' in the terminal!
Again, thank you sir!
I am a beginner and am finding this a very useful course. I am still a bit confused on how to get back to this main screen when I have done some work but am sure that will come with time.
Thank you so much! A really nice tutorial :)
Les, which version of Workbench do you have here?
I have My sql Workbench 6.3 and I am trying to work through this video. This version of Workbench has a lot of different bits than the version you are using.
Thank you for your video!
+Anthony Starfield Right now, I'm running Workbench 6.3.5 build 201 CE - but this video was made back in 2013, so I expect that was an older version. Some stuff will have moved around a.
nice one>>---------------------->
I learned a lot Les Bell. But, how to SQL combine the two tables showing TITLE, AUTHOR, PUBLISHER, CITY, that shows only the books published by O'REILLY and ASSOCIATES? Thanks.
+ANTHONY TAN Oh, that's easy - you just an additional condition to the WHERE clause:
SELECT title AS Title, author AS Author, coname as Publisher FROM book,publisher WHERE publisher.prfnbr = book.prfnbr AND coname = 'O''Reilly';
(There's no city column in this simple example schema, but if there was one, it would just be added in like this:
SELECT title AS Title, author AS Author, coname as Publisher, city AS City FROM book,publisher WHERE publisher.prfnbr = book.prfnbr AND coname = 'O''Reilly';
)
+Les Bell Many thanks, you are my project savior! Very clear instruction and explanation. I hope you can write a book on programming, and more instructional video for a newbie like me :) I am trying now to do a Data Entry Database thru MS DataGrid Control 6.0 (OLEDB) and update MyQL Database. Hope you keep in touch if I need more help. Thanks again a lot. God Bless :)
Hi Les, I'm sorry to bother you but having some problems with MySQL Workbench:I cannot create the physical tables, I've checked permissions, there ok (DBA ticked)I forward engineer the database, no errors, but no tables that I enter data into?Have you any ideas how to fix this?Regards Mark
+Mark James Are you using Workbench to enter your data, or doing it at the command line? Or using program code? One common problem I've seen is creating a user with syntax like CREATE USER 'fred' IDENTIFIED BY 'password'; but then being unable to connect from localhost - you need something like CREATE USER 'fred'@'localhost' IDENTIFIED BY 'password';.
thank you!
Tell me please when we create table in MySQL Workbanch, there are primary keys. And if it is necessary that there were alternative keys. How to do it, where you define this property?
These are just indexes - you can create indexes on other columns/fields or expressions as required to speed up lookups.
I can't find the edit table data menu on my version of mysql workbench
Mr. Les Bell. I also do have the same problem with this man. I hoping that you can help us with this. My version of MySql Workbench is 6.0. Thank you.
And it happens that my course activity is about a library system. So I am really hoping for your help. Thank you
Apologies for not replying earlier - I'm not a huge UA-cam user, and I missed your question until this morning. I made the video using MySQL Workbench 5.x, and I've only just updated to 6.2.3. They're really hidden "Edit Table Data" well in this version!
I eventually found it - in the "Schemas" pane at centre-left of the MySQL Workbench window, click on the twisty triangle to the left of the schema of interest, then click again on the twisty to the left of tables. You'll get a list of tables, and if you hover your mouse over a table name, you'll see three small icons appear to the right - an information icon, a spanner (tools icon), and a table with a pencil on it. That last one is the "Edit Table Data" icon - click it and the result grid will appear in the central pane. From there, you're good to go!
Again, apologies for not answering earlier. :(
Julie Camille Esteban
Apologies for not replying earlier - I hope you've now seen my answer on the video page, and I also hope that you figured it out without me! Good luck with your course!
+Les Bell Can we use inserts instead of edit table data?? Actually I did find it using your description above. Sorry that I could not find it earlier.
Hello , please how can i find the worhbench central ?
If you're asking where you can download MySQL Workbench, you'll find it at www.mysql.com/products/workbench/
+Les Bell no tha page off edit table data .... in 9.07 minute ..i cant find it!
Oh - I see what you mean. Oracle moved this option in MySQL Workbench 6.x, as we discussed in the comments below. You need to connect to the database, and then in the "Schemas" pane at centre-left of the MySQL Workbench window, click on the twisty triangle to the left of the schema of interest, then click again on the twisty to the left of tables. You'll get a list of tables, and if you hover your mouse over a table name, you'll see three small icons appear to the right - an information icon, a spanner (tools icon), and a table with a pencil on it. That last one is the "Edit Table Data" icon - click it and the result grid will appear in the central pane. You should be able to enter and edit data from there.
doing an assignment for college and im lost plz help!!
Please tell me how to delete a database from the server?
The simplest way is from the command line - the command is "DROP DATABASE databasename".
Thank you very much!