- 1

SQL 25.2

I'm having problem with this code, can anyone help me. what did I do wrong? ALTER TABLE cities ADD AttractivePlace VARCHAR INSERT INTO cities (AttractivePlace) VALUES ('Belem Tower'), ('Plaza Mayor'), ('Eiffel Tower'); SELECT * FROM cities ;

3rd Nov 2021, 2:01 AM
Nick Tran
1 Answer
+ 6
I was just thinking maybe you should UPDATE the data of new `AttractivePlace` in existing rows rather than INSERT new rows with only the new column `AttractivePlace` data.
3rd Nov 2021, 3:37 AM
Ipang