CODEWITHSUNDEEP
javasqloracle-databasenetbeansformat
Raquel Gomes
Raquel Gomes

Reputation: 3

Sql insert into table error

Insert into query does not seem to be working, I have changed the format various times but unable to make it work. Using sql on Netbeans 8.0.2

INSERT INTO “TypesOfApps” (“Lifestyle”, “SocialMedia”,“Utility”, “Games”,  “Productivity”, “News”)
      VALUES 
    (“Fitness”, “Facebook”, “Reminders”, “Angry Birds”, “Docs”, “Buzfeed”),
    (“Dating”, “Instagram”, “Calculator”, “Clash of Clans”, “Google Sheets”, “SmartNews”),
    (“Food”, “Pinterest”, “Flashlight”, “Subway Surfer”, “Wallet”, “Google News”),
    (“Music”, “Snapchat”, “Weather”, “Coin Dozer”, “Evernote”, “Feedly”),
    (“Travel”, “Twitter”, “Calendar”, “CandyCrush”, “WunderList”, “Reddit”);

Have also changed it - as i googled the problem and it seemed to fix it for people - like this:

INSERT INTO “TypesOfApps” (“Lifestyle”, “SocialMedia”,Utility”, “Games”, “Productivity”, “News”)
 VALUES(“Fitness”, “Facebook”, “Reminders”, “Angry Birds”, “Docs”, “Buzfeed”);

INSERT INTO “TypesOfApps” (“Lifestyle”, “SocialMedia”,Utility”, “Games”, “Productivity”, “News”)
 VALUES(“Dating”, “Instagram”, “Calculator”, “Clash of Clans”, “Google Sheets”, “SmartNews”);

INSERT INTO “TypesOfApps” (“Lifestyle”, “SocialMedia”,Utility”, “Games”, “Productivity”, “News”)
 VALUES(“Food”, “Pinterest”, “Flashlight”, “Subway Surfer”, “Wallet”, “Google News”);

INSERT INTO “TypesOfApps” (“Lifestyle”, “SocialMedia”,Utility”, “Games”, “Productivity”, “News”)
 VALUES(“Music”, “Snapchat”, “Weather”, “Coin Dozer”, “Evernote”, “Feedly”);

INSERT INTO “TypesOfApps” (“Lifestyle”, “SocialMedia”,Utility”, “Games”, “Productivity”, “News”)
 VALUES(“Travel”, “Twitter”, “Calendar”, “CandyCrush”, “WunderList”, “Reddit”);

help would be greatly appreciated, this is part of a coursework.

Thank you!

UPDATE : This is the error I'm getting

Error code 30000, SQL state 42X02: Lexical error at line 1, column 13.
Encountered: "\u201c" (8220), after : "".
Line 48, column 1

Upvotes: 0

Views: 204

Answers (1)

Rahul Jain
Rahul Jain

Reputation: 1399

Can you try this:

INSERT INTO TypesOfApps (Lifestyle, SocialMedia,Utility, Games,   Productivity, News)
VALUES('Fitness', 'Facebook', 'Reminders', 'Angry Birds', 'Docs', 'Buzfeed');

if not working, share what error you are getting.

Upvotes: 2

Related Questions