mysql语句实现简单的增、删、改、查操作示例

create database if not exists db_shop;

drop database if exists db_shop;

use db_shop;
drop table if exists tb_goods;
CREATE TABLE tb_goods(
 `goodsId` int(11) NOT NULL AUTO_INCREMENT,
 PRIMARY KEY (`tb_goods`)
);

create table tb_goods01 like tb_goods;

drop table tb_goods01;

alter tb_goods add column goodsName varchar(255) after goodsId;

alter table tb_goods drop column goodsName;

insert into tb_goods (goodsId,goodsName) values (1002,'商品1');

select * from tb_goods;

select goodsName fromtb_goods;

select * from tb_goods like '%商品%';

update tb_goods set goodsName='商品2';