" /> Wagwoord <br /><input type="password" name="passwd" id="passwd" class="inputbox" size="18" alt="password" />
PDF Let wel


Синтаксис SQL

SELECT column_name(s)
FROM table_name
WHERE column_name operator value

Пример

Есть таблица "Persone":

P_IdLanguageNoemnaamAddressStad
1 Hansen Ola Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Kari Storgt 20 Stavanger

1
2
SELECT * FROM Persone
WHERE Stad=

P_IdLanguageNoemnaamAddressStad
1 Hansen Ola Sandnes
2 Svendson Tove Borgvn 23 Sandnes

1
2
SELECT * FROM Persone WHERE Noemnaam= // 
SELECT * FROM Persone WHERE Noemnaam=Tove // 

1
2
SELECT * FROM Persone WHERE Year=1965 // 
SELECT * FROM Persone WHERE Year='1965' // 

Допустимые операторы при использовании

=
>
<
<=
IN

!=

 
-1 #1 javadov 2010-12-06 18:34

 
 
-6 #2 javadov 2010-12-06 18:35


*

1
 
 
+1 #3 yangus 2011-02-08 12:29


*

1



 
 
+1 #4 Wd45 2012-04-02 23:07


 

Magtiging

Nice Ajax Poll

Statistiek

Adverteer