RE: [PHP] Default values in MySQL
| From: | Don Read | Date: | Tue, 08 May 2001 22:18:59 +0000 |
| Subject: | RE: [PHP] Default values in MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-51993@lists.php.net to get a copy of this message | ||
On 08-May-01 Joseph Bannon wrote:
> How do you set Default values in mysql?
>
CREATE TABLE webmaster (
wmid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
pcode char(1) DEFAULT 'S' NOT NULL,
grade char(1) DEFAULT 'C' NOT NULL,
name varchar(80) DEFAULT '' NOT NULL,
contact varchar(80) DEFAULT '' NOT NULL,
addr1 varchar(80) DEFAULT '' NOT NULL,
addr2 varchar(80),
city varchar(80) DEFAULT '' NOT NULL,
...
Not that it has anything to do with PHP.
http://www.mysql.com/manual.php
http://lists.mysql.com/
Regards,
--
Don Read dread@texas.net
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.