Update unifi controller version for Ubuntu

 

 wget download_link

 sudo dpkg -i unifi_sysvinit_all.deb

import csv to mysql

 mysql -uroot -pPassword --local-infile pr_system -e "LOAD DATA LOCAL INFILE '/var/www/html/allitems.csv'  INTO TABLE items  FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n'"

 

Export to CSV format

SELECT
    orderNumber, status, orderDate, requiredDate, comments
FROM
    orders
WHERE
    status = 'Cancelled'
INTO OUTFILE 'C:/tmp/cancelled_orders.csv'
FIELDS ENCLOSED BY '"'
TERMINATED BY ';'
ESCAPED BY '"'
LINES TERMINATED BY '\r\n';