MySQL Workbench Insert, Read, Update, Delete Data Rows

Learn How to Insert, Read, Update and Delete the data rows using MySQL Workbench. Open MySQL Workbench and logged in to MySQL database server using 'root' username and password. In previous video we successfully created a test database called 'mytestdb' and 'students' table using MySQL Workbench. In this video we will see how to insert, update or delete data rows in our 'students' table.

Under schemas menu, select the database name, tables, and table name we created in previous lecture that is 'students' table. When we hover the mouse pointer, over the 'student' table name, we can see a table icon appears. Click the table icon, which open a new window, in which the upper section shows the MySQL statement, while the lower section show the data rows. At this moment, we have no data row in the 'student' table. So the table shows NULL data row values. To enter a new data row, just select the respected column and type the data value. Its something similar to Microsoft Excel spreadsheet. I'll enter data rows, click 'apply' to generate SQL statement, click apply and finish to execute the statement and save the changes.

Similarly, we can edit the data row, save new value and apply the changes, which will generate an update SQL statement and save the changes to the database table. To delete an individual row from the table, select the data row, right click the 'right icon' in-front of the row and select 'delete row' option. Click 'apply' button to execute the SQL statement and save the changes to the database table.

Check out the whole playlist of MySQL Workbench Introduction Tutorials or Individual video from the following links,

MySQL Workbench Tutorial: Introduction to MySQL Workbench for Beginners Playlist

MySQL Workbench: Understand What is MySQL Workbench?

MySQL Workbench Add User and Connect to Database

MySQL Workbench Create, Alter, Drop Database

MySQL Workbench Create, Alter, Drop Table

MySQL Workbench Insert, Read, Update, Delete Data Rows

MySQL Workbench Database Export and Import

[abhayasharma]

Man you saved me. I was searching for this exact tutorial from so long!

[userudbsfmy]

Delete Row option wasn't enabled in my workebench can suggest some trick

[darrena]

Easy to follow tutorial ...will be sitting with this tonight !

[KrishnaManohar]

bro graphically it's ok. in interview point of view what is the command for that?

[tanujamunshi]

sir, can u pls tell me how can i connect visual studio 2010 with mysql workbench 8.0ce ?

[imaniman]

Mine is not working, the result grid is not clickable, the data is recorded from python.

[SyedAli-krqw]

complete noob here. How do I open query window to then edit table? thanks

[ankitthakur]

Grid is not clickable...what to do also there is no apply button

[waseemughal]

Hi, I've used the same method however after clicking the apply button and when finished my all data become to zero (0). Can you advise please? Thanks, Waseem

[kevalshah]

when fire a query i m not able to see the geid result o/p of my table pls elp me with it..

[Geffers]

Hmm, when i try to edit rows, it does not work. MySQL is proving a major pain compared to Microsoft SQL.

[SDPani-knen]

Hello
Why table is not appearing in my system..

[DjGal]

Give an SQL statement that would give the user group 'Managers' the ability to read, update, and add records to the TREATMENT table and to pass this privillege on to the other users.

I need help

[xenonxm]

I thumbed up this video, ONLY and ONLY because it helped me...seriously work on your accent, it's not that difficult. Try to say "Taybl" instead of "Teabool", see?

...and btw I'm desi.