mysql
朴不成
这个作者很懒,什么都没留下…
展开
-
MySQL常用SQL语句
1、复杂SQL查询1.1、单表查询(1)选择指定的列[例]查询全体学生的学号和姓名 select Sno as 学号,Sname as 姓名 from student; select Sno,Sname from student; (2)查询全部列[例]查询全体学生的详细信息select * from student;(3)对查询...转载 2019-03-29 16:41:07 · 560 阅读 · 0 评论 -
mysql 删除表内重复字段,并保留ID最大的一个
DELETE FROM cubeWHERE uploadfile IN ( SELECT t.uploadfile FROM ( SELECT uploadfile FROM cube GROUP BY uploadfile HAVING COUNT( uploadfile ) > 1 ) t ) AND id not in (SELECT dt.maxid FROM (SELE...原创 2019-07-08 17:02:35 · 187 阅读 · 0 评论 -
mysql sql_mode=only_full_group_by报错问题 laravel5.5
配置文件databse.php 文件内strict设为 false,原创 2019-07-08 17:41:40 · 314 阅读 · 0 评论 -
mysql GROUP BY 获取最新的一条记录
SELECT lw.id, lw.uid, lw.title, SUM(lwl.voice_num) as voice_num, lwl.title AS lists_title, lwl.created_at,lw.is_finished,lw.collect_num FROM (SELECT * FROM a WHERE...原创 2019-08-08 10:33:05 · 1515 阅读 · 0 评论