Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* Żeby zapisać bazę w formacie CSV trzeba odpalić te komendy w SQL. userdatabase to nazwa tabeli którą chcesz pobrać. Plik OutputAsCsv znajduje się w C:\xampp\mysql\data */
- SELECT * FROM `userdatabase` WHERE ID IS NOT NULL
- INTO OUTFILE 'C:\OutputAsCsv.csv'
- FIELDS TERMINATED BY ','
- ENCLOSED BY '"'
- LINES TERMINATED BY '\n'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement