Adding Columns With Data SQL
Вставка
- Опубліковано 7 вер 2024
- 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.
Okay but what if we want to add different values in a new column for each row in a single query???
yes I would also like to know this.
I came here for this comment.
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
Salamat idol
I want know that.Are we use insert query in a single column such as MySQL.
this is amazing help thank you
Thanks! Big help!😊
Thank you so much ❤
Thank you buddy 👍🏻
Thxx sir good information ❤
Thank You Sir 💞
Thank you.
Thank you
Thank you sir
my sql lo avvvadu separte column lo data add cheydam
Thank you so much ❤