Hi guys, Welcome to the Advanced Video Search Engine, and you are watching MySQL Workbench Create, Alter, Drop Table. That video is uploaded by PnTutorials by Pradnyankur Nikam at 2016-02-25T11:27:10-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [luBmETAk30k]
| Name | MySQL Workbench Create, Alter, Drop Table |
| Video Uploader | Video From PnTutorials by Pradnyankur Nikam |
| Upload Date | This Video Uploaded At 25-02-2016 19:27:10 |
| Video Discription | Learn How to Create, Alter, Drop database tables using MySQL Workbench. Open MySQL Workbench and logged in to MySQL database server using 'root' username and password. Under 'schema' menu, double click to select the newly created database in my case 'mytestdb', it display the submenu under the database. The submenu contains, the tables, views, stored procedures, function stored under the selected database. At this moment we've just created the database so there are no tables or other information stored in it. Select 'Tables' submenu, right click on it and select 'create table' option, We can also click this top menu 'create new table' icon to create a new table under the selected database. By clicking the 'create table' link or icon open a new screen to enter the database table details. Click inside the middle window and type column name. Lets create the students table here which we saw in practical examples. Click apply button to save the changes, it opens 'SQL statement' window, and click 'apply' button to execute the statement and finish to save the changes. Now under schemas menu, under the selected database, the 'Tables' link will contain the newly created table. We can select the table name to open the table details screen. On this screen, we can modify the column name, data type and other table settings from here. To delete the table, simply select the table name, right click on it, and select 'drop table' option. On confirmation window, select 'drop now' option to instantly delete the table from the database. 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 luBmETAk30k |
| Category | Education |
| Tags | phpsword | MySQL Workbench | Create | Alter | Drop Table | Learn |
