Creating table Leaderboard task | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Creating table Leaderboard task

Hi! The code gives no output, the error says "no input". Could you please suggest where the error is? Thanks in advance! Create table Leaderboard (Place int, Nickname varchar, Rating int); Insert into Leaderboard Values (1, 'Predator', 9500), (2, 'JohnWar', 9300), (3, 'NightWarrior', 8900);

25th Jul 2021, 7:32 AM
Georgia Owl
3 Answers
+ 9
Maybe you need to do a SELECT operation after INSERT operation?
25th Jul 2021, 7:51 AM
Ipang
+ 3
OMG, true. I didn't even think about this. Thanks a lot!
25th Jul 2021, 7:56 AM
Georgia Owl
0
CREATE TABLE leaderboard ( place INTEGER, nickname VARCHAR, rating INTEGER ); INSERT into leaderboard VALUES (1,'Predator',9500), (2,'JohnWar', 9300), (3,'NightWarrior', 8900); SELECT * FROM leaderboard;
6th Oct 2023, 3:52 PM
Kanake Karani
Kanake Karani - avatar