marcov4lente
3/16/2017 - 2:10 PM

MySQL Operations

MySQL Operations

Import CSV

LOAD DATA INFILE "/srv/www/ul.csv"
INTO TABLE assignment_margins
COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;

Import SQL FIle

mysql -u username -p database_name < file.sql

Trigger management

Create trigger

DELIMITER $$
CREATE TRIGGER trigger_name
AFTER INSERT 
ON wb_going 
FOR EACH ROW
BEGIN
    ...
END$$

Drop triiger

DROP TRIGGER trigger_name

User Management

Create new user

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

Set user privs to all DBs

GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

Set user privs to DB

GRANT ALL PRIVILEGES ON db.* TO 'newuser'@'localhost';

Refresh privs

FLUSH PRIVILEGES;

Remove duplicates

delete
from employee using employee,
    employee e1
where employee.id > e1.id
    and employee.first_name = e1.first_name