站点版块：����IT��Ƶ�̳��� · 列表：fid=850 第1页
replyreload += ',' + 119806;��Mysql������ʵ�ܼ�ȫ����Ƶ�̳� ������PDF
�̷̳dz�������ͨ�����̵̳�ѧϰ���Էdz����ٵ�����Mysql�����ʺ�ѧϰ���Ƽ���
��������Դ�����www.santongit.com���ޱ���.png (31.33 KB, ���ش���: 48)
���ظ���
2014-10-17 22:39 �ϴ�
�����Ŀ¼������PDF��Ŀ¼ ������Ƶ�̵̳�Ŀ¼
Ŀ¼ ............................................................................................................................................................................................................. 1
�� 1 �� ���ݿ���� ............................................................................................................................................................................... 7
1.1�����ݴ洢��ʽ ......................................................................................................................................................................... 7
1.2�����ݿⷺ�� ............................................................................................................................................................................. 7
1.3��SQL ���� ................................................................................................................................................................................ 7
1.4��ΪʲôҪʹ�� MySQL........................................................................................................................................................... 7
1.5���������ݿ�ϵͳ ..................................................................................................................................................................... 8
�� 2 �� Windows ƽ̨�°�װ������ MySQL ..................................................................................................................................... 8
2.1��msi ��װ�� ............................................................................................................................................................................. 8
2.1.1����װ .......................................................................................................................................................................... 8
2.1.2��� .......................................................................................................................................................................... 9
2.2��zip �ļ���δ��֤��............................................................................................................................................................... 9
2.2.1����װ .......................................................................................................................................................................... 9
2.2.2��� .........................................................................................................................................................................10
2.3������ò�����ʹ�÷��� ....................................................................................................................................................10
2.3.1��mysql ......................................................................................................................................................................10
2.3.2��mysqladmin ..........................................................................................................................................................11
�� 3 �� Linux ƽ̨�°�װ������ MySQL ...........................................................................................................................................11
3.1��RPM �ļ���װ ......................................................................................................................................................................11
3.2����މ�c�ļ���װ ....................................................................................................................................................................11
3.3��Դ���ļ���װ ........................................................................................................................................................................11
�� 4 �� MySQL �������� ......................................................................................................................................................................12
4.1���������� ................................................................................................................................................................................12
4.2�������� ....................................................................................................................................................................................12
4.3�����ں�ʱ�� ............................................................................................................................................................................12
4.4���ַ��� ....................................................................................................................................................................................12
4.5����މ�c ....................................................................................................................................................................................13
�� 5 �� �������ݿ� ................................................................................................................................................................................13
5.1����ʾ���������������ݿ� ....................................................................................................................................................13
5.2�����ݿ�洢���� ....................................................................................................................................................................13
�� 6 �� �������ĺͳ�����.................................................................................................................................................................14
6.1�������� ....................................................................................................................................................................................14
6.1.1���������IJ��ʽ ..................................................................................................................................................14
6.1.2���������� ..........................................................................................................................................................14
6.1.3��������� ..........................................................................................................................................................15
6.1.4�����ñ��ķǿ�Լ�� ..................................................................................................................................................15
6.1.5�����ñ���Ψһ��Լ�� ..............................................................................................................................................15
6.1.6�����ñ�������ֵ��۽���� ......................................................................................................................................16
6.1.7�����ñ������Ե�Ĭ��ֵ ..........................................................................................................................................16
6.2���鿴���ṹ ............................................................................................................................................................................16
6.2.1���鿴�������ṹ��� DESCRIBE ...........................................................................................................................16
6.2.2���鿴����ϸ�ṹ��� SHOW CREATE TABLE .....................................................................................................16
6.3���ı� ....................................................................................................................................................................................17
6.3.1���ı��� .................................................................................................................................................................17
6.3.2�����ֶε��������� ..............................................................................................................................................17
6.3.3~6.3.6���ֶμ��������͵������������Լ��ı�λ�� ...........................................................................................17
6.3.7�����ı��Ĵ洢���� ..................................................................................................................................................17
6.3.8�������������Լ�� ..................................................................................................................................................17
6.4�������� ....................................................................................................................................................................................18
6.4.1������û�б���������ͨ�� ......................................................................................................................................18
6.4.2�������������������ĸ��� ......................................................................................................................................18
�� 7 �� ���� ............................................................................................................................................................................................18
7.1��������� ................................................................................................................................................................................18
7.1.1�������Ķ�����ص� ..................................................................................................................................................18
7.1.2�������ķ��� ..............................................................................................................................................................19
7.1.3�����������ԭ�� ......................................................................................................................................................19
7.2���������� ................................................................................................................................................................................19
7.2.1����������ʱ������ ..........................................................................................................................................20
1��������ͨ���� .....................................................................................................................................................20
2������Ψһ������ .................................................................................................................................................20
3������ȫ������ .....................................................................................................................................................20
4�������������� .....................................................................................................................................................20
5�������������� .....................................................................................................................................................21
6�������ռ����� .....................................................................................................................................................21
7.2.2�����Ѿ����ڵı��ϴ������� ..................................................................................................................................21
1��������ͨ���� .....................................................................................................................................................21
2������Ψһ������ .................................................................................................................................................21
3������ȫ������ .....................................................................................................................................................22
4�������������� .....................................................................................................................................................22
5�������������� .....................................................................................................................................................22
6�������ռ����� .....................................................................................................................................................22
7.2.3���� ALTER TABLE ������������� ........................................................................................................................22
1��������ͨ���� .....................................................................................................................................................22
2������Ψһ������ .................................................................................................................................................22
3������ȫ������ .....................................................................................................................................................22
4�������������� .....................................................................................................................................................23
5�������������� .....................................................................................................................................................23
6�������ռ����� .....................................................................................................................................................23
7.3���������� ................................................................................................................................................................................23
�� 8 �� ��ͼ ............................................................................................................................................................................................23
8.1����ͼ��� ................................................................................................................................................................................23
8.2��������ͼ ................................................................................................................................................................................23
8.3���鿴��ͼ ................................................................................................................................................................................24
8.4������ͼ ................................................................................................................................................................................24
8.5��������ͼ ................................................................................................................................................................................25
8.6 ��������ͼ ..............................................................................................................................................................................25
�� 9 �� ������ ......................................................................................................................................................................................25
9.1������������ ............................................................................................................................................................................26
9.1.1����������һ��ִ�в��Ĵ����� ...............................................................................................................26
9.1.2�������ж��ִ�в��Ĵ����� ...................................................................................................................26
9.2���鿴������ ............................................................................................................................................................................26
9.3����������ʹ�� ........................................................................................................................................................................26
9.4������������ ............................................................................................................................................................................27
�� 10 �� ��ѯ���� ....................................................................................................................................................................................27
10.1��������ѯ���......................................................................................................................................................................27
10.2��������ѯ .............................................................................................................................................................................27
10.3��ʹ�ü���������ѯ ..............................................................................................................................................................28
10.4�����Ӳ�ѯ .............................................................................................................................................................................28
10.4.1�������Ӳ�ѯ ...........................................................................................................................................................28
10.4.2�������Ӳ�ѯ ...........................................................................................................................................................28
10.5���Ӳ�ѯ .................................................................................................................................................................................28
10.6���ώԲ�ѯ���......................................................................................................................................................................28
10.7��Ϊ�����ֶ΅�ɾ�� ..............................................................................................................................................................29
10.8��ʹ���������ʽ��ѯ ..........................................................................................................................................................29
�� 11 �� �I�롢���²��������� ............................................................................................................................................................29
11.1���I������ .............................................................................................................................................................................29
11.1.1��Ϊ���������ֶΓI������ ....................................................................................................................................29
11.1.2��Ϊ����ָ���ֶΓI������ ....................................................................................................................................30
11.1.3��ͬʱ�I��������� ................................................................................................................................................30
11.1.4������ѯ����I��b���� ........................................................................................................................................30
11.2���������� .............................................................................................................................................................................30
11.3���������� .............................................................................................................................................................................30
�� 12 �� MySQL ����� .........................................................................................................................................................................31
12.1����������� .........................................................................................................................................................................31
12.2���Ƚ������ .........................................................................................................................................................................31
12.3��������� .........................................................................................................................................................................31
12.4������ .............................................................................................................................................................................31
�� 13 �� MySQL ���� .............................................................................................................................................................................32
13.1����ѧ���� .............................................................................................................................................................................32
13.2���ַ������� .........................................................................................................................................................................32
13.3�����ں�ʱ������ ..................................................................................................................................................................32
13.4�������`������......................................................................................................................................................................32
13.5��ϵͳ��Ϣ����......................................................................................................................................................................32
13.6���������� .............................................................................................................................................................................33
13.7����ʽ������ .........................................................................................................................................................................33
�� 14 �� �洢���̺����� ........................................................................................................................................................................33
14.1�������洢���̺����� ..........................................................................................................................................................34
14.1.1�������洢���� .......................................................................................................................................................34
14.1.2�������洢���� .......................................................................................................................................................34
14.1.3��������ʹ�� ...........................................................................................................................................................35
1��������� .............................................................................................................................................................35
2��Ϊ������ֵ .........................................................................................................................................................35
14.1.4�����������ʹ������� ............................................................................................................................................35
1���������� .............................................................................................................................................................35
2�����崦������ .....................................................................................................................................................36
14.1.5������ʹ�� ...........................................................................................................................................................36
1��������� .............................................................................................................................................................36
2����� .............................................................................................................................................................36
3��ʹ�ù�� .............................................................................................................................................................37
4���رչ�� .............................................................................................................................................................37
14.1.6�����̿c��ʹ�� ...................................................................................................................................................37
1��IF ��� .................................................................................................................................................................37
2��CASE ��� ..........................................................................................................................................................37
3��LOOP ��� .........................................................................................................................................................38
4��LEAVE ��� ........................................................................................................................................................38
5��ITERATE ��� .....................................................................................................................................................39
6��REPEAT ��� ......................................................................................................................................................39
7��WHILE ���........................................................................................................................................................39
14.2�����ô洢���̺����� ..........................................................................................................................................................39
14.2.1�����ô洢���� .......................................................................................................................................................40
14.2.2�����ô洢���� .......................................................................................................................................................40
14.3���鿴�洢���̺����� ..........................................................................................................................................................40
14.4���Ĵ洢���̺����� ..........................................................................................................................................................40
14.5�������洢���̺����� ..........................................................................................................................................................40
�� 15 �� MySQL �û����� .....................................................................................................................................................................41
15.2���˻����� .............................................................................................................................................................................41
15.2.1����¼���˳� MySQL ������ ................................................................................................................................41
15.2.2���½�����ͨ�û� ...................................................................................................................................................41
15.2.3��������ͨ�û� .......................................................................................................................................................41
15.2.4��root �û����Լ������� ...................................................................................................................................42
15.2.5��root �û�����ͨ�û����� ...............................................................................................................................42
15.2.6����ͨ�û������� ................................................................................................................................................42
15.2.7��root �û����붪ʧ�Ľ���취 ...........................................................................................................................43
15.3��Ȩ���� .............................................................................................................................................................................43
15.3.1��MySQL �ĸ���Ȩ�� .............................................................................................................................................43
15.3.2����Ȩ .......................................................................................................................................................................43
15.3.3���ջ�Ȩ�� ...............................................................................................................................................................44
�� 16 �� ���ݱ�������ԭ ........................................................................................................................................................................44
16.1�����ݱ��� .............................................................................................................................................................................44
16.1.1��ʹ�� mysqldump ����� .............................................................................................................................44
16.1.2��ֱ�Ӹ��c�������ݿ�Ŀ¼ ....................................................................................................................................45
16.1.3��ʹ�� mysqlhotcopy ���߿��ٱ��� ...................................................................................................................45
16.2�����ݻ�ԭ .............................................................................................................................................................................45
16.2.1��ʹ�� mysql ���ԭ ..........................................................................................................................................45
16.2.2��ֱ�Ӹ��c�b���ݿ�Ŀ¼ ........................................................................................................................................45
16.3�����ݿ�Ǩ�� .........................................................................................................................................................................45
16.3.1����ͬ�汾�� MySQL ���ݿ�Y���Ǩ�� .............................................................................................................45
16.3.2��آͬ�汾�� MySQL ���ݿ�Y���Ǩ�� .............................................................................................................45
16.3.3��آͬ���ݿ�Y���Ǩ�� ........................................................................................................................................45
16.4�����ĵ����͵��� ..................................................................................................................................................................46
16.4.1���� SELECT��INTO OUTFILE �����ı��ļ� .......................................................................................................46
16.4.2���� mysqldump ������ı��ļ�....................................................................................................................46
16.4.3���� mysql ������ı��ļ� ...............................................................................................................................46
16.4.4���� LOAD DATA INFILE ��ʽ�����ı��ļ� .......................................................................................................46
16.4.5���� mysqlimport ������ı��ļ� ..................................................................................................................46
�� 17 �� MySQL ��־ .............................................................................................................................................................................47
17.1����־��� .............................................................................................................................................................................47
17.2����މ�c��־ .........................................................................................................................................................................47
17.2.1����۽�����ö�މ�c��־ ........................................................................................................................................47
17.2.2���鿴��މ�c��־ ...................................................................................................................................................47
17.2.3��������މ�c��־ ...................................................................................................................................................47
17.2.4��ʹ�ö�މ�c��־��ԭ���ݿ� ................................................................................................................................48
17.2.5����ʱֹͣ��މ�c��־���� ....................................................................................................................................48
17.3����ڻ��־ .............................................................................................................................................................................48
17.3.1����۽�����ô�ڻ��־ ............................................................................................................................................48
17.3.2���鿴��ڻ��־ .......................................................................................................................................................48
17.3.3��������ڻ��־ .......................................................................................................................................................49
17.4��ͨ�ò�ѯ��־......................................................................................................................................................................49
17.4.1����۽������ͨ�ò�ѯ��־ ....................................................................................................................................49
17.4.2���鿴��ڻ��־ .......................................................................................................................................................49
17.4.3������ͨ�ò�ѯ��־ ................................................................................................................................................49
17.5������ѯ��־ .........................................................................................................................................................................49
17.5.1����۽����������ѯ��־ ........................................................................................................................................50
17.5.2���鿴����ѯ��־ ...................................................................................................................................................50
17.5.3����������ѯ��־ ...................................................................................................................................................50
17.6���� .....................................................................................................................................................................................50
�� 18 �� �����Ż� ....................................................................................................................................................................................51
18.1���Ż���� .............................................................................................................................................................................51
18.2���Ż���ѯ .............................................................................................................................................................................51
18.2.1��������ѯ��� .......................................................................................................................................................51
18.2.2������ .......................................................................................................................................................................52
18.3���Ż����ݿ�ṹ ..................................................................................................................................................................52
18.3.1�����ֶκܶ�ı��ֽ�ɶ���� ............................................................................................................................52
18.3.2�������� ...........................................................................................................................................................52
18.3.3�����������ֶ� .......................................................................................................................................................52
18.3.4���Ż��I���¼���ٶ� ............................................................................................................................................52
18.3.5�������������Ż��� ............................................................................................................................................53
18.4���Ż� MySQL ������ ..........................................................................................................................................................53
18.4.1���Ż�������Ӳ�� ...................................................................................................................................................53
18.4.2���Ż� MySQL ���� ................................................................................................................................................5
�οͣ������Ҫ�鿴���������������ظ�
来源：论坛采集