SQL CRUD操作查询问题 [英] SQL CRUD operation Query Issues

问题描述

INSERT INTO Owner
VALUES (1205, 'Wonderland', 'Alice',
'[e-mail]') ;

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

第一条消息：SQL语句结束时缺少分号（;）


第二个m essage：在SQL语句结束后找到的字符

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

2nd message: Characters found after end of SQL statement

推荐答案

似乎语法中几乎没有错误。我试着强调以下内容：



INSERT INTO Owner

VALUES（1205，'Wonderland'，'Alice'，

'[e-mail]'）;



UPDATE播放器

SET 薪水= 1800000

WHERE player_id = 323 ;



SELECT FROM Player

WHERE salary> ; 1000000;



DELETE FROM Owner

WHERE last_name =JonesAND first_name =Jerry;



注意：以下声明似乎很危险，因为它没有 where 子句，所以它会在Game表中更新所有行。



UPDATE游戏

SET home_score = 17，

visitor_score = 23 ;

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

INSERT INTO Owner
VALUES (1205, 'Wonderland', 'Alice',
'[e-mail]') ;

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 ;

在SQL Server中实现任何查询时，请遵循以下CRUD操作语法。

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

SELECT * FROM TABLENAME
WHERE CONDITIONS

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

UPDATE TABLENAME
SET COLUMN1 = YOURVALUE
WHERE CONDITIONS

DELETE FROM TABLENAME
WHERE CONDITIONS

由于语法不匹配，只有你得到了abo错误，首先纠正你的语法显然错误已经解决。

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

这篇关于SQL CRUD操作查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！