Edit the table structure in MYSQL
• So now if you are interested to edit the structure of your database table just click on to the structure tab and select the particular column which you are interested to modify.
• Using the below screen shot I have shown to you how to update the name of the column.
• This is how you can update the table’s column name and save it for the future use.
Import and Export the Database in MYSQL
• Now you have better idea how to create the database, how to create the tables into the database, how to insert the default value, update the database column etc.
• Now if you are interested to take the backup of your database for safety.
• Then Click on the Export tab and specify the location where you want to save the database backup and zip file or not.
Export the Database in MYSQL and save it in particular location.
• Zipped file will be generated on your desktop when you click on the GO button.
• So this is how you can take the backup of your database.
Import the Database in MYSQL
• Now let’s take one example, if you are working on the one pc which is placed in your company and if have deadline for your task so you can copy your php page and also take the database backup.
• Now when you are on the another pc you have your php + database backup, so it’s not required to create the database in individual pc, just take the backup and import that database into another pc where the APACHE AND MYSQL are installed.
• So here I have explained how to import the database. Select specific location where your database backup is stored and click on the GO button your database which is created in the first pc now will worked in to another pc.
• So using above screen shot I teach you how the MYSQL will work with the table and query, now in the next chapter we will discuss how the data which is enter by the user from the HTML code will store into the MYSQL database table.
• Now we have idea how the PHP and MYSQL will work together. MYSQL worked as back end in your project.
• So now if you are interested to edit the structure of your database table just click on to the structure tab and select the particular column which you are interested to modify.
• Using the below screen shot I have shown to you how to update the name of the column.
• This is how you can update the table’s column name and save it for the future use.
Import and Export the Database in MYSQL
• Now you have better idea how to create the database, how to create the tables into the database, how to insert the default value, update the database column etc.
• Now if you are interested to take the backup of your database for safety.
• Then Click on the Export tab and specify the location where you want to save the database backup and zip file or not.
Export the Database in MYSQL and save it in particular location.
• Zipped file will be generated on your desktop when you click on the GO button.
• So this is how you can take the backup of your database.
Import the Database in MYSQL
• Now let’s take one example, if you are working on the one pc which is placed in your company and if have deadline for your task so you can copy your php page and also take the database backup.
• Now when you are on the another pc you have your php + database backup, so it’s not required to create the database in individual pc, just take the backup and import that database into another pc where the APACHE AND MYSQL are installed.
• So here I have explained how to import the database. Select specific location where your database backup is stored and click on the GO button your database which is created in the first pc now will worked in to another pc.
• So using above screen shot I teach you how the MYSQL will work with the table and query, now in the next chapter we will discuss how the data which is enter by the user from the HTML code will store into the MYSQL database table.
• Now we have idea how the PHP and MYSQL will work together. MYSQL worked as back end in your project.
No comments:
Post a Comment