mysql常用语句

create table table_name (
  name varchar(20) comment '姓名',
  age int comment '年龄',
  num bigint comment '数值'
  )comment '测试';

insert into table_name values ('名字',18,70);

delete from table_name where name='名字';

select *from table_name;

drop table if exists table_name;

update user set name= '初音未来' where id='17';

update user set name= '鸢一折纸',id='17' where name='鸢一折纸';

update user set id='14' ;

desc table_name;