URL: https://linuxfr.org/forums/programmation-php/posts/mysql-requete-in
Title: Mysql requete In
Authors: roule007
Date: 2005年05月18日T11:58:14+02:00
Tags: 
Score: 0
Salut bon juste un petite question, je veux faire une requete du genre select truc from bidule where truc2 IN (select truc2 from bidule2 where...) 
 
Mon pb est que j'ai une erreur et que je ne l'a comprends pas alors voila mon code + erreur mysql : 
 
SELECT nom 
FROM table1 
WHERE prenom = 'TOTO' AND id 
IN ( 
SELECT id 
FROM table2 
WHERE entreid = '13' 
) LIMIT 0, 30 
 
MySQL a répondu: 
#1064 - You have an error in your SQL syntax near 'SELECT id 
FROM table2 
WHERE entreid = '13 ' ) LIMIT 0, 30' at line 5 
 
Merci à tous !
</div><div class="naked_ctrl">
<form action="/index.cgi/contrast" method="get" name="gate">
<p><a href="http://altstyle.alfasado.net">AltStyle</a> によって変換されたページ <a href="httpS://linuxfr.org/forums/programmation-php/posts/mysql-requete-in.md">(-&gt;オリジナル)</a>
/ <label>アドレス: <input type="text" name="naked_post_url" value="httpS://linuxfr.org/forums/programmation-php/posts/mysql-requete-in.md" size="22" /></label> <label>モード: <select name="naked_post_mode">
<option value="default">デフォルト</option>
<option value="speech">音声ブラウザ</option>
<option value="ruby">ルビ付き</option>
<option value="contrast" selected="selected">配色反転</option>
<option value="larger-text">文字拡大</option>
<option value="mobile">モバイル</option>
</select>
<input type="submit" value="表示" />
</p>
</form>
</div>