Results 1 to 24 of 24
Hybrid View
-
8th May 2010 11:47 #1Registered User
Join Date: Nov:2009
Location: Ñîôèÿ
Posts: 29
Select *, max( ÷àñò îò primary key ) from... êàê?
Ïèøà â php äîëíèÿ ñåëåêò, íî íå ìè âðúùà êàêâîòî î÷àâêàì, à êàòî ãî èçïúëíÿ â phpMyAdmin ðàáîòè êàêòî èñêàì.
SELECT `egid` , `group_name` , `limit` , MAX( `date` ) FROM employee_groups GROUP BY `egid` ORDER BY `egid` DESC ;
CREATE TABLE `employee_groups` (
`egid` int(10) unsigned NOT NULL,
`date` date NOT NULL,
`group_name` varchar(50) NOT NULL,
`limit` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`egid`,`date`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
Òîâà, êîåòî èñêàì äà èçêàðàì å ñïèñúê íà òàçè òàáëèöà, êàòî àêî çà åäíî è ñúùî egid èìà ïîâå÷å äàòè äà âúðíå ñàìî ðåäà ñ ìàêñèìàëíàòàÏîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà
-
8th May 2010 15:09 #2
Ùîì â phpMyAdmin òè âðúùà òîâà, êîåòî òè òðÿáâà, çíà÷è ãðåøêàòà òè å íÿêúäå â ÐÍÐ êîäà, à íå â ñàìàòà çàÿâêà. Òúðñè ïðîáëåìà òàì. Íå ìîæå åäèí è ñúùè ñåëåêò äà âðúùà ðàçëè÷íè íåùà â çàâèñèìîñò îò òîâà äàëè ñè ãî ïóñíàë ïðåç òâîé ñêðèïò èëè ïðåç phpMyAdmin.
Ëþáèìî ïèòèå çàïî÷âàùî ñ áóêâàòà 'Ê'? * Êàñà áèðà *
Àêî ìîæåø äà ëåæèø íà ïîäà áåç äà òè ñå íàëàãà äà ñå äúðæèø - âñå îùå ÍÅ ñè ïèÿí!
Äàâàéòå ñëåäâàùàòà Êàñà...
-
8th May 2010 20:10 #3Registered User
Join Date: Nov:2009
Location: Ñîôèÿ
Posts: 29
Íå å â php êîäà ãðåøêàòà. Òîé ñàìî âèçóàëèçèðà result set-a îò çàÿâêàòà.
Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà
-
8th May 2010 20:35 #4
Äîáðå äàé äà âèäèì ÐÍÐ êîäà, ðåçóëòàòà îò çàÿâêàòà ïóñíàòà ïðåç ÐÍÐ è ðåçóëòàòà îò çàÿâêàòà ïóñíàòà ïðåç phpmyadmin.
Ëþáèìî ïèòèå çàïî÷âàùî ñ áóêâàòà 'Ê'? * Êàñà áèðà *
Àêî ìîæåø äà ëåæèø íà ïîäà áåç äà òè ñå íàëàãà äà ñå äúðæèø - âñå îùå ÍÅ ñè ïèÿí!
Äàâàéòå ñëåäâàùàòà Êàñà...
-
8th May 2010 20:38 #5
Êàêâà å ðàçëèêàòà ìåæäó òîâà, êîåòî òè âðúùà èçðàçúò â PHP è òîâà, êîåòî â phpMyAdmin?
Èëè ïî äðóã íà÷èí äà çàäàì âúïðîñà - êàêâî î÷àêâàø äà òè âúðíå è êàêâî âñúùíîñò òè ñå âðúùà â PHP?(ìàëêî å áåçñìèñëåí, íî ìîæå èäà ñå íàëàãà äà áúäå çàäàäåí òàêà)
P.S. ×øø, òè íàëè áåøå îôëàéí áðå, vb
Àç çàòîâà ñå íàïúíàõ äà íèùÿ
EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|Êèëî è ïîëîâèíà âîäà
Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|Áåç èñòèíñêî âîäíî
-
9th May 2010 12:28 #6Registered User
Join Date: Nov:2009
Location: Ñîôèÿ
Posts: 29
ßâíî â stackoverflow ñà ïî-íà òè ñ SQL-à
åòî ñåëåêòà êîéòî ðàáîòè:
SELECT di.*
FROM (
SELECT egid, MAX(date) AS date
FROM employee_groups d
GROUP BY egid
) dd
JOIN employee_groups di
ON di.egid = dd.egid AND
di.date = dd.date
ORDER BY `egid` DESC;
À òóê ùå ñëîæà ïîÿñíåíèÿòà çà òîâà êàêâî èñêàõ:

Òîâà ìè å ñïèñúêà. Êàòî ãî ïðîìåíÿ, äîáàâÿì íîâ ðåä â òàáëèöàòà, ñúñ ñúùîòî egid, íîâà äàòà è íîâè äëúæíîñò è ëèìèòè. Èñêàì â ãîðíèÿ ñïèñúê äà ìè èçëèçàò ñàìî àêòóàëíèòå íåùà, ò.å. ñ ïîñëåäíà äàòà.Last edited by kdobrev; 10th May 2010 at 12:09.
Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà
-
9th May 2010 12:43 #7
Òîâà ãî ðàçáðàõ, íå ðàçáðàõ â êàêâî å ðàçëèêàòà ìåæäó PHP èçõîäà è òîçè íà phpMyAdmin, çà åäèí è ñúùè èçðàç(áåç çíà÷åíèå, ÷å íå âúðøè òîâà, êîåòî èñêàø).
P.S. "Ïî-" ñïåöèàëèñòèòå òàì íå òè ëè îáÿñíèõà, ÷å ðåçóëòàòúò îò äâåòå çàÿâêè(òàçè îò ïúðâèÿ ïîñò è òàçè óñëîæíåíàòà) å åäèí è ñúù, ñ ðàçëèêàòà, ÷å ïúðâàòà äàâà åäíà êîëîíà ïîâå÷å, âÿðíî íåíóæíà, íî å íåñðàâíèìî ïî-áúðçà è ïî-íåðåñóðñîåìêà îò äîñòà îïëåòåíèÿ è ñëîæåí äæîéí ñ âëîæåíàòà çàÿâêà?
È äâàìàòà ñ Âëàäî òå ïèòàìå çà íåùî, êîåòî Å ïðîáëåì, à íå òúðñèì ïîä âîëà òåëå, çàùîòî çàÿâêàòà, êîÿòî ñè äàë â ïúðâèÿ ïîñò, ïðàâè òî÷íî òîâà, êîåòî èñêàø.
Ìîãà äà ïðèëîæà è ñêðèéíøîò, ÷å ðåçóëòàòèòå íà äâåòå çàÿâêè ñà åäíàêâî èçïîëçâàåìè è èäåíòè÷íè êàòî ðåçóëòàò çà öåëèòå òè.Last edited by Bombera; 9th May 2010 at 13:43.
EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|Êèëî è ïîëîâèíà âîäà
Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|Áåç èñòèíñêî âîäíî
-
10th May 2010 11:41 #8Registered User
Join Date: Nov:2009
Location: Ñîôèÿ
Posts: 29
Code:SELECT * FROM `employee_groups` ORDER BY `employee_groups`.`egid` DESC LIMIT 0 , 30

Code:SELECT `egid` , `group_name` , `limit` , MAX( `date` ) as date FROM `employee_groups` GROUP BY `egid` ORDER BY `egid` DESC ;

Code:SELECT di.* FROM ( SELECT egid, MAX(date) AS date FROM employee_groups d GROUP BY egid ) dd JOIN employee_groups di ON di.egid = dd.egid AND di.date = dd.date ORDER BY `egid` DESC;

Ïðîìåíèõ çà egid 181 äà å 9999, äîêàòî ïðàâåõ ñíèìêèòå, òàêà ÷å òàçè ðàçëèêà ÿ èãíîðèðàéòå.Last edited by kdobrev; 10th May 2010 at 11:49.
Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà
-
10th May 2010 12:18 #9
Çàòîâà òè êàçâàìå, äàé äà âèäèì ÏÕÏ-òî, çàùîòî çàÿâêèòå ïðàâÿò åäíî è ñúùî. Ïðîáëåìúò å âåðîÿòíî, çàùîòî ïîëåòàòà ñå äîñòúïâàò ïî èíäåêñè, âìåñòî ñ îáåêò èëè àñîöèàòèâåí ìàñèâ.
EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|Êèëî è ïîëîâèíà âîäà
Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|Áåç èñòèíñêî âîäíî
-
10th May 2010 13:45 #10Registered User
Join Date: Nov:2009
Location: Ñîôèÿ
Posts: 29
Åòî ëèíê äî òåìàòà â stackoverflow.Code:while ($row = mysql_fetch_assoc($result1)) { echo " <tr > <td>".$row['group_name']."</td> <td class=\"small_cen\">".$row['limit']."</td> </tr>"; }Last edited by kdobrev; 10th May 2010 at 13:52.
Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà
-
10th May 2010 14:13 #11
Ïðè ìåí âñè÷êî ðàáîòè.
Âñå îùå íå ñå âèæäà ðåäúò ñúñ çàÿâêàòà êúì áàçàòà, äàé âñè÷êîòî.EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|Êèëî è ïîëîâèíà âîäà
Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|Áåç èñòèíñêî âîäíî
-
10th May 2010 14:18 #12Registered User
Join Date: Nov:2009
Location: Ñîôèÿ
Posts: 29
Code:function display_table_employee_groups() { #$sql = "SELECT `egid` , `group_name` , `limit` , MAX( `date` ) as date FROM `employee_groups` GROUP BY `egid` ORDER BY `egid` DESC ;"; #/* $sql = "SELECT di.* FROM ( SELECT egid, MAX(date) AS date FROM employee_groups d GROUP BY egid ) dd JOIN employee_groups di ON di.egid = dd.egid AND di.date = dd.date ORDER BY `egid` DESC;"; #*/ $result1 = mysql_query($sql) or die(mysql_error()); ?> <table><tbody> <tr> <th>Äëúæíîñò </th> <th>Ëèìèò </th> <th>Âàëóòà </th> <th>Ïðîìÿíà </th> </tr> <?php $ik = 0; while ($row = mysql_fetch_assoc($result1)) { if ( (($ik++)%2) ) $style = "alt_row_1"; else $style = "alt_row_2"; echo "<!--<pre>"; print_r($row); echo "</pre>-->"; echo " <tr class=\"$style\" onMouseover=\"this.className='alt_row_mo'\" onMouseout=\"this.className='$style'\" > <td>".$row['group_name']."</td> <td class=\"small_cen\">".$row['limit']."</td> <td class=\"small_cen\">ëâ.</td> <td class=\"small_cen\"> <a href=\"ajax.php?sesid=".session_id()."&action=update&egid=$row[egid]\" rel=\"ibox\" title=\"Ïðîìÿíà íà äëúæíîñò\"><img src=\"images/page_white_edit.png\" class=\"icon_img\" alt=\"Ïðîìåíè\" title=\"Ïðîìåíè\"></a> </td> </tr>"; } echo "</tbody></table>"; while ($row = mysql_fetch_assoc($result1)) { echo "<pre>"; print_r($row); echo "</pre>"; } }Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà
-
10th May 2010 14:42 #13
È òîâà ðàáîòè ïðè ìåí. Äàé äà âèäèì êàêúâ å èçõîäúò îò print_r:
Òåçè îáëàñòè:
Îòíÿêúäå ãè âàäè òèÿ íóëè, íå å îò íèùîòî.Code:<!--<pre>Array ( [egid] => 183 [date] => 2010-05-10 [group_name] => Èçï. äèðåêòîð [limit] => 10000 ) </pre>-->EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|Êèëî è ïîëîâèíà âîäà
Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|Áåç èñòèíñêî âîäíî
-
10th May 2010 15:03 #14Registered User
Join Date: Nov:2009
Location: Ñîôèÿ
Posts: 29
Íå ðàçáðàõ êàêâî ïîèñêà, íî òîâà ìè å html-a, êàêòî å ñåãà êîìåíòèðàí print_r-a
MySQL: 5.0.51a-24+lenny2-logCode:<table><tbody> <tr> <th>Äëúæíîñò </th> <th>Ëèìèò </th> <th>Âàëóòà </th> <th>Ïðîìÿíà </th> </tr> <!--<pre>Array ( [egid] => 183 [group_name] => èçï. äèðåêòîð [limit] => 0 [date] => 2010-05-01 ) </pre>--> <tr class="alt_row_2" onMouseover="this.className='alt_row_mo'" onMouseout="this.className='alt_row_2'" > <td>èçï. äèðåêòîð</td> <td class="small_cen">0</td> <td class="small_cen">ëâ.</td> <td class="small_cen"> <a href="ajax.php?sesid=b39063ea2a84a37fc7f4c6cfc8c4fcd2&action=update&egid=183" rel="ibox" title="Ïðîìÿíà íà äëúæíîñò"><img src="images/page_white_edit.png" class="icon_img" alt="Ïðîìåíè" title="Ïðîìåíè"></a> </td> </tr><!--<pre>Array ( [egid] => 181 [group_name] => ñúâåò íà äèðåêòîðèòå [limit] => 0 [date] => 2010-05-01 ) </pre>--> <tr class="alt_row_1" onMouseover="this.className='alt_row_mo'" onMouseout="this.className='alt_row_1'" > <td>ñúâåò íà äèðåêòîðèòå</td> <td class="small_cen">0</td> <td class="small_cen">ëâ.</td> <td class="small_cen"> <a href="ajax.php?sesid=b39063ea2a84a37fc7f4c6cfc8c4fcd2&action=update&egid=181" rel="ibox" title="Ïðîìÿíà íà äëúæíîñò"><img src="images/page_white_edit.png" class="icon_img" alt="Ïðîìåíè" title="Ïðîìåíè"></a> </td> </tr>
PS: Òè êàòî ãëåäàì ïóñêàø "âÿðíî ðàáîòåùèÿ" ñåëåêò, çàùîòî ñà òè ðàçìåñòåíè ïðîìåíëèâèòå â ìàñèâà. Âèæ, ÷å â php-to, êîåòî ñúì ïóñíàë èìà äâà ñåëåêòà è åäèíèÿ å êîìåíòèðàí.  òîâà ïðèìåðíîòî, êîåòî ñúì ïóñíàë å îñòàâåí "âÿðíî ðàáîòåùèÿ"Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà
-
10th May 2010 15:15 #15
Ïðîáâàõ è ñúñ ñîáñòâåí èçðàç, êàêòî è ñ òâîèòå äâàòà
Äàæå è äàííèòå òè êîïèðàõ, çà äà íÿìà ìÿñòî çà ðàçìèíàâêè.
ßâíî ïðè òåá ïîðàäè íÿêàêâà íàñòðîéêà íà ÏÕÏ ïðåäïîëàãàì, èëè íÿêàêúâ ñúâìåñòèì ðåæèì íà ñúðâúðà, íå òè âðúùà ïðàâèëíî limit, îò çàÿâêàòà. Íÿìàì èäåÿ çàùî îáà÷å.
5.0.67-community-nt
ß ïðåèìåíóâàé êîëîíàòà limit, ÷å òîâà å ñëóæåáíà äóìà, äà íå ñå îìàöâà òàì íåùî.
Ñ åäèí è ñúùè þçúð ëè ñå àâòåíòèöèðàø è ïðåç phpMyAdmin, è ïðåç ñêðèïòà?Last edited by Bombera; 10th May 2010 at 15:22.
EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|Êèëî è ïîëîâèíà âîäà
Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|Áåç èñòèíñêî âîäíî
-
10th May 2010 15:20 #16Registered User
Join Date: Nov:2009
Location: Ñîôèÿ
Posts: 29
******** ******* mysql

limit êàòî å â êàâè÷êè íå áè òðÿáâàëî, èíà÷å äàâà ñèíòàêòè÷íà ãðåøêà, à ïîòðåáèòåëèòå ñà ðàçëè÷íè, íî íå ñúì ñè èãðàë ÷àê òîëêîâà ñ ïðàâàòà, èëè îñâåí çà ñúçäàâàíå íà âðåìåííè òàáëèöè äà íÿìà òîÿ, õìì, ùå ïðîáâàìLast edited by kdobrev; 10th May 2010 at 15:40.
Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà
-
10th May 2010 15:36 #17
***** **** àìà íå mysql
.
ßâíî íÿêîé ãî å ïðèìúðçÿëî äà ñå ïîçàïîçíàå ñ îñîáåíîñòèòå íà mysql èëè êîìáèíàöèÿòà ñ PHP. Òîâà âàæè êàêâàòî è áàçà äà ïîäõâàíåø. Ñëåä âèäà íà ïðîáëåìà, êîéòî ñå îáñúæäà òóêà, ñå ÷óäÿ êàê ëè áè ðåàãèðàë àêî ñå çàõâàíåø ñ MS SQL, Îðàêúë èëè äðóãà ïî-ñåðèîçíà
.
-
10th May 2010 15:48 #18Registered User
Join Date: Nov:2009
Location: Ñîôèÿ
Posts: 29
ßâíî íå å îò óñåðà:

@tedych Íå ìèñëè, ÷å ñå îïèòâàì äà çàêëåéìÿ mysql-a, äîðè ìíîãî ãî õàðåñâàì. Ðàáîòèë ñúì ñ "ïî-ñåðèçíè" è ñúì ðåàãèðàë ïî ñúùèÿ íà÷èí íà òåõíèòå "îñîáåíîñòè" èëè "features"
Last edited by kdobrev; 10th May 2010 at 16:02.
Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà
-
10th May 2010 16:10 #19
À êàêúâ â êðàéíà ñìåòêà å ïîñëåäíèÿ ïðîáëåì, ÷å íåùî îáúðêàíà ñòàíà òåìàòà?

PHPmyadmin êàêòî çíàåø å PHP ïðèëîæåíèå, è àêî îñòàíàëèòå ôàêòîðè ñà åëèìèíèðàíè (åäèí è ñúùè óçåð, åäíî è ñúùî PHP è ò.í.) ,íÿêúäå ÿâíî èìàø íÿêîÿ çàáèòà ãðåøêà èëè íÿêîÿ êîÿòî âåðîÿòíî íÿìà íèùî îáùî ñ òîâà, êîåòî ñå îáñúæäà òóê.
-
10th May 2010 17:24 #20Registered User
Join Date: Nov:2009
Location: Ñîôèÿ
Posts: 29
Íåçíàì, àêî îòêðèÿ, ùå ãî íàïèøà.
Ïîäïèñúò âè å ðåäàêòèðàí â ñúîòâåòñòâèå ñ ïðàâèëàòà íà ôîðóìà
-
10th May 2010 19:22 #21Registered User
Join Date: Feb:2006
Location: Plovdiv
Posts: 392
When using this feature, all rows in each group should have the same values for the columns that are ommitted from the GROUP BY part. The server is free to return any value from the group, so the results are indeterminate unless all values are the same.
Ï.Ï. íîðìàëåí SQL íå ïîçâîëÿâà òàêèâà çàÿâêè, ðåçóëòàòà å íåäåôèíèðàí.
-
10th May 2010 20:42 #22
Îùå ïîâå÷å ïîäîáíè íåïúëíè ãðóïèðàíèÿ íå âúðâÿò ïðèìåðíî â SQL Server (2005)
.
È íàèñòèíà îáèêíîâåíî ñå ïðàâè ñ âëîæåí ñåëåêò çà äà íÿìàìå 'ñëó÷àéíè' ñòîéíîñòè çà ïîëåòàòà, çà êîèòî èñêàìå ñòîéíîñòè, îòãîâàðÿùè íà ìà÷íàòèòå îò àãðåãàòíèòå ô-èè ðåäîâå.
-
14th May 2010 10:18 #23Registered User
Join Date: Jul:2005
Location: Sofiq
Posts: 2,798
Ïðîáëåìà å, ÷å mysql çà ïîëåòàòà êîéòî íå ñà â ãðóïàòà âðúùà êàêâîòî ìó ïàäíå. Àêî èñêàø äà èçâàäèø âåðíè ñòîéíîñòè íàïðàâè JOIN îùå âåäíúæ íà òàáëèöàòà ïî ñúîòâåòíèÿ êëþ÷ è îò íåÿ èçâàäè îñòàíàëèòå ñòîéíîñòè îò ðåäà êîéòî òå èíòåðåñóâà. Íå ñúì ãî ïðîáâàë, íî ìîæå è äà ðàáîòè. Àç ïî ïðèíöèï ñè ãî ïðàâÿ ñ îùå åäíà çàÿâêà.
Code:SELECT eg.`egid` , MAX(eg.`date` ), eg_row.`group_name` , eg_row.`limit` FROM employee_groups eg INNER JOIN employee_groups eg_row ON(eg_row.egid = eg.egid AND eg_row.`date` = eg.`date`) GROUP BY eg.`egid` ORDER BY eg.`egid` DESC;
Last edited by _ShadoW_; 14th May 2010 at 10:23.
-
14th May 2010 11:05 #24
_ShadoW_, îò òàçè çàÿâêà íå âèæäàì îñîáåí ñìèñúë, âúïðåêè ÷å "ðàáîòè" è âðúùà ïðîñòî çàïèñèòå îò òàáëèöàòà.
Ïðîáëåìúò áåøå êîãàòî èìàìå äâå òàáëèöè è çà äàäåí çàïèñ îò ïúðâàòà òúðñèì ñúîòâåòåí îò âòîðàòà, íî òî÷íî òîçè îò âòîðàòà, çà êîéòî äàäåí field èìà ìàêñ. ñòîéíîñò, è èñêàìå è äðóãè ôèåëäè îò òîçè "âòîðè" ðåä. È äà äæîéíâàø ïî ñúùàòà òàáëèöà, ìàé íå ñòàâà, âñå ñè âðúùà "ñëó÷àéíè" ñòîéíîñòè çà äðóãèòå ïîëåòà. Íå ÷å ñúì ñïåö, íî ñúì ïðîáâàë íåìàëêî êîìáèíàöèè è â êðàéíà ñìåòêà ñ âëîæåí ñåëåêò ñòàâà, âêë. â MS SQL, êúäåòî ïúê íå ïðèåìà íåïúëåí GROUP, à å äîáðå sql-èòå äà ìîãàò ëåñíî äà ðàáîòÿò è â äðóãè dbms.Last edited by tedych; 14th May 2010 at 13:12.




Reply With Quote

Lenovo ThinkPad 15 èëè IdeaPad 15
5th May 2023, 22:16 in Ìîáèëíè êîìïþòðè