mysql的创建加备注comment

创建mysql表格并添加备注

/*创建表格并添加备注（comment）*/
create table bank(
	accont int(10) primary key auto_increment comment '账户',
	pwd varchar(6) not null comment '密码',
	money double not null comment '余额',
	bname varchar(50) not null comment '姓名'
);

insert into bank values(default, '111111', 10000.0,'小狼1');
insert into bank values(default, '222222', 10000.0,'小狼2');
insert into bank values(default, '333333', 10000.0,'小狼3');
insert into bank values(default, '444444', 10000.0,'小狼4');
insert into bank values(default, '555555', 10000.0,'小狼5');
insert into bank values(default, '666666', 10000.0,'小狼6');
insert into bank values(default, '777777', 10000.0,'小狼7');
insert into bank values(default, '888888', 10000.0,'小狼8');
insert into bank values(default, '999999', 10000.0,'小狼9');
insert into bank values(default, '000000', 10000.0,'小狼0');

/*删除数据*/
delete from bank;
/*查询所有*/
select * from bank

最后查询数据结果截图