MySQL :: Re: Trying to get 3 simple small tables into SQL and practice query

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: Trying to get 3 simple small tables into SQL and practice query

Posted by: Rick James
Date: July 18, 2014 03:15PM

CSV files are importable and exportable to/from MySQL and Excel.

Excel:
Open the file; it will send you through a wizard to iron out some of the variants of csv.
Save As... to save to csv format.

MySQL:
LOAD DATA ... with appropriate options to specify quotes, delimiters, header, etc.
SELECT INTO OUTFILE ... to write csv

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

Trying to get 3 simple small tables into SQL and practice query

Brian Denneny

July 16, 2014 07:44PM

Re: Trying to get 3 simple small tables into SQL and practice query

Barry Galbraith

July 16, 2014 10:47PM

Re: Trying to get 3 simple small tables into SQL and practice query

Phillip Ward

July 17, 2014 06:20AM

Re: Trying to get 3 simple small tables into SQL and practice query

Brian Denneny

July 18, 2014 01:18PM

Re: Trying to get 3 simple small tables into SQL and practice query

Rick James

July 18, 2014 03:15PM

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.