MySQL export specific fields from multiple table into one csv file? CREATE TABLE outputs

Question

I need to integrate my e-commerce with the local system.

I need to export specific fields from multiple tables of my database into a csv file.

I need from TABLE jos_virtuemart_products those fields product_sku , product_in_stock , low_stock_notification , product_length , product_width , product_height , product_weight

then

I need from TABLE jos_virtuemart_products_en_gb those fields purodct_name , product_s_desc

then the out put csv file should me imported to another database table that has all those fields from the others 2 table above.

Is it possible to be ran by mysql command in the linux command line? or I will have to figure out other way?

Have some one been in this situation?

Which is the best way to do this itegration?

Joshua Martell · Accepted Answer · 2012-10-21 01:50:02Z

1

If you can write a query for what you want, you can use SELECT ... INTO OUTFILE to write it to a CSV file on the server. Add FIELDS TERMINATED BY to set the separator to ',' as the default is to use tabs.

http://dev.mysql.com/doc/refman/5.5/en/select-into.html

answered Oct 21, 2012 at 1:50

Joshua Martell

7,2122 gold badges33 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

19 Comments

felipe.miranda Over a year ago

Hi Joshua, I did end up with this steps: 1.TEE Results.csv SELECT product_sku FROM jos_virtuemart_products; SELECT product_weight FROM jos_virtuemart_products; NOTEE

felipe.miranda Over a year ago

sorry got a little massed up with this comment, what i would like to say is that i create a file with this command TEE Results.csv SELECT product_sku FROM jos_virtuemart_products; SELECT product_weight FROM jos_virtuemart_products; NOTEE and then ran with this command: mysql -u root -p -h localhost table_name < tee.test and after it printed on my screen the columns it said that outfile is desable and couldn't create the file.

felipe.miranda Over a year ago

Okay according to [link]dev.mysql.com/doc/refman/5.1/en/mysql-commands.html[/link] I removed the ending line NOTEE so the out put now didn't show the outfile desable but either created a file???

felipe.miranda Over a year ago

Okay now I did it with SELECT ... INTO OUTFILE and it seems like this SELECT product_sku, product_in_stock, low_stock_notification, product_length, product_width, product_height, product_weight INTO OUTFILE 'jos_virtuemart_products.csv' FIELDS TERMINATED BY ',' FROM jos_virtuemart_products; but I need to get data from multiple tables and mixe them in the same out put file did you understand?

Joshua Martell Over a year ago

You need to join two tables together, something like: SELECT * FROM jos_virtuemart_products AS a, jos_virtuemart_products_en_gb AS b WHERE a.product_sku=b.product_sku. You can also define your new table and move the data into the new table directly in MySQL: INSERT INTO newtable SELECT …

|

Scott Hunter · Accepted Answer · 2012-10-21 00:47:42Z

0

If you can produce a query that results in the table for the new system (probably using some kind of join), you can export THAT to a csv file.

answered Oct 21, 2012 at 0:47

Scott Hunter

50k12 gold badges64 silver badges107 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:48:10Z

0

I did solve my problem with help of @Joshua Martell and what has openned my eyes was this post PHP mySQL, Joining More than Two Tables Together with Similar IDs? with the answer from @Jatin Dhoot thank y'all!

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Oct 23, 2012 at 23:36

felipe.miranda

211 silver badge5 bronze badges

Collectives™ on Stack Overflow

MySQL export specific fields from multiple table into one csv file? CREATE TABLE outputs

3 Answers 3

19 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

19 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related