new.sql

购物车系统

select * from lt_item;
select * from lt_order;
insert into lt_person
values(1,'Tom','male',20,'1358888888','shandongjinan');

select * from lt_person;

select * from lt_hbn;


insert 
    into
        lt_hbn
        (pnAme, gender, age, telNo, address) 
    values
        ('nnn', 'male', 22, '2222', 'kkk')
        
create table lt_person(
	id int primary key AUTO_INCREMENT,
	pName varchar(10) not null,
	gender varchar(10) not null,
	age int not null,
	telNo varchar(15) not null,
	address varchar(20) not null
);

drop table lt_person;

update lt_person
set pName='dd',gender='male',age=55,telNo='666666',address='jinan'  
where id=12;
	
		
select * from lt_product;
delete from lt_product;
insert into lt_product values(1,'pencil','pencil',2.00);
insert into lt_product values(2,'pen','pen',5.00);
insert into lt_product values(3,'rubber','rubber',1.00);
insert into lt_product values(4,'notebook','notebook',2.00);
insert into lt_product values(5,'gluewater','gluewater',5.00);
insert into lt_product values(6,'pencilcase','pencilcase',10.00);
insert into lt_product values(7,'ballpen','ballpen',2.00);
select * from lt_order;
select * from lt_user;
insert into lt_user 
    values(1,'root','123','jinan','250101','root','888888','888888','88888');