+ 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

3rd May 2021, 7:52 PM
Александр Телятников
Александр Телятников - avatar
1 Odpowiedź
+ 1
Try using double quotes (") instead of (') in update command.
8th May 2021, 1:59 AM
Nikunj Vashishtha
Nikunj Vashishtha - avatar