- 博客(5)
- 收藏
- 关注
原创 2021-01-16
插入数据INSERT INTO 表名称 VALUES (值1, 值2,…)INSERT INTO table_name (列1, 列2,…) VALUES (值1, 值2,…)INSERT INTO table2 (column_name(s))SELECT column_name(s)FROM table1;INSERT INTO table2 SELECT * FROM table1;
2021-01-16 16:23:26 63
原创 2021-01-16
删除emp_no重复的记录,只保留最小的id对应的记录。CREATE TABLE IF NOT EXISTS titles_test (id int(11) not null primary key,emp_no int(11) NOT NULL,title varchar(50) NOT NULL,from_date date NOT NULL,to_date date DEFAULT NULL);insert into titles_test values (‘1’, ‘10001’, ‘
2021-01-16 16:20:57 83
原创 replace 用法
REPLACE ( string_expression , string_pattern , string_replacement )题目:CREATE TABLE IF NOT EXISTS titles_test (id int(11) not null primary key,emp_no int(11) NOT NULL,title varchar(50) NOT NULL,from_date date NOT NULL,to_date date DEFAULT NULL);inse
2021-01-16 12:00:51 407
原创 lc 1327
```sqlselect p.product_id,p.product_name,o.unit from 1327products pleft join 1327orders o ON p.product_id=o.product_idwhere o.order_date BETWEEN 2020-02-01 and 2020-02-29group by o.product_id...
2020-03-04 11:35:36 163
原创 lc 1350
```sql'select name from(select s.name,s.department_id,d.id from 1350students s left join 1350department don d.id=s.department_id) a where id is nullselect s.id,s.name from 1350students s left j...
2020-03-04 09:25:22 106
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人