Forum Moderators: open
CREATE TABLE `tbllinks` (
`CatID` int(11) NOT NULL default '0',
`Date` date NOT NULL default '0000-00-00',
`LinkID` int(11) NOT NULL auto_increment,
`WebAddr` varchar(100) NOT NULL default '',
`LinkText` varchar(50) NOT NULL default '',
`Description` varchar(250) NOT NULL default '',
`PageUrl` longtext NOT NULL,
PRIMARY KEY (`LinkID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
and what I want (if I were creating from scratch) would be this:
CREATE TABLE `tbllinks` (
`CatID` int(11) NOT NULL default '0',
`Date` date NOT NULL default '0000-00-00',
`LinkID` int(11) NOT NULL auto_increment,
`WebAddr` varchar(100) NOT NULL default '',
`LinkText` varchar(50) NOT NULL default '',
`Description` varchar(250) NOT NULL default '',
`PageUrl` longtext NOT NULL,
`contactEmail` varchar(128),
PRIMARY KEY (`LinkID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=82 ;
How do I insert the contactEmail value into the already existing database?
Thanks for your help
Mike
UPDATE tbllinks SET contactEmail = 'email@example.com'
BUT
if you wish to have a different email assigned to the rows, you need to write as many update statements or find a different to do it through loops, and the query will look like this:
UPDATE tbllinks SET contactEmail = 'email@example.com' WHERE CatID = '1'
UPDATE tbllinks SET contactEmail = 'email2@example2.com' WHERE CatID = '2'
. . .
Habtom
alter table tbllinks add column contactEmail varchar (128) ;
Habtom
