Part 4 - Using MySQL Workbench To Access Your Data Export

This is a brief tutorial on using MySQL Workbench to access your Oracle RightNow database that has been imported into MySQL Community server.

---

Closed Caption:

good Lori one today
I'm gonna be named demonstration on
utilizing
MySQL Workbench to you view your
database did imported
inner peace demonstration from York
right now
export so getting access to
MySQL Workbench up
program's demise cue much like my skill
work bench
inner peace demonstration we created a
database
and imported other day and database
using the MySQL
command-line utility today we're gonna
access that data base with MySQL
Workbench
so weekend select connect to database
and
sense where runnnn on the scene
workstation
to my excuse me sir
is rain we want to leave the hosts an
email to host the port 3306
eating enough fruit and here
we want to enter are database name
we want to connect you his life test
score for teacher to select
okay
student asks for a password
keen on this opens up the connection
to the database and over here inside you
can see your
database 1402 and all the tables
they've used stored procedures functions
were more concerned
with the tables involved and he's
all the tables that have records in
are SQL database
over here we can perform queries so
let's do a basic worry
its select
again
time
years
scripts
okay so the same here create the account
stable
so we're going to select the account ID
to log in
last name first name from accounts and
we ended at the semi-colon this has to
be
proper my skills and tax were to work
your and the
the ENTER button does not executed Korea
appear and select like balter
and as you can see
I return for query is
in this field below here said
make figures so we have our
record set here that from Macquarie
and what we can do with this record said
years
we can actually exported to
a CSV format if you like and
what you do here is which you get your
record set
that you want from your tables and
your day to return you can select this
but here and
we're gonna wanna name it just name it
accounts that
table and we have these different types
here that we can
exported as and just use standard CSP
and
selects a
with that allows us to do is save
record sets in different formats I
believe it's going to be here
my documents folder CD accounts that to
people
CSP we open it with some text editor
you can see that it does return a comma
separated for me
and
this is an ballots yes recent ex
please keep in mind it
she sp is it has a pretty fraud
spectrum
what's allowed and what you can do it
there's not
anyone particular format
I'm and times certain record sets can
return values that will break
the CSV format when it exported to CSP
and that is one of the main reasons why
we do not recommend that as your primary
data export
I'm for your
Oracle RightNow CX ed
database export and with tools such as
MySQL Workbench
you can perform those functions yourself
and
manipulate the record sets as you see
fit and that does conclude
are demonstration thank you very much
for watching
good