django mysql去重_[oldboy-django][2深入django]mysql查询语句--原生sql

#1增(一共有三种方式)

# 插入单条记录

insert into t1(name,...) values(‘lzp‘,..);

注意一点：t1(name,...)必须包含所有非空列(除去自增列)

# 插入多条记录

insert into t1(name,age) values(‘lzp‘,12),(‘alex‘,30);

# 拷贝复制(拷贝t2表的数据到t1)

insert into t1(name,age) valuesselect name,age fromt2;

#2改

update t1set name=‘b‘,age=13 where name=‘lzp‘;

update t1set name=‘c‘ where name=‘alex‘;

#3查(重点)select [...] fromtb [...]

从前面[]扩展：select name as cname, age fromtb1; # 起别名select name, age, 1 fromtb1; # 多显示一列，该列的值为常量select name, age, variable fromtb1; # 多显示一列，该列的值为变量，变量的定义在前面实现

从后面的[]扩展：1 where

select name, age from tb1 where id in (2,4,6) # id =2 或id=4,或id=6 集合(2,4,6)select name, age from tb1 where id <> 3 # <>不等于(小于)select name, age from tb1 where id not in (2,4,6)select name, age from tb1 where id between