Adding Columns With Data SQL

Do you have to add a new column to a table that already exist and fill it with data? . In this scenario we need to include a location that depends on the values from the State Column.
My advice is to do it step by step as shown.

[@hamzaarif6000]

Okay but what if we want to add different values in a new column for each row in a single query???

[@budddmj8191]

yes I would also like to know this.

[@tanzeelamariam4932]

I came here for this comment.

[@kyriakoslatsoynhs5907]

thank you very much . I was able to add collumn very simply tnanks to your help .After i added the new null collumn i typed:
UPDATE POP
set Jazz =(
select Jazz from ARTIST
WHERE PArtistID=ArtistID ) --POP was the initial table , and 'Jazz'' the new collomn and ''ARTIST ' the other table from which i took the collumn 'Jazz '.I hope that is somehow useful as your video to me.Best of wishes

[@PonderP378]

Salamat idol

[@AshishGautam-so4uz]

I want know that.Are we use insert query in a single column such as MySQL.

[@budddmj8191]

this is amazing help thank you

[@aspirecreativitea5959]

Thanks! Big help!😊

[@user-rl5ke2ky6h]

Thank you so much ❤

[@omkarkhode3718]

Thank you buddy 👍🏻

[@Ajju_bhai9777]

Thxx sir good information ❤

[@raveenathakur1176]

Thank You Sir 💞

[@ama_kwame]

Thank you.

[@frankiceal94]

Thank you

[@Balajiji4888]

Thank you sir

[@prasadpadamotham4390]

my sql lo avvvadu separte column lo data add cheydam

[@prmix3683]

Thank you so much ❤