MySQL Operations
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;
mysql -u username -p database_name < file.sql
DELIMITER $$
CREATE TRIGGER trigger_name
AFTER INSERT
ON wb_going
FOR EACH ROW
BEGIN
...
END$$
DROP TRIGGER trigger_name
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
GRANT ALL PRIVILEGES ON db.* TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
delete
from employee using employee,
employee e1
where employee.id > e1.id
and employee.first_name = e1.first_name