我不打朋友圈

题解

/ 注册

全部文章 / 题解（共53篇）

题解 | #Where in 和Not in#

CREATE INDEX idx_duration ON examination_info(duration); create UNIQUE index uniq_idx_exam_id ON examination_info(exam_id); create FULLTEXT index full...

Mysql

2021-12-14

0 254

题解 | #Where in 和Not in#

DROP TABLE IF EXISTS exam_record_2011, exam_record_2012, exam_record_2013, exam_record_2014 drop table if exists exam_record_2011,exam_record_2012,exa...

Mysql

2021-12-14

0 288

题解 | #Where in 和Not in#

ALTER TABLE user_info ADD school varchar(15) after level; ALTER TABLE user_info CHANGE job profession varchar(10); ALTER TABLE user_info modify achiev...

Mysql

2021-12-14

0 321

题解 | #Where in 和Not in#

create table if not exists user_info_vip( id int(11) primary key auto_increment comment '自增ID', uid int(11) not null unique comment '用户ID', nick_name...

Mysql

2021-12-14

0 394

题解 | #Where in 和Not in#

delete from exam_record where TIMESTAMPDIFF(minute,start_time,submit_time) < 5 and score <60 DELETE from exam_record where timestampdiff(minute,...

Mysql

2021-12-14

0 278

题解 | #Where in 和Not in#

delete from examination_info where exam_id=9003; insert into examination_info value(null,9003,'SQL','hard',90,'2021-01-01 00:00:00'); delete from exam...

Mysql

2021-12-14

0 321

题解 | #Where in 和Not in#

INSERT INTO exam_record_before_2021 SELECT NULL,uid, exam_id, start_time, submit_time, score FROM exam_record WHERE submit_time < '2021-01-01 00:00...

Mysql

2021-12-14

0 314

题解 | #Where in 和Not in# 来自专栏

insert into exam_record (id,uid,exam_id,start_time,submit_time,score) values (null,1001,9001,'2021-09-01 22:11:12','2021-09-01 23:01:12',90), (null,10...

Mysql

2021-12-14

0 259

题解 | #Where in 和Not in# 来自专栏

import java.io.BufferedReader; import java.io.IOException; import java.io.InputStreamReader; public class Main{ public static void main(String[] args)...

Mysql

2021-12-14

0 359

题解 | #Where in 和Not in# 来自专栏

import java.io.BufferedReader; import java.io.InputStreamReader; import java.io.IOException; public class Main{ public static void main(String[] args)...

Mysql

2021-12-14

0 261