Advertisement
Guest User

Untitled

a guest
Dec 16th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.34 KB | None | 0 0
  1.  
  2. /* Ż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 */
  3.  
  4. SELECT * FROM `userdatabase` WHERE ID IS NOT NULL
  5. INTO OUTFILE 'C:\OutputAsCsv.csv'
  6. FIELDS TERMINATED BY ','
  7. ENCLOSED BY '"'
  8. LINES TERMINATED BY '\n'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement