Re: Kode kartaisl neivykdoma tokia uzklausa (html) [Jornada Del Muerto @ 2010-11-23 12:41:29]

Tema: Re: Kode kartaisl neivykdoma tokia uzklausa (html)
Autorius: Jornada Del Muerto
Data: 2010-11-23 12:41:29
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1257" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18975">
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT size=2 face=Arial>&nbsp;&nbsp;&nbsp; Tiesos yra, bet tik dalinai 
sutinku, tai labai teisinga vien su MySQL dirbant, o jeigu tenka su ivairiomis 
DBVS tai tai laikyciau blogu iprociu, nes kitur kur tokia sintakse neveiks 
galima is iprocio parasyti ja... nzn bent skaitau, kad svarbu laikytis 
universalumo, o del rasymo tvarkos tai viens geriausiu bent man budu yra 
toks:</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=2 face=Fixedsys>Insert Into Table (</FONT></DIV>
<DIV><FONT face=Fixedsys><FONT size=2>&nbsp;&nbsp;&nbsp; Value1, 
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
Value2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Value3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT><FONT size=2><FONT 
size=2>Value4,</FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2><FONT face=Fixedsys>&nbsp;&nbsp;&nbsp; Value5, 
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; Value6,&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; Value7,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Value8</FONT></DIV>
<DIV>
<DIV>
<DIV><FONT size=2 face=Fixedsys>&nbsp;&nbsp;&nbsp; Value9, &nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; 
Value10,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Value11,&nbsp;&nbsp;&nbsp; 
Value12</FONT></DIV>
<DIV><FONT face=Fixedsys>) Values (</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><FONT size=2 face=Arial>
<DIV><FONT face=Fixedsys><FONT size=2>&nbsp;&nbsp;&nbsp; 
'$Value1',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'$Value2',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'$Value3',&nbsp;&nbsp;'$</FONT><FONT 
size=2><FONT size=2>Value4',</FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT size=2><FONT face=Fixedsys>&nbsp;&nbsp;&nbsp; 
'$Value5',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'$Value6',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'$Value7',&nbsp;&nbsp;'$Value8',</FONT></DIV>
<DIV>
<DIV><FONT size=2 face=Fixedsys>&nbsp;&nbsp;&nbsp; 
'$Value9',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'$Value10',&nbsp;&nbsp;&nbsp;&nbsp;'$Value11',&nbsp;'$Value12'</FONT></DIV>
<DIV></FONT></FONT><FONT face=Fixedsys>)</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>Kur islyginimas vyksta graziai tabais ir lengva suprasti kas ir kur ir 
kazka pataisyti ar dadeti, bent MSSQL T-SQL procedurose naudoju visada sita 
varianta, manau php ir MySQL ne sunkiai pritaikyti galima.</DIV>
<DIV>&nbsp;&nbsp;&nbsp; </FONT></DIV></DIV></DIV>
<DIV><FONT size=2 face=Arial>"gopas" &lt;</FONT><A 
href="mailto:netikras@jamailas.lt"><FONT size=2 
face=Arial>netikras@jamailas.lt</FONT></A><FONT size=2 face=Arial>&gt; wrote in 
message </FONT><A href="news:ibkgnc$6me$1@trimpas.omnitel.net"><FONT size=2 
face=Arial>news:ibkgnc$6me$1@trimpas.omnitel.net</FONT></A><FONT size=2 
face=Arial>...</FONT></DIV><FONT size=2 face=Arial>&gt; siaip tai tik tokias 
inserto funkcijas ir reiktu daryt, priesingu atveju <BR>&gt; pridejus papildoma 
stulpeli<BR>&gt; visos kitos uzklausos susi-fuck'upins. sita ne.<BR>&gt; 
<BR>&gt; "Jornada Del Muerto" &lt;</FONT><A 
href="mailto:agiraTrintI@gmx.co.uk"><FONT size=2 
face=Arial>agiraTrintI@gmx.co.uk</FONT></A><FONT size=2 face=Arial>&gt; wrote in 
message <BR>&gt; </FONT><A href="news:i94a5u$a1$1@trimpas.omnitel.net"><FONT 
size=2 face=Arial>news:i94a5u$a1$1@trimpas.omnitel.net</FONT></A><FONT size=2 
face=Arial>...<BR>&gt;&gt; Pasiziurek jo duota uzklausa:<BR>&gt;&gt;<BR>&gt;&gt; 
insert into prekes set kodas='300003',<BR>&gt;&gt; 
savikaina='2463.703',<BR>&gt;&gt; kiekis='1',<BR>&gt;&gt; 
filialo_id='1'<BR>&gt;&gt;<BR>&gt;&gt; Cia normalus insertas ? <BR>&gt; 
<BR>&gt;</FONT></BODY></HTML>