How to add a Default value for a specific column or field value

Here I have to create a table with id as auto increment and remaining fileds ike name,adddress,phone number,city,country,cost.code and also Status....


Initially I want to create a table with Auto incremented ID as Primary key and Status filed with Default values like No
for all Iterations..

Can you please provide the Query

and when we click on SUbmit button it should store all in single table How?????

 

I would suggest that you use software like phpmyadmin, which gives you visual db/field creation with many of the options (including the ones you mentioned). It will then show you the SQL it used, it is a good way to learn how to construct SQL queries:

http://www.phpmyadmin.net/home_page/downloads.php
http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html

 

Hello Sir,,, I am not clear
Create Table: CREATE TABLE t (
id INT(11) default NULL auto_increment,

s char(60) default NULL,/* Here I dont want to use Default value as NULL I want to get All column filed values as "NO".

PRIMARY KEY (id)
)

 

Ans: s char(60) default NOT NULL DEFAULT 'No',

 

Hello Thanks for your reply Dude.....
My question... My database is structures as shown in the below figure.

Check the Image clearly or else You won't understand Plzzzzzz

For clear information
FIrst I create label and then Text Box and also a button.
Whenever I Entered the PRimary Key ID in the text box and Whenever I clcik on Button It should change its status to YES.

and also How to retrieve the Staus WHenever I Type the Primary KEY ID ..

I create the table using AUTOIncrement and also I set the Status Filed value as default NO.

My 2 Doubts... are
1.how to update the Status filed status to YES
FIrst I create label and then Text Box and also a button.
Whenever I Entered the PRimary Key ID in the text box and Whenever I clcik on Button It should change its status to YES.

ID 12
button
Whenever I click on Button Staus should set status filed value to Yes for the Primary KEY ID.It is public not restricted.



2.How to display the staus whenever I Type on the Primary KEY ID

Same to Same.

FIrst I create label and then Text Box and also a button.
Whenever I Entered the PRimary Key ID in the text box and Whenever I click on Button It should display status

ID 12
button
It should display staus as YES or NO ..How Plzz Help m...e