Re: Export mySQL to Excel
Posted by:
Abel Grey
Date: November 02, 2008 12:09AM
Oh, i tried the sql codes by doing this?
sqlstr = "SELECT * FROM container,ship_container;"
If container has 10 records, ship_container will repeat their own entry 1o times like this.
CON1 CAKS01 CON1 02-11-08 01-10-08 01-10-08 02-11-08 02-11-08
CON1 CAKS01 CON2 02-11-08 01-10-08 01-10-08 02-11-08 02-11-08
CON1 CAKS02 CON2 02-11-08 02-10-08 02-10-08 02-11-08 02-11-08
CON1 CAKS03 CON3 02-11-08 03-10-08 03-10-08 02-11-08 02-11-08
CON1 CAKS03 CON4 02-11-08 03-10-08 03-10-08 02-11-08 02-11-08
CON1 CAKS04 CON5 02-11-08 03-10-08 03-10-08 02-11-08 02-11-08
CON1 CAKS05 CON6 02-11-08 04-10-08 04-10-08 02-11-08 02-11-08
CON1 CAKS06 CON7 02-11-08 05-10-08 06-10-08 02-11-08 02-11-08
CON1 VINT01 CON8 02-11-08 05-10-08 06-10-08 02-11-08 02-11-08
CON1 VINT02 CON9 02-11-08 06-10-08 06-10-08 02-11-08 02-11-08
CON1 VINT03 CON10 02-11-08 07-10-08 07-10-08 02-11-08 02-11-08
CON1 VINT04 CON11 02-11-08 08-10-08 08-10-08 02-11-08 02-11-08
CON1 VINT05 CON12 02-11-08 08-10-08 08-10-08 02-11-08 02-11-08
SO how can i import more than 1 table? Thanks alot
Subject
Written By
Posted
November 19, 2008 10:58AM
November 19, 2008 12:16PM
November 19, 2008 12:40PM
November 19, 2008 03:38PM
November 20, 2008 04:07PM
November 20, 2008 04:22PM
December 02, 2008 04:47PM
December 02, 2008 09:19PM
December 03, 2008 10:00AM
December 03, 2008 11:13AM
December 14, 2008 10:19PM
November 01, 2008 05:01AM
November 01, 2008 07:39AM
November 01, 2008 02:18PM
Re: Export mySQL to Excel
November 02, 2008 12:09AM
November 02, 2008 07:00AM
November 02, 2008 08:59AM
November 02, 2008 10:57AM
November 02, 2008 12:44PM
November 03, 2008 09:42PM
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.