�x��(sh��)�¹�������ֱ�ӳ���
�gӭ���R�ЈD�W(w��ng) Ո(q��ng) | ע��(c��)
> >
MySQL��(sh��)��(j��)��(k��)���g(sh��)�c�(xi��ng)Ŀ��(y��ng)�ý̳�(΢�n��)(��2��)

���] MySQL��(sh��)��(j��)��(k��)���g(sh��)�c�(xi��ng)Ŀ��(y��ng)�ý̳�(΢�n��)(��2��)

�����磺�����]늳���������r(sh��)�g��2022-06-01
�_(k��i)���� 16�_(k��i) �(y��)��(sh��)�� 209
�� �D �r(ji��):¥32.4(6.5��) ���r(ji��)  ¥49.8 ��䛺�ɿ�����(hu��)�T�r(ji��)
����ُ(g��u)��܇(ch��) �ղ�
�_(k��i)������ ȫ��(ch��ng)���]
?�½������س���
������Ǖ�(sh��)����>
�I(m��i)�^(gu��)����Ʒ����߀�I(m��i)��

MySQL��(sh��)��(j��)��(k��)���g(sh��)�c�(xi��ng)Ŀ��(y��ng)�ý̳�(΢�n��)(��2��) ���(qu��n)��Ϣ

MySQL��(sh��)��(j��)��(k��)���g(sh��)�c�(xi��ng)Ŀ��(y��ng)�ý̳�(΢�n��)(��2��) ����(sh��)��ɫ

1.��ʮ���塱š�I(y��)������(gu��)��Ҏ(gu��)���̲ĸİ���2.����΢�n�̌W(xu��)ҕ�l�����׳����ھ�Ľ�n������Դ���a�������n����(x��)�}�������̰����S���YԴ��3.�����(xi��ng)Ŀ��һ�����ס��Ľ̌W(xu��)˼·��������չ��(sh��)Ӗ(x��n)��ͻ�����B(y��ng)��(d��ng)��������

MySQL��(sh��)��(j��)��(k��)���g(sh��)�c�(xi��ng)Ŀ��(y��ng)�ý̳�(΢�n��)(��2��) ��(n��i)�ݺ�(ji��n)��

