ADD/DROP VALUE IN TABLE

ADD NEW VALUE TO TABLE


either use insert into or load data


test.txt
xxxx YYY 1999-03-30 \N

mysql> LOAD DATA LOCAL INFILE '/path/test.txt' INTO TABLE pet;
mysql> INSERT INTO table_name VALUES ('xxxx','YYY','1999-03-30',NULL);


UPDATE VALUE IN TABLE


mysql> update table_name set value_name=value where value_name=value


REMOVE ALL VALUE TO TABLE


mysql> delete from pet;

REMOVE TABLE
mysql>  drop table table_name;