- 博客(9)
- 收藏
- 关注
原创 SQL_study_notes5:other_important_notes_about_SQL
1 the union statementKEY POINT:Firstly, union can only take one order by at the end of the statement.Then, the num of columns in each select statement must match. you can not select two columns from the first statement and one from the next.In addition
2020-05-28 14:50:10
123
原创 SQL_study_notes4:the_connection_of_tables
1 Introduction1.1 We need a unique column to connect several tables.In general, the primary key in a table can be used.1.2 The FOREIGN KEY is a column in a table that references the primary key of anoher table.1.3 I can use a foreign key to reference a
2020-05-28 14:16:52
286
原创 SQL_study_notes3:the_common_function
1 the function related to string1.1 right(aa, num) or left(aa, num);###num=1 2 3, use right() and left() to select a specified number of characters from a column.1.2 substring_index(aa, ‘,’, num);###num=1 2 3, use substring_index() to grab part of the
2020-05-26 06:10:10
130
原创 SQL_study_notes2:the_management_of_tables
1 select statementselect * from * where * and * / * or */ is null/ not * like ‘%aa’ or ‘aa %’/ not * like ‘_im’ or ‘_aa%’/(not) * between * and */ in (‘aa’, ‘bb’)/ not in (‘aa’, ‘bb’);notes: =: equ...
2020-05-25 15:13:36
115
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人