MySQL不插入数据

Question

之前已创建表并已插入数据

似乎无法执行插入命令，现阶段尚未尝试其他命令

重置了mysql，还是这样...

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.20 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> USE X32334732
Database changed
mysql> INSERT INTO Product (Name, Picture, Type, Description, Sales_Price) VALUE
S ("FIFA 15", "pics/games/fifa.jpg", "Game - ps4", "Soccer Sports Game", 44.95);

感谢您的帮助。

感谢 2 Codebird，我使用的是“not ' ....我猜是菜鸟错误。TY

Answer 1

当控制台显示“>”时，这意味着您位于一个用双引号 (") 括起来且未闭合的字符串内。

您在此处发布的字符串似乎没有任何未闭合的双引号，但您似乎仍然有一个。仔细检查您的输入。

您可以通过输入 "; 来结束当前情况；关闭引号和分号来执行命令，您可能会收到语法错误。