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


On this page of the site you can watch the video online MySQL csv export with a duration of hours minute second in good quality, which was uploaded by the user spa it 19 November 2022, share the link with friends and acquaintances, this video has already been watched 65 times on youtube and it was liked by 5 viewers. Enjoy your viewing!