I am a big fan of SOL Server since start of my career and
will be long life may be god knows.. My SOL added in my resume in 2014. No doubt SOL Server is reach in feature and capabilities than MySQL. But today I am sharing
you about MySQL's great feature that impressed me related to MySQL Excel Integration. MySQL is really very
simple and light application, easy to manage and implement.
Yesterday I was working on Excel and I seen an extra add ins option in Excel for MySQL Workbench. I followed the option. Really it impressed
me.. Just see below…
Then excel got connected with remote mysql server and I seen all the databases.
In next step i seen all the selected tables of World Database.
Then i selected a table City and clicked on EDIT MySQL Data. Then i saw 1st Screen of sample data related to city tables. just click here ok.
Now what i seen is all data have been imported into excel sheet with two option , Commit change and revert.
Then i changed 1st rows information and clicked on commit changes.
It shows operation completed successfully.
Now i am connecting to the remote MySQL Server and checking the actual table and data. What i seen change is really committed what i deed in Excel..
Ohhhhhhhh... Reallly its supperb.........
Thnks and happy weekend...
Thnks and happy weekend...
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757