Problema con INCREMENTACION
Publicado por Sebastian M. Barrionuevo (3 intervenciones) el 04/03/2011 19:49:18
Gente, estoy haciendo una tabla en la base de datos musica. Tengo una Tabla group_music con una columna Id_GMusical con AUTOINCREMENTACION. El inconveniente que tengo es que cuando hago INSERT, la AUTOINCREMENTACION empieza desde 11 y no desde 1 o 0. Alguien sabe porque?. Acá paso el codigo, Gracias:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
CREATE DATABASE musica;
USE musica;
CREATE TABLE `group_music` (`Id_GMusical` int(11) NOT NULL AUTO_INCREMENT,
`Name_GMusical` varchar(20) NOT NULL,
`Years_Burn` int(11) DEFAULT NULL,
`Genre_Gmusical` varchar(11) DEFAULT NULL,
PRIMARY KEY (`Id_GMusical`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
/*-------------------------------------Angra--------------------------------------*/USE musica;
SET @Name = 'Angra';
SET @Year = 1993;SET @Genre = 'Power Metal';
SET @sql_Name =(SELECT g.Name_GMusical
FROM group_music g
WHERE Name_GMusical = @Name);
INSERT INTO group_music(Name_GMusical, Years_Burn, Genre_GMusical)
VALUES (ltrim(rtrim(@Name)), ltrim(rtrim(@Year)), ltrim(rtrim(@Genre)));
SELECT * FROM group_music;/*-------------------------------------Avantasia----------------------------------------*/USE musica;
SET @Name = 'Avantasia';
SET @Year = 2000;SET @Genre = 'Power Metal';
SET @sql_Name =(SELECT g.Name_GMusical
FROM group_music g
WHERE Name_GMusical = @Name);
INSERT INTO group_music(Name_GMusical, Years_Burn, Genre_GMusical)
VALUES (ltrim(rtrim(@Name)), ltrim(rtrim(@Year)), ltrim(rtrim(@Genre)));
SELECT * FROM group_music;/*-------------------------------------MasterPlan----------------------------------------*/USE musica;
SET @Name = 'Masterplan';
SET @Year = 2003;SET @Genre = 'Power Metal';
SET @sql_Name =(SELECT g.Name_GMusical
FROM group_music g
WHERE Name_GMusical = @Name);
INSERT INTO group_music(Name_GMusical, Years_Burn, Genre_GMusical)
VALUES (ltrim(rtrim(@Name)), ltrim(rtrim(@Year)), ltrim(rtrim(@Genre)));
SELECT * FROM group_music;/*----------------------------Moderatto--------------------------------------*/USE musica;
SET @Name = 'Moderatto';
SET @Year = 2001;SET @Genre = 'Rock';
SET @sql_Name =(SELECT g.Name_GMusical
FROM group_music g
WHERE Name_GMusical = @Name);
INSERT INTO group_music(Name_GMusical, Years_Burn, Genre_GMusical)
VALUES (ltrim(rtrim(@Name)), ltrim(rtrim(@Year)), ltrim(rtrim(@Genre)));
SELECT * FROM group_music;/*-------------------------------------Motley Crue-------------------------------------*/USE musica;
SET @Name = 'Motley Crue';
SET @Year = 1981;SET @Genre = 'Rock';
SET @sql_Name =(SELECT g.Name_GMusical
FROM group_music g
WHERE Name_GMusical = @Name);
INSERT INTO group_music(Name_GMusical, Years_Burn, Genre_GMusical)
VALUES (ltrim(rtrim(@Name)), ltrim(rtrim(@Year)), ltrim(rtrim(@Genre)));
SELECT * FROM group_music;/*-------------------------------------Ugly Kid Joe-------------------------------------*/USE musica;
SET @Name = 'Ugly Kid Joe';
SET @Year = 1991;SET @Genre = 'Rock';
SET @sql_Name =(SELECT g.Name_GMusical
FROM group_music g
WHERE Name_GMusical = @Name);
INSERT INTO group_music(Name_GMusical, Years_Burn, Genre_GMusical)
VALUES (ltrim(rtrim(@Name)), ltrim(rtrim(@Year)), ltrim(rtrim(@Genre)));
SELECT * FROM group_music;/*-------------------------------------Vince Neil-------------------------------------*/USE musica;
SET @Name = 'Vince Neil';
SET @Year = 1993;SET @Genre = 'Rock';
SET @sql_Name =(SELECT g.Name_GMusical
FROM group_music g
WHERE Name_GMusical = @Name);
INSERT INTO group_music(Name_GMusical, Years_Burn, Genre_GMusical)
VALUES (ltrim(rtrim(@Name)), ltrim(rtrim(@Year)), ltrim(rtrim(@Genre)));
SELECT * FROM group_music;Valora esta pregunta
0