View Single Post
  #1 (permalink)  
Old March 24th, 2011, 06:46 AM
arbab arbab is offline
Authorized User
Points: 350, Level: 6
Points: 350, Level: 6 Points: 350, Level: 6 Points: 350, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2008
Location: , , Pakistan.
Posts: 54
Thanks: 8
Thanked 1 Time in 1 Post
Default Values are not inserting through 'Default' while creating tables.

The table has been created through the query below

CREATE TABLE customer
(First_Name char(50),
Last_Name char(50),
Address char(50) default 'Unknown',
City char(50) default 'Karachi',
Country char(25),
Birth_Date date)

but the default value is not inserting in their respective column, what's wrong with the query?

Thanks in advance.
__________________
How to do programming?

Last edited by arbab; March 24th, 2011 at 06:50 AM..