MySQL ��(sh��)��(j��)��(k��)�Ǯ�(d��ng)ǰ�^�����е��P(gu��n)ϵ�͔�(sh��)��(j��)��(k��)֮һ�������܏�(qi��ng)�����ܺܺ����ѳɞ鮔(d��ng)ǰ��I(y��)��(j��)��(sh��)��(j��)��(k��)�a(ch��n)Ʒ�ă�(y��u)�x�� ����(sh��)�ԾW(w��ng)���̳�ϵ�y(t��ng)�Ĕ�(sh��)��(j��)��(k��)�O(sh��)Ӌ(j��)�c��ģ�������͹������������“(li��n)ȫ��(sh��)��(n��i)������Ԋ(sh��)�~�w����ϵ�y(t��ng)��(sh��)��(j��)��(k��)�Ĺ�����o����얹̺����(sh��)��(j��)��(k��)���P(gu��n)��Փ�ČW(xu��)��(x��)�͌�(sh��)�`��ͨ�^(gu��)�p���O(sh��)Ӌ(j��)��Ԕ��(x��)�U����ʹ��MySQL��(du��)��(y��ng)��ϵ�y(t��ng)�M(j��n)�Д�(sh��)��(j��)��(k��)�O(sh��)Ӌ(j��)�;S�o(h��)��ȫ�^(gu��)�̡�����(sh��)�֞���A(ch��)��(y��ng)��ƪ�Ͳ��e(cu��)��(y��ng)��ƪ�ɂ�(g��)�����������(xi��ng)Ŀһ���(xi��ng)Ŀ�Ğ���A(ch��)��(y��ng)��ƪ���(xi��ng)Ŀ�����(xi��ng)Ŀ�˞鲻�e(cu��)��(y��ng)��ƪ��8��(g��)�(xi��ng)Ŀ��28��(g��)�΄�(w��)�����x���͌�(sh��)��298��(g��)�� ����(sh��)������ߵȽ�����������ԺУӋ(j��)��C(j��)���P(gu��n)���I(y��)�Ľ̲���Ҳ������V��IT���g(sh��)�ˆT�ą����Õ�(sh��)��

MySQL��(sh��)��(j��)��(k��)���g(sh��)�c�(xi��ng)Ŀ��(y��ng)�ý̳�(΢�n��)(��2��) Ŀ�

���A(ch��)��(y��ng)��ƪ
�(xi��ng)Ŀһ �J(r��n)�R(sh��)MySQL 1
�΄�(w��)1 �J(r��n)�R(sh��)��(sh��)��(j��)��(k��) 1
1��1��1 ��(sh��)��(j��)��(k��)�������� 1
1��1��2 ��(sh��)��(j��)��(k��)���g(sh��)�İl(f��)չ 2
1��1��3 �P(gu��n)ϵ�͔�(sh��)��(j��)��(k��) 2
1��1��4 SQL 3
1��1��5 ��(sh��)��(j��)�r(sh��)���Ĕ�(sh��)��(j��)��(k��) 4
�΄�(w��)2 ���b�c����MySQL 4
1��2��1 MySQL���� 4
1��2��2 MySQL���b�c���� 5
1��2��3 ����MySQL������ 8
1��2��4 MySQL��ʹ�� 9
1��2��5 ʹ�ÈD�λ��������ߣ�Navicat��
����MySQL 12
�΄�(w��)3 �O(sh��)��MySQL�ַ��� 14
1��3��1 MySQL�ַ�����(ji��n)�� 14
1��3��2 �O(sh��)��MySQL�ַ��� 16
��(x��)�} 18
�(xi��ng)Ŀ��(sh��)�` 18
��չ��(sh��)Ӗ(x��n) 19
��Ҋ(ji��n)��(w��n)�} 19
�(xi��ng)Ŀ�� �W(w��ng)���̳�ϵ�y(t��ng)��(sh��)��(j��)��(k��)��ģ 20
�΄�(w��)1 ����ϵ�y(t��ng)���� 20
2��1��1 �W(w��ng)���̳�ϵ�y(t��ng)��B 20
2��1��2 ϵ�y(t��ng)�����f(shu��)�� 21
�΄�(w��)2 ����ϵ�y(t��ng)��(sh��)��(j��)ģ�� 22
2��2��1 �P(gu��n)ϵ��(sh��)��(j��)ģ�� 22
2��2��2 ��(sh��)�w���P(gu��n)ϵ 24
2��2��3 ����ģ���O(sh��)Ӌ(j��) 25
2��2��4 ߉݋ģ���O(sh��)Ӌ(j��) 28
2��2��5 �P(gu��n)ϵģʽ��Ҏ(gu��)���� 28
2��2��6 �P(gu��n)ϵ����(sh��) 31
�΄�(w��)3 ʹ��PowerDesigner����ϵ�y(t��ng)
� 36
2��3��1 PowerDesigner��(ji��n)�� 36
2��3��2 PowerDesigner֧�ֵ�ģ�� 36
2��3��3 ��������� 37
2��3��4 ��������� 40
2��3��5 ������c��(sh��)��(j��)��(k��)��������
���� 41
��(x��)�} 42
�(xi��ng)Ŀ��(sh��)�` 43
��չ��(sh��)Ӗ(x��n) 44
��Ҋ(ji��n)��(w��n)�} 45

�(xi��ng)Ŀ�� �����W(w��ng)���̳ǔ�(sh��)��(j��)��(k��)�c
��(sh��)��(j��)�� 46

�΄�(w��)1 ��(chu��ng)���;S�o(h��)��(sh��)��(j��)��(k��) 46
3��1��1 ��(chu��ng)����(sh��)��(j��)��(k��) 46
3��1��2 �鿴��(sh��)��(j��)��(k��) 47
3��1��3 �޸Ĕ�(sh��)��(j��)��(k��) 48
3��1��4 �h����(sh��)��(j��)��(k��) 48
3��1��5 MySQL�Ĵ惦(ch��)���� 49
3��1��6 MySQL��(sh��)��(j��)��(k��)�ĽM�� 50
�΄�(w��)2 ���xMySQL�Ĕ�(sh��)��(j��)��� 51
3��2��1 ����(sh��)��� 51
3��2��2 ��(sh��)��� 52
3��2��3 ������� 53
3��2��4 �ַ������ 54
3��2��5 JSON��� 56
�΄�(w��)3 ��(chu��ng)���Ͳ�����(sh��)��(j��)�� 56
3��3��1 ��(chu��ng)���Ͳ鿴��(sh��)��(j��)�� 56
3��3��2 �޸Ĕ�(sh��)��(j��)�� 60
3��3��3 ��(f��)�Ɣ�(sh��)��(j��)�� 63
3��3��4 �h����(sh��)��(j��)�� 64
�΄�(w��)4 ��(sh��)�F(xi��n)��(sh��)��(j��)�������� 64
3��4��1 PRIMARY KEY�s�� 64
3��4��2 NOT NULL�s�� 66
3��4��3 DEFAULT�s�� 66
3��4��4 UNIQUE�s�� 67
3��4��5 CHECK�s�� 67
3��4��6 FOREIGN KEY�s�� 68
3��4��7 �h���s�� 71
�΄�(w��)5 ���ӡ��޸ĺ̈́h��ϵ�y(t��ng)��(sh��)��(j��) 71
3��5��1 ���Ӕ�(sh��)��(j��) 71
3��5��2 �޸Ĕ�(sh��)��(j��) 75
3��5��3 �h����(sh��)��(j��) 76
��(x��)�} 77
�(xi��ng)Ŀ��(sh��)�` 78
��չ��(sh��)Ӗ(x��n) 79
��Ҋ(ji��n)��(w��n)�} 79

