Обсуждение: new calculated column
Hi; I've got a table with two fields and about 3000 rows, the second one is a character field, what can have about twenty different values; of course these values are repeated a lot of times in the table. I need to create a new column of type integer, whose value depens on the character fields. The values of the new column are not important, the important thing is who can I create this column and assign a different integer to a different char value in the other column. Thanks -------------- Javier -------------------------------------------------------
HI. simple (tedious) solution would be do fire 20 sqls. update tabel set f1=<some int 1> where f2='some varchar1'; update tabel set f1=<some int 2> where f2='some varchar2'; update tabel set f1=<some int 3> where f2='some varchar3'; incase there is some the integer is a function of varchar u may translate to the corresponding SQL. regds mallah. > Hi; > > I've got a table with two fields and about 3000 rows, the second one is a character field, what > can have about twenty different values; of course these values are repeated a lot of times in > the table. I need to create a new column of type integer, whose value depens on the character > fields. The values of the new column are not important, the important thing is who can I create > this column and assign a different integer to a different char value in the other column. > Thanks > -------------- > Javier > > ------------------------------------------------------- > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' > the postmaster ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/