Pages 1
You must login or register to post a reply
Warning: count(): Parameter must be an array or an object that implements Countable in
/home/pasokime/domains/mysql.lt/public_html/forumas/include/parser.php on line
820
1 Topic by Avice 2011-08-10 18:20:51 (edited by Avice 2011-08-10 18:23:04)
- Registered: 2010-12-13
- Posts: 182
Topic: Pagalbos del SELECT
Taigi mano uzklausa:
SELECT * FROM `fusionb5aa4_v7_x3_forums` WHERE `forum_id`='(SELECT forum_cat FROM `fusionb5aa4_v7_x3_forums` WHERE forum_cat = 38 )' LIMIT 1
- Grazina tuscia rezultata.
(SELECT forum_cat FROM `fusionb5aa4_v7_x3_forums` WHERE forum_cat = 38 )
grazina "3"
SELECT * FROM `fusionb5aa4_v7_x3_forums` WHERE `forum_id`='3' LIMIT 1
- Grazina gera rezultata.
Kodel neveikia su pirmu variantu
- minde
- Administrator
- Offline
- Registered: 2006-06-14
- Posts: 4,003
Re: Pagalbos del SELECT
Viskas, kad tarp viengubų kabučių yra traktuojama kaip eilutė (string).
- Registered: 2010-12-13
- Posts: 182
Re: Pagalbos del SELECT
Dekui.
Dar viena bedele.
Noriu sujungti 2 lenteles , bet istraukt ne visus laukelius.
Select ... INNER JOIN test on test.a = net.b
ir nelabai suprantu ka reiskia on test.a = net.b
?
Niekur nerandu lt pavizdziu su lt kalba.
.
Tikslas suskaiciuot laukelius is nariu , temos , zinutes lenteliu kiekviena atskirai
- Registered: 2009-02-17
- Posts: 333
Re: Pagalbos del SELECT
Reiškia, kad jungiant lenteles test.a laukas turi būti lygus net.b, t.y. nurodo kurios eilutes turi buti sujungtos su kuriomis
- Registered: 2010-12-13
- Posts: 182
Re: Pagalbos del SELECT
Tai gal maza pavizdi , kad butu aiskiau ?
Lentele:
mux
id cat
...
Kita lentele
dam
id dog
...
Select
COUNT(cat) as cat , COUNT(dog) as dog FROM muw JOIN dam ..?
- Registered: 2011-07-26
- Posts: 107
Re: Pagalbos del SELECT
kaip tu suni su kate sujungsi?
posts
id, user_id, text
users
id nick
select p.id, u.nick, p.text from posts p inner join users u ON p.user_id = u.id;
- Registered: 2010-04-11
- Posts: 236
Re: Pagalbos del SELECT
aivaras37 wrote:<...>
kaip tu suni su kate sujungsi?
<...>
Iškrypėlis..
- Registered: 2009-02-17
- Posts: 333
Re: Pagalbos del SELECT
qutwala wrote:aivaras37 wrote:<...>
kaip tu suni su kate sujungsi?
<...>
Iškrypėlis..
Kad jis ne pirmas butu toki fokusa darydamas http://www.google.lt/search?q=catdog&am … mp;bih=943
- Registered: 2011-07-26
- Posts: 107
Pages 1
You must login or register to post a reply