�(xi��ng)Ŀ�� ��ԃ�W(w��ng)���̳�ϵ�y(t��ng)��(sh��)��(j��) 80

�΄�(w��)1 ��ԃ�α픵(sh��)��(j��) 80
4��1��1 SELECT�Z(y��)�� 80
4��1��2 �x���� 81
4��1��3 �x���� 83
4��1��4 ʹ��LIMIT�P(gu��n)�I�����Ʒ���ӛ
䛔�(sh��) 88
4��1��5 ʹ��CASE���_(d��)ʽ���IJ�ԃ
�Y(ji��)�� 89
�΄�(w��)2 ����ͽy(t��ng)Ӌ(j��)�����α픵(sh��)��(j��) 90
4��2��1 ��(sh��)��(j��)���� 90
4��2��2 ��(sh��)��(j��)�ֽM�y(t��ng)Ӌ(j��) 91
4��2��3 ʹ�ô��ں���(sh��)������(sh��)��(j��) 94
�΄�(w��)3 ��ԃ��픵(sh��)��(j��) 96
4��3��1 �B�Ӳ�ԃ��(ji��n)�� 96
4��3��2 �����B�� 97
4��3��3 ��(n��i)�B�� 97
4��3��4 ���B�� 99
4��3��5 ���B�� 99
4��3��6 “(li��n)�ϲ�ԃ 100
�΄�(w��)4 �Ӳ�ԃ��픵(sh��)��(j��) 101
4��4��1 �Ӳ�ԃ��(ji��n)�� 101
4��4��2 �Ӳ�ԃ������_(d��)ʽ 101
4��4��3 �Ӳ�ԃ���������� 103
4��4��4 ���P(gu��n)�Ӳ�ԃ 104
4��4��5 �Ӳ�ԃ���ڸ��”�(sh��)��(j��) 105
��(x��)�} 106
�(xi��ng)Ŀ��(sh��)�` 107
��չ��(sh��)Ӗ(x��n) 108
��Ҋ(ji��n)��(w��n)�} 108

�߼�(j��)��(y��ng)��ƪ

�(xi��ng)Ŀ�� ��(y��u)����ԃ�W(w��ng)���̳�ϵ�y(t��ng)
��(sh��)��(j��) 109

�΄�(w��)1 ʹ��ҕ�D��(y��u)����ԃ���� 109
5��1��1 ҕ�D��(ji��n)�� 109
5��1��2 ��(chu��ng)���Ͳ鿴ҕ�D 110
5��1��3 ͨ�^(gu��)ҕ�D��ԃ��(sh��)��(j��) 113
5��1��4 �S�o(h��)ҕ�D 114
5��1��5 ����ҕ�D 116
�΄�(w��)2 ʹ��������(y��u)����ԃ���� 117
5��2��1 ������(ji��n)�� 117
5��2��2 ��(chu��ng)���Ͳ鿴���� 119
5��2��3 �S�o(h��)���� 121
5��2��4 �������O(sh��)Ӌ(j��)ԭ�t 122
�΄�(w��)3 ����(xi��)��Ч�Ĕ�(sh��)��(j��)��ԃ 123
5��3��1 ��(y��u)����(sh��)��(j��)�L��(w��n) 123
5��3��2 MySQL�Ĉ�(zh��)��Ӌ(j��)�� 124
5��3��3 ��ԃ��(zh��)�еľ��_�r(sh��)�g 126
5��3��4 ����������(y��u)����ԃ 127
5��3��5 LIMIT���(y��)��(y��u)����ԃ 128
5��3��6 ���w������(y��u)����ԃ 129
��(x��)�} 131
�(xi��ng)Ŀ��(sh��)�` 132
��չ��(sh��)Ӗ(x��n) 133
��Ҋ(ji��n)��(w��n)�} 134

