MySQL csv export

Published: 19 November 2022
on channel: spa it
65
5

Експорт бази даних

USE base2;
SELECT * FROM Orders INTO OUTFILE '/var/lib/mysql-files/orders.csv';

Зверніть увагу на теку експорту.
MtSQL має право експортувати файл в цю теку.

sudo su
cd /var/lib/mysql-files/
ll

файл має права рута

cp /var/lib/mysql-files/orders.csv /home/spa/Desktop/orders.csv

cd /home/spa/Desktop
ll
rw-r---- 1 root root 127 лис 19 11:47 books.csv

chmod 777 /home/spa/Desktop/orders.csv


Watch video MySQL csv export online without registration, duration hours minute second in high quality. This video was added by user spa it 19 November 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6 once and liked it people.