MySQL/Syntax

DESCRIBE tabelle;

SET PASSWORD FOR openser@'%'=PASSWORD('123456');
SET PASSWORD FOR openser@localhost=PASSWORD('123456');

GRANT ALL PRIVILEGES ON asterisk.* TO asteriskuser@localhost IDENTIFIED BY 'amp109';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

SELECT dl . * , ht.typ, h.hersteller
INTO OUTFILE "/tmp/goober_downloads.txt"
FIELDS TERMINATED BY ','
FROM `downloads` dl
JOIN handy_typen ht ON dl.handyid = ht.handyid
JOIN handy_hersteller h ON dl.herstellerid = h.herstellerid
WHERE dldate > '2006-05-14'