NULL field

[Miss-Ruth]

How can I change Yes to No for the NULL field in the mysql db structure.

 

 

E.g. (Table name: address and Column name : state)

<?php
$link = mysql_connect("localhost","db","pw");
mysql_select_db("db");

mysql_query("alter table address modify state null NO); 
$result = mysql_query($query);
$sent = "Edit Successful.";
echo ($sent);
?>

[Miss-Ruth]

Could someone hemlpme on this please.

 

ALTER TABLE tb1 MODIFY field1 NOT NULL;

[Pikachu2000]

Users should not "bump" topics that are still on the first page of the forums. If you bump' date=' you must provide additional information. If you resort to bumping, chances are your question needs to be re-thought and re-described (see Eric Raymond's "How To Ask Questions The Smart Way").[/quote']

[Miss-Ruth]

I thought you had answered  .

 

Ruth.