SQL CRUD operation Query Issues

Question

1.00/5 (2 votes)

See more:

SQL

INSERT INTO Owner
VALUES (1205, 'Wonderland', 'Alice',
'awonderland@domain.com') ;

UPDATE Player
salary = 1800000
WHERE player_id = 323

SELECT FROM Player
WHERE salary >1000000

DELETE FROM Owner
last_name = "Jones" AND first_name = "Jerry"

UPDATE Game
SET home_score = 17,
       visitors_score = 23

1st message: Missing semicolon (;) at end of SQL statement

2nd message: Characters found after end of SQL statement

Posted 26-Oct-15 15:02pm

Juan Manuel Vigil Bardelli

Updated 26-Oct-15 22:05pm

Naveen.Sanagasetti

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 26-Oct-15 21:27pm

Messages are quite clear.

jaket-cp 28-Oct-15 5:29am

I am just interested to know, is this homework or the like?
As these are rudimentary mistakes.
In any case solutions 1 and 2 should answer your question.

Juan Manuel Vigil Bardelli 28-Oct-15 16:35pm

Hi,
Is my homework.
I never program anything in my life and this is again my homework.
Can you please help me?

SELECT;

INSERT INTO Owner
VALUES (1205, 'Wonderland', 'Alice';
'awonderland@domain.com');

UPDATE Player
salary = 1800000
WHERE player_id = 323;

SELECT FROM Player
WHERE salary > 1000000;

DELETE FROM Owner
last_name = "Jones" AND first_name = "Jerry";

UPDATE Game
WHERE
SET home_score = 17,
visitors_score = 23;
Now I'm getting a message:
"The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect."

I will be very thankful if you can help me if possible...

2 solutions

Solution 2

Follow below CRUD Operation syntax while implement any query in SQL Server.

SQL

SELECT * FROM TABLENAME
WHERE CONDITIONS

INSERT INTO TABLENAME(COLUMNS)
VALUES(....)

UPDATE TABLENAME
SET COLUMN1 = YOURVALUE
WHERE CONDITIONS

DELETE FROM TABLENAME
WHERE CONDITIONS

because of mismatching syntax only you are getting the above errors, first correct your syntax obviously the errors has been resolved.

Posted 26-Oct-15 22:10pm

Naveen.Sanagasetti

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Snesh Prajapati · Accepted Answer · 2015-10-26T15:50:00

It seems there are few error in syntax. I tried to highlight those below:

INSERT INTO Owner
VALUES (1205, 'Wonderland', 'Alice',
'awonderland@domain.com') ;

UPDATE Player
SET salary = 1800000
WHERE player_id = 323 ;

SELECT FROM Player
WHERE salary > 1000000 ;

DELETE FROM Owner
WHERE last_name = "Jones" AND first_name = "Jerry" ;

Cautions: Below statement seems to be dangerous because it does not have where clause, so it will update all rows in Game table.

UPDATE Game
SET home_score = 17,
visitors_score = 23 ;