![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL STUDY
leoxs1994
学习码代码过程中。。。
展开
-
SQL_study_notes5:other_important_notes_about_SQL
1 the union statement KEY 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 阅读 · 0 评论 -
SQL_study_notes4:the_connection_of_tables
1 Introduction 1.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 阅读 · 0 评论 -
SQL_study_notes3:the_common_function
1 the function related to string 1.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 阅读 · 0 评论 -
SQL_study_notes2:the_management_of_tables
1 select statement select * 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 阅读 · 0 评论 -
SQL_study_notes1:the_creation_of_database_and_table
`原创 2020-03-11 18:12:21 · 82 阅读 · 0 评论