· 9 years ago · Nov 20, 2016, 05:28 PM
1*-- Struttura della tabella `confmiele`
2--
3CREATE TABLE IF NOT EXISTS `confmiele` (
4 `idconf` int(11) NOT NULL,
5 `dataconfmiele` date NOT NULL,
6 `codconfmiele` varchar(10) NOT NULL,
7 `nomeconfmiele` varchar(20) NOT NULL,
8 `boxconfmiele` varchar(20) NOT NULL,
9 `pesoconfmiele` int(7) NOT NULL,
10 `numconfmiele` int(7) NOT NULL,
11 `totconfmiele` int(7) NOT NULL,
12 `noteconfmiele` varchar(300) NOT NULL
13) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
14--
15-- Dump dei dati per la tabella `confmiele`
16--
17INSERT INTO `confmiele` (`idconf`, `dataconfmiele`, `codconfmiele`, `nomeconfmiele`, `boxconfmiele`, `pesoconfmiele`, `numconfmiele`, `totconfmiele`, `noteconfmiele`) VALUES
18(2, '2015-09-02', 'GPO15SET', 'GIPPOMIELE', 'VASO VETRO 1000', 1000, 1, 1000, ''),
19(4, '2015-09-02', 'GPO15SET', 'GIPPOMIELE', 'VASO VETRO 1000', 1000, 1, 1000, ''),
20(5, '2015-09-02', 'GP15SET', 'GIPPOMIELE', 'VASO VETRO 1000', 1000, 10, 10000, ''),
21(6, '2015-09-03', 'GP15SET', 'GIPPOMIELE', 'VASO VETRO 1000', 1000, 1, 1000, ''),
22(7, '2015-10-07', 'GP15SET', 'GIPPOMIELE', 'VASO VETRO 1000', 1000, 10, 10000, ''),
23(8, '2015-10-07', 'GP15SET', 'GIPPOMIELE', 'VASO VETRO 1000', 1000, 10, 10000, ''),
24(9, '2015-10-08', 'GP15SET', 'GIPPOMIELE', 'VASO VETRO 1000', 1000, 1, 1000, ''),
25(10, '2015-10-08', 'GP15SET', 'GIPPOMIELE', 'VASO VETRO 1000', 1000, 1, 1000, ''),
26(11, '2015-10-08', 'GP15SET', 'GIPPOMIELE', 'VASO VETRO 1000', 1000, 1, 1000, ''),
27(12, '2015-10-08', 'GP15SET', 'GIPPOMIELE', 'VASO VETRO 1000', 1000, 1, 1000, ''),
28(13, '2015-10-08', 'GP15SET', 'GIPPOMIELE', 'VASO VETRO 1000', 1000, 1, 1000, ''),
29(14, '2015-10-08', 'GP15SET', 'GIPPOMIELE', 'VASO VETRO 1000', 1000, 1, 1000, '');
30--
31-- Indici per le tabelle scaricate
32--
33--
34-- Indici per le tabelle `confmiele`
35--
36ALTER TABLE `confmiele`
37 ADD PRIMARY KEY (`idconf`);
38--
39-- AUTO_INCREMENT per le tabelle scaricate
40--
41--
42-- AUTO_INCREMENT per la tabella `confmiele`
43--
44ALTER TABLE `confmiele`
45 MODIFY `idconf` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
46/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
47/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
48/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;*
49
50*SELECT SUM(numconfmiele) FROM confmiele WHERE codconfmiele = 'GP15SET' AND boxconfmiele = 'VASO VETRO 1000'*
51
52--
53-- Struttura della tabella `dettconffattmiele`
54--
55
56CREATE TABLE IF NOT EXISTS `dettconffattmiele` (
57 `iddettconffatt` int(11) NOT NULL,
58 `dataconffattmiele` date NOT NULL,
59 `idfatt` int(11) NOT NULL,
60 `codconffattmiele` varchar(10) NOT NULL,
61 `nomeconffattmiele` varchar(20) NOT NULL,
62 `boxfattmiele` varchar(20) NOT NULL,
63 `numconffattmiele` int(7) NOT NULL,
64 `totpesoconffattmiele` int(7) NOT NULL,
65 `uniteurofattmiele` decimal(7,2) NOT NULL,
66 `eurofattmiele` decimal(7,2) NOT NULL
67) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
68
69--
70-- Dump dei dati per la tabella `dettconffattmiele`
71--
72
73INSERT INTO `dettconffattmiele` (`iddettconffatt`, `dataconffattmiele`, `idfatt`, `codconffattmiele`, `nomeconffattmiele`, `boxfattmiele`, `numconffattmiele`, `totpesoconffattmiele`, `uniteurofattmiele`, `eurofattmiele`) VALUES
74(1, '2015-09-02', 10, ' GP15SET', ' GIPPOMIELE', 'VASO VETRO 1000', 5, 5000, '10.00', '50.00'),
75(2, '2015-09-02', 11, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 5, 5000, '10.00', '50.00'),
76(3, '2015-09-02', 12, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 5, 5000, '10.00', '50.00'),
77(6, '2015-09-03', 19, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
78(7, '2015-09-03', 20, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
79(8, '2015-09-03', 21, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
80(9, '2015-09-03', 22, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
81(10, '2015-09-03', 23, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
82(11, '2015-09-03', 24, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
83(12, '2015-09-03', 25, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
84(13, '2015-09-03', 26, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
85(14, '2015-09-03', 27, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
86(15, '2015-09-03', 28, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
87(16, '2015-09-03', 29, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
88(17, '2015-09-03', 30, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
89(18, '2015-09-03', 31, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
90(19, '2015-09-03', 32, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
91(20, '2015-09-03', 33, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
92(21, '2015-09-03', 34, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
93(22, '2015-09-03', 35, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00'),
94(23, '2015-09-03', 36, ' GP15SET', ' GIPPOMIELE', ' VASO VETRO 1000', 1, 1000, '1.00', '1.00');
95
96--
97-- Indici per le tabelle scaricate
98--
99
100--
101-- Indici per le tabelle `dettconffattmiele`
102--
103ALTER TABLE `dettconffattmiele`
104 ADD PRIMARY KEY (`iddettconffatt`);
105
106--
107-- AUTO_INCREMENT per le tabelle scaricate
108--
109
110--
111-- AUTO_INCREMENT per la tabella `dettconffattmiele`
112--
113ALTER TABLE `dettconffattmiele`
114 MODIFY `iddettconffatt` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=24;
115/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
116/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
117/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
118
119SELECT SUM(numconffattmiele) FROM dettconffattmiele WHERE codconffattmiele = 'GP15SET' AND boxfattmiele = 'VASO VETRO 1000'
120
121'VASO VETRO 1000',
122
123' VASO VETRO 1000',
124
125SELECT SUM(numconffattmiele)
126FROM dettconffattmiele
127WHERE TRIM(codconffattmiele) = 'GP15SET'
128 AND TRIM(boxfattmiele) = 'VASO VETRO 1000';
129
130value=' $cod16conffattmiele'
131-------^-------------------- extra space there