�(xi��ng)Ŀ�� ʹ�ó���߉݋�����W(w��ng)��
�̳�ϵ�y(t��ng)��(sh��)��(j��) 135

�΄�(w��)1 ��(sh��)��(j��)��(k��)���̻��A(ch��) 135
6��1��1 SQL�����Z(y��)�Ի��A(ch��) 135
6��1��2 SQL�����̿����Z(y��)�� 138
6��1��3 MySQL���õă�(n��i)�ú���(sh��) 141
�΄�(w��)2 ʹ�ô惦(ch��)����(sh��)��(sh��)�F(xi��n)��(sh��)��(j��)�L��(w��n) 147
6��2��1 ��(chu��ng)���惦(ch��)����(sh��) 147
6��2��2 �{(di��o)�ô惦(ch��)����(sh��) 148
6��2��3 �����惦(ch��)����(sh��) 149
�΄�(w��)3 ʹ�ô惦(ch��)�^(gu��)�̌�(sh��)�F(xi��n)��(sh��)��(j��)�L��(w��n) 149
6��3��1 �惦(ch��)�^(gu��)�̸��� 150
6��3��2 ��(chu��ng)�����{(di��o)�ô惦(ch��)�^(gu��)�� 150
6��3��3 ����(sh��)���惦(ch��)�^(gu��)�� 151
6��3��4 �����惦(ch��)�^(gu��)�� 152
6��3��5 �e(cu��)�`̎�� 152
�΄�(w��)4 ʹ���|�l(f��)����(sh��)�F(xi��n)�΄�(w��)�Ԅ�(d��ng)�� 153
6��4��1 �|�l(f��)������ 153
6��4��2 ��(chu��ng)���|�l(f��)�� 153
6��4��3 �����|�l(f��)�� 155
�΄�(w��)5 ʹ���¼���(sh��)�F(xi��n)�΄�(w��)�Ԅ�(d��ng)�� 155
6��5��1 �¼����� 156
6��5��2 ��(chu��ng)���¼� 156
6��5��3 �����¼� 158
��(x��)�} 159
�(xi��ng)Ŀ��(sh��)�` 160
��չ��(sh��)Ӗ(x��n) 161
��Ҋ(ji��n)��(w��n)�} 161

�(xi��ng)Ŀ�� �S�o(h��)�W(w��ng)���̳�ϵ�y(t��ng)��
��ȫ�� 162

�΄�(w��)1 ��(sh��)��(j��)��(k��)�Ñ���(qu��n)�޹��� 162
7��1��1 ���c��(qu��n)�� 162
7��1��2 ������ 164
7��1��3 ��(qu��n)�޹��� 168
7��1��4 ��ɫ���� 172
�΄�(w��)2 ʹ���„�(w��)���C��(sh��)��(j��)������
��ȫ�� 173
7��2��1 �„�(w��)���� 174
7��2��2 �„�(w��)�Ļ������� 174
7��2��3 �„�(w��)�ĸ��x��(j��)�e 177
�΄�(w��)3 ʹ���i���C�„�(w��)���l(f��)��
��ȫ�� 179
7��3��1 �i�C(j��)�Ƹ��� 179
7��3��2 MySQL����i��� 180
7��3��3 MySQL���i�đ�(y��ng)�� 181
��(x��)�} 182
�(xi��ng)Ŀ��(sh��)�` 183
��չ��(sh��)Ӗ(x��n) 184
��Ҋ(ji��n)��(w��n)�} 184

�(xi��ng)Ŀ�� �S�o(h��)�W(w��ng)���̳�ϵ�y(t��ng)�ĸ�
������ 185

�΄�(w��)1 ��ݺͻ֏�(f��)��(sh��)��(j��) 185
8��1��1 ��ݾW(w��ng)���̳�ϵ�y(t��ng)��(sh��)��(j��) 185
8��1��2 �֏�(f��)��(sh��)��(j��) 188
8��1��3 ��(sh��)��(j��)��(d��o)�� 189
8��1��4 ��(sh��)��(j��)��(d��o)�� 190
�΄�(w��)2 ʹ����־��ݺͻ֏�(f��)��(sh��)��(j��) 193
8��2��1 MySQL��־���� 193
8��2��2 ���M(j��n)����־ 193
8��2��3 �e(cu��)�`��־ 198
8��2��4 ͨ�ò�ԃ?n��i)��?199
8��2��5 ����ԃ?n��i)��?200
��(x��)�} 202
�(xi��ng)Ŀ��(sh��)�` 202
��չ��(sh��)Ӗ(x��n) 203
��Ҋ(ji��n)��(w��n)�} 203
���A �W(w��ng)���̳�ϵ�y(t��ng)��(sh��)��(j��)�� 204
���B Ԋ(sh��)�~�w�����Α�(sh��)��(j��)�� 206
���C MySQL�_(k��i)�l(f��)Ҏ(gu��)�� 208
���D ��(sh��)��(j��)��(k��)��플ӣ��O(sh��)Ӌ(j��)�f(shu��)����DBDD��
��GB/T 8567��2006�� 210
�����īI(xi��n) 211
չ�_(k��i)ȫ��

MySQL��(sh��)��(j��)��(k��)���g(sh��)�c�(xi��ng)Ŀ��(y��ng)�ý̳�(΢�n��)(��2��) ���ߺ�(ji��n)��

���a�x��������Ϣš�I(y��)���g(sh��)�W(xu��)Ժ��Ϣ�W(xu��)Ժ���ڣ���(gu��)�Ҿ�Ʒ�n��ؓ(f��)؟(z��)�����������^(gu��)��ASP NET�W(w��ng)վ�_(k��i)�l(f��)��(sh��)���̳�(��2��)�������A��W(xu��)����������(gu��)��ʮ����Ҏ(gu��)��������SQL Server 2008��(sh��)��(j��)��(k��)�����̡̳������A��W(xu��)�����磩��

���o(w��)�u(p��ng)Փ����
��(sh��)�����]
����픲�
�ЈD�W(w��ng)
�ھ��ͷ