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

1
2
3

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value

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

P_Id	Language	Noemnaam	Address	Stad
1	Hansen	Ola		Sandnes
2	Svendson	Tove	Borgvn 23	Sandnes
3		Kari	Storgt 20	Stavanger
4				Stavanger
5

Итак, мы хотим обновить столбцы ", " в таблице "Persone"..

1
2
3

 UPDATE Persone
 SET Address=, Stad=
 WHERE Language='' AND Noemnaam=''

P_Id	Language	Noemnaam	Address	Stad
1	Hansen	Ola		Sandnes
2	Svendson	Tove	Borgvn 23	Sandnes
3		Kari	Storgt 20	Stavanger
4				Stavanger
5				Sandnes

Предупреждение SQL

1 2	UPDATE Persone SET Address=, Stad=

То таблица "Persone" будет выглядеть так:

P_Id	Language	Noemnaam	Stad
1	Hansen	Ola	Sandnes
2	Svendson	Tove	Sandnes
3		Kari	Sandnes
4			Sandnes
5			Sandnes

Address
E-pos	ageent.ua @ gmail.com ageent.ru @ gmail.com
Phone	Mobile: +380 54 501 90 28
Websites	Afdruk