How to copy a Postgresql varchar column to an integer column
I have a pos开发者_如何学编程tgresql table named baseballs
with a column named quantity
of type = varchar and would like to populate the quantity_integer
column with type = integer
How would I write a SQL statement?
update baseballs set quantity_integer = quantity::int;
精彩评论