Skip to main content

Why does update table not update data?

  • May 13, 2016
  • 1 reply
  • 9 views

David_P_1
Forum|alt.badge.img+2

 

 

I want to update 'ca' to 'CA'. 

 

 

dbadmin=> select version();

 Vertica Analytic Database v7.1.2-0

(1 row)

 

 

dbadmin=> update tran_gw

dbadmin-> set merchant_name='CA'

dbadmin-> where merchant_state='ca';

OUTPUT

--------

   1184

(1 row)

 

dbadmin=> commit;

COMMIT

 

dbadmin=> select count(*)

dbadmin-> from tran_gw

dbadmin-> where merchant_state='ca';

count

-------

  1184

(1 row)

 

dbadmin=> select count(*)

dbadmin-> from tran_gw

dbadmin-> where merchant_state='CA';

  count   

----------

53838315

(1 row)

 

 

I update data, but the data does not change?

1 reply

Sharon_Cutter
Forum|alt.badge.img
  • Participating Frequently
  • May 13, 2016

Because you're setting merchant_name to 'CA' instead of merchant_state.

 

  --Sharon