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 M...
MySQL Workbench: Understand What is MySQL Workbench?
• MySQL Workbench: Understand What is M...
MySQL Workbench Add User and Connect to Database
• MySQL Workbench Add User and Connect ...
MySQL Workbench Create, Alter, Drop Database
• MySQL Workbench Create, Alter, Drop D...
MySQL Workbench Create, Alter, Drop Table
• MySQL Workbench Create, Alter, Drop T...
MySQL Workbench Insert, Read, Update, Delete Data Rows
• MySQL Workbench Insert, Read, Update,...
MySQL Workbench Database Export and Import
• MySQL Workbench Database Export and I...
Subscribe to my channel: / @pntutorialsbypradnyankurnikam
Sur cette page du site, vous pouvez voir la vidéo en ligne MySQL Workbench Insert, Read, Update, Delete Data Rows durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur PnTutorials by Pradnyankur Nikam 25 février 2016, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 102,615 fois et il a aimé 328 téléspectateurs. Bon visionnage!
