hi all, need some help. I tried checking your wiki site but i'm not a developer and couldn't figure out how to combine queries for what I need... (I have 3 tables in my DB which I need to query for products. DB (mystoredb), tables (products, products_description, manufacturers) I need to export a list of products with certain fields from each table. what's the sql query please?

joseAway

agore, it's searching hidden files and folders..

agore

all mysql on linux and windows have this config fileunix its my.cnf and windows its my.ini

joseAway

They should :| But mine appears to be missingHow could it start without my.ini?

agore

Ive never tried :)but perhaps it can ?and uses defaults

joseAway

Ah. Blame xampp.

jhansen

dim: you need to know the query only, or how to export it as well? in what format?

joseAway

It's executed in a batch file with the line mysql\bin\mysqld --defaults-file=mysql\bin\my.cnf --standalone --console

dim

i have access to phpMyAdmin, so I can just paste query in there..

agore

ah coolso if you edit my.cnf

dim

each product ias information that I need in all 3 tables (products, products_description, and manufacturers)has*from the "products" table I need - products_alternate_name & products_description fieldssorry, this ^^^ was the products_description tableand from the "products" I need - products_model, products_image, products_price

joseAway

Well, I tried setting the default character set... but no dice. I think I'll just remove what I have in the way of mysql libs and servers and get them all the same version this time