常用数据操作语句

项目中接触到java才知晓查询数据库就是涉及到业务逻辑的点

--get

select * from partner_info order by inputtime desc;

select * from partner_info where partnerid="2016112300000011";
-- 删除
delete  from partner_info where partnername = "DXYZ";
delete from partner_info where partnertype ="021";
-- 更新
UPDATE partner_salesman Set password = "123aaa" where userid = "2016111700000001";
-- 查询总记录数
SELECT COUNT(1) ROWS FROM partner_info where levelflag = "1";
-- 厂商下级机构

select * from partner_info where higherid = "4ff3e358-923a-4c8e-a9bf-0e30cbf8169a";

--插入

INSERT INTO partner_ticket_product (ticketid, ticketname,ticketsum) VALUES ('001', '永和大王','15');

-- 为了增加效率  1>anycol>*
select 1 from partner_info;
select sum(1) from partner_info;
select count(*) from partner_info;
-- 2016-11-17