MySQL provides an easy way to export table result set into a CSV file.
SELECT name, email, age FROM users WHERE status = 'Active';
SELECT name, email, age FROM users WHERE status = 'Active' INTO OUTFILE 'C:/xampp/users.csv' FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"' LINES TERMINATED BY '\r\n';
(SELECT 'Name','Email','Age') UNION ( SELECT name, email, age FROM users WHERE status = 'Active' INTO OUTFILE 'C:/xampp/users.csv' FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"' LINES TERMINATED BY '\r\n'; );
For any types of queries, you can contact us on info[at]namasteui.com.
When was the last time you heard that a clone app like Gojek could efficiently…
The e-commerce market is growing and evolving at a rapid pace. More and more people…
IplWin stands as a reliable and enthralling platform for Indian punters, offering a captivating blend…
Introduction In today's online age, consumers are constantly bombarded with information. They crave valuable content…
In today’s rapidly aging society, finding a living situation that provides older adults with both…
If you wish to purchase a Mac, then it is strongly suggested to consider purchasing…