MySQL for Excel Introduction

Quick video that shows the main features of MySQL for Excel.

Please subscribe to our Youtube channel:
http://www.youtube.com/mysqlchannel

Post your questions about MySQL for Excel on our forum:
http://forums.mysql.com/list.php?172

Find more about MySQL on Windows at our blog:
https://blogs.oracle.com/mysqlonwindows/

Like our MySQL Facebook page:
http://facebook.com/mysql

Follow us on Twitter at:
http://twitter.com/mysql

---

Closed Caption:

hello my name is javier beta i'm a
software developer for the mysql windows
experience them today I'm going to keep
your quick walkthrough and one of the
younger products over my skill family
mysql fall excel this product is the sum
total users to easily access and
manipulate my skill data from within
Excel the different number of steps and
complexity required to do so it is worth
to be mentioned that my scale for excel
is internally powered but mysql
connector doesn''t microsoft visual
studio tools for office
it integrates my ski of workmanship
installed so the same connections to my
school server instances are created in
any of them and use interchangeable
about products the main operations on my
school for excel at towards data import
expert a pen and edit will review them
in detail 114 there on this video for
now let's take a look main panel and
connections we will start by opening
excel then we create a new war book and
select the data menu here we can see the
mice cure for Excel icon click over it
and we'll see the main panel right away
the main panel shows available
connections which has mentioned before
our shared with war bench to create a
new connection with simple click on the
build a new connection and fill in the
blanks
and press ok to save the connection to
connect that data later by right
clicking over to the side connection and
selected connection just change the
information you like and press ok to
process the changes made
now that we have a connection to a
myschool instance we can go sit ski
masks and data objects
notice how the panel always let you know
which server and schema you working on
let's start the four main operations
overview with the airport date operation
once we have selected database object of
this example let it be a table we can
import data directly from the database
the current ex of worship
starting from the current cursor
position you can limit the amount of
data being boarded by columns and rows
also you can escape including column
names to excel if you want to
there are some of that options to
fine-tune the import operation always
keep in mind that some tables will excel
the row limit of an Excel worship the
data will be educated on the last excel
robe and warning will appear if this is
the case notice that you can also import
data from a viewer a procedure in a
similar fashion
now that we have some down to worship we
can show you how to export data
operation works simply select the data
within Excel Word you want to create a
table for and click on export to excel
data to new table in the day of that
appears immediately you will have some
options to customize how the data is
export for example you can define the
tables primary key by selecting which
column which columns will compose it or
you can choose to that my skewer 4xl
Korea and medic primary key for you and
added before other data columns you can
also change the data type or other
properties for each column there are
other events options to fine-tune the
data experts experience once you have
selected a new name for your table just
click on the export data button the
table would have selected data will be
created on the database now let's show
you how you can append data to a table
for simplicity in this example we will
add some rose to the new table created a
few moments ago
first select the table you want to pay
data to then on the excel worship
selected data you want to append to the
table and click on a pen excel data to
tape
finally let's see how you can edit data
from within a table directly into Excel
first we can a table you want to the
data for then we can edit my skill data
similar to the import process we have
are ready to build on this video data
from the selected table will be inserted
into a new Excel bullshit now we can
make some in light headed and see how
the colors on the cells start to change
the blue ones we reflect the changes
that are not yet saved into the my skill
database while the green ones will
reflect changes that had already been
committed today we have learned how to
perform the basic import-export append
and edit operations in my school for
excel please keep in touch other forums
and subscribe to the YouTube channel for
more tutorials and interesting stuff
thanks