Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001062

Re: [PHP-DB] Date field From: Russ Michell (r.j.michell <email protected>)
Date: 06/21/01

> 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 <rosen_dm <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: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>

#-------------------------------------------------------#
                                
  "Believe nothing - consider everything"
  
  Russ Michell
  Anglia Polytechnic University Webteam
  
  e: r.j.michell <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: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>