Thread: php
View Single Post
  #4  
Old 04-04-2003, 11:28 AM
Bigpull
Discordant
 
Join Date: Feb 2003
Posts: 305
Default

alter table items add Name varchar(64) default 'Invalid Name';
update items set Name=substring(raw_data, 1,64) where id=id;
Reply With Quote