+ 1
Why is it displayed with a small letter?
ALTER TABLE cities ADD attractiveplace VARCHAR; UPDATE cities SET attractiveplace= 'Belem Tower' WHERE population=504718; UPDATE cities SET attractiveplace = 'Plaza Mayor' WHERE population = 3223000; UPDATE cities SET attractiveplace = 'Eiffel Tower' WHERE population = 2161000; SELECT name, country, population, attractiveplace FROM cities; Waiting - Belem Tower, Plaza Mayor, Eiffel Tower Reality - belem tower, plaza mayor , eiffel tower
1 Answer
+ 1
Try using double quotes (") instead of (') in update command.