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 [EMAIL PROTECTED]
-- 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.
--
PHP General 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]
