mysql

create database new; 产生一个数据库
use new;使用这个数据库
create table memory1(        产生一个表  
id int primary key auto_increment,
name varchar(30)
);
#drop table memory1; 删除这个表

 

create database new;
use new;
create table memory2(
id int primary key auto_increment,
name varchar(30) unique
);
#drop table memory1;

create index memory1_name_index on memory1(name);

insert into memory1 (name) values ('2334324rr2'), ('23343242wwee');

delete from memory1 where id >2;

update memory1 set name='updatename' where id =2;

select * from memory1 where name like '%name' order by id desc;