MySQL Forums
Forum List  »  Newbie

Re: how to run MySQL
Posted by: Jay Alverson
Date: April 06, 2005 10:57AM

a good way is after you get it installed and running, put some data into it.

if you have MS Access it's pretty simple.

setup a DSN (Data Source Name) via the ODBC (open CONTROL PANEL, click on DATA SOURCES). Go to the DRIVERS tab.

find the MySQL ODBC 3.51 driver. if it's not there, download it from this site and install it.

Next make a SYSTEM DSN for your MySQL database.

then go to Access, and open a database. Right click on one of the tables and find EXPORT. When the dialog opens, find ODBC Databases() and click that. Find the SYSTEM DSN you made and select that one.

then export the data (it should be instantaneous unless you've got a lot of records).

it'll build a table for you.

now open MySQL Query Browser and find the table you just created in the MySQL database. if you don't have MySQL Query Browser, download it and install it.

go thru the help file for the MySQL Query Browser, as it's a very nice interface and will make your life much easier.

as soon as you find your new table, double click it and MySQL Query Browser will build a sample SELECT statement for you, run it and see the data.

MySQL Query Browser has a nice HELP, including help for common SQL commands.

Learn how to export the data you just put in.

Lookup the following two SQL commands in the HTML help file (the huge one)

LOAD DATA INFILE and SELECT INTO OUTFILE

to learn how to import/export via CSV files.

Options: ReplyQuote


Subject
Written By
Posted
April 06, 2005 09:27AM
April 06, 2005 09:32AM
April 06, 2005 10:27AM
Re: how to run MySQL
April 06, 2005 10:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.