> Hi,
> Can someone tell me how do stote date field in MySQL DB ?
This is the dump from my phpMyAdmin: use this SQL from the command 
line and adapt it for your own needs:

# Table structure for table 'item'
#

CREATE TABLE item (
   id smallint(4) DEFAULT '0' NOT NULL auto_increment,
   name varchar(25) NOT NULL,
   dept varchar(25) NOT NULL,
   abstract mediumblob NOT NULL,
   submitDate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, // The 
//bit you need
   scale varchar(7) NOT NULL,
   PRIMARY KEY (id),
   UNIQUE id (id)
);

HTH !!
Russ

On Wed, 20 Jun 2001 18:27:42 +0300 Rosen <[EMAIL PROTECTED]> wrote:

> Hi,
> Can someone tell me how do stote date field in MySQL DB ?
> 
> Thanks,
> Rosen M.
> 
> 
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 

#-------------------------------------------------------#
                                
  "Believe nothing - consider everything"       
  
  Russ Michell
  Anglia Polytechnic University Webteam
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam
  t: +44 (0)1223 363271 x 2331

  www.theruss.com
                        
#-------------------------------------------------------#


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to