+ 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 Answer
+ 1
Try using double quotes (") instead of (') in update command.
8th May 2021, 1:59 AM
Nikunj Vashishtha
Nikunj Vashishtha - avatar