Possible to add same data to ALL tables?

[thefreebielife]

Here is my table structure:

 

  `uId` int(6) NOT NULL auto_increment,

  `username` text NOT NULL,

  `password` text NOT NULL,

  `fname` text NOT NULL,

  `phone` text NOT NULL,

  `email` text NOT NULL,

  `address` text NOT NULL,

  `city` text NOT NULL,

  `state` text NOT NULL,

  `zip` text NOT NULL,

  `country` text NOT NULL,

  `ip` text NOT NULL,

  `gid` int(6) NOT NULL default '0',

  `rid` int(6) NOT NULL default '0',

  `ostatus` double NOT NULL default '0',

  `holdreason` text NOT NULL,

  `astatus` tinyint(4) NOT NULL default '0',

  `date` text NOT NULL,

  `deadline` text NOT NULL,

  `dead` tinyint(4) NOT NULL default '0',

  `istatus` tinyint(4) NOT NULL default '0',

  `denyreason` text NOT NULL,

  `rollo` int(6) NOT NULL default '0',

  `site` varchar(10) NOT NULL default 'Cash',

  PRIMARY KEY  (`uId`)

) ENGINE=MyISAM AUTO_INCREMENT=72104 DEFAULT CHARSET=latin1 AUTO_INCREMENT=72104 ;

 

Is it possible to get all the current tables to have "site" as "Cash"?

 

If so, how?

 

Thanks,

Jared

[Illusion]

Is it possible to get all the current tables to have "site" as "Cash"?

what does it mean?

[AndyB]

Or do you really mean how do I get all rows to have the value Cash for the site field ...