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
https://www.youtube.com/watch?v=aGQ7PGZ1u24&list=PLhwzZMYRiUEq5e5TJCznKVuPAsnNzT8k5
MySQL Workbench: Understand What is MySQL Workbench?
https://www.youtube.com/watch?v=aGQ7PGZ1u24
MySQL Workbench Add User and Connect to Database
https://www.youtube.com/watch?v=P7whjxMqYU4
MySQL Workbench Create, Alter, Drop Database
https://www.youtube.com/watch?v=1qzE6SN8AZU
MySQL Workbench Create, Alter, Drop Table
https://www.youtube.com/watch?v=luBmETAk30k
MySQL Workbench Insert, Read, Update, Delete Data Rows
https://www.youtube.com/watch?v=qb7abQ6ROy4
MySQL Workbench Database Export and Import
https://www.youtube.com/watch?v=Jvul-wr-_Bg
Subscribe to my channel: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
Comments are closed.