INSERT

Simple format

insert into bbs_notice values (2, 'test title 2', CURDATE(), 'test content 2');

If there is AUTO_INCREMENT key, use more detailed format:

insert into bbs_sermonvod (title, written_on, content) 
values ( 'test title', '2016-12-30', 'https://www.youtube.com/watch?v=FHYbgtbBhHc');

REF

ALTER

alter table bbs_notice modify column count integer(3) not null default '0';

Date

Delete all rows

1)delete from mytable: This will delete all the content of the table, not reseting the autoincremental id, this process is very slow. If you want to delete specific records append a where clause at the end.

2)truncate myTable:This will reset the table i.e. all the auto incremental fields will be reset. Its a DDL and its very fast. You cannot delete any specific record throughtruncate

ref