错误“第1行中的MySQL错误”可能有什么原因
我正在创建一个名为bamazonManager.js的新Node应用程序。运行此应用程序将:
- 列出一组菜单选项:
- 查看待售产品查看低价
- 库存添加到库存添加新产品如果经理选择查看待售产品,应用程序应列出每个可用项目:项目ID,名称,价格和数量。
- 如果经理选择查看低库存,则应列出库存数低于5的所有料品。
- 如果经理选择添加到库存,您的应用应显示一个提示,让经理“添加更多”当前商店中的任何商品。
- 如果经理选择添加新产品,则应允许经理向商店添加全新产品。
我正在努力在MySQL中创建数据库设置 - 错误不断出现“第1行中的MySQL错误” - 我可能需要再次关注此问题。
DROP DATABASE IF EXISTS manager_viewDB;
CREATE DATABASE manager_viewDB;
use manager_viewDB;
CREATE TABLE products (
item_id INT(11) NOT NULL AUTO_INCREMENT,
item_name VARCHAR(20) CHARACTER SET utf8,
department_name varchar(50) DEFAULT NULL,
item_price INT(11) DEFAULT NOT NULL,
item_quantity int(11) DEFAULT NOT NULL,
PRIMARY KEY (item_id)
);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Mini Mac", "Computers", 689, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("ECHO plus", "Amazon Devices", 79.99, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Funny Cat Mug", "Handmade", 20, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Wine Barell Top Mirror", "Home and Kitchen", 328, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Hand Stamped Bracelets", "Wedding", 20, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Kawaii - Animal Plush", 22, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Weave Blanket - MDA", "Handmade", 60, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Retro Tiki - Cellphone", "Handbags and Accessories", 22, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Handmade Leather Bag", "Handbags and Accessories", 70, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Devialet Gold Phantom", "Electronics", 2990, 10);
回答如下:
我在这里看到一些问题。
删除DEFAULT或在创建表时指定DEFAULT值。
您的item_name只有20个字符,但您尝试插入的名称长于该字符。
此外,VALUES(“Kawaii - Animal Plush”,22,10)在期待4时只有3个值。
错误“第1行中的MySQL错误”可能有什么原因
我正在创建一个名为bamazonManager.js的新Node应用程序。运行此应用程序将:
- 列出一组菜单选项:
- 查看待售产品查看低价
- 库存添加到库存添加新产品如果经理选择查看待售产品,应用程序应列出每个可用项目:项目ID,名称,价格和数量。
- 如果经理选择查看低库存,则应列出库存数低于5的所有料品。
- 如果经理选择添加到库存,您的应用应显示一个提示,让经理“添加更多”当前商店中的任何商品。
- 如果经理选择添加新产品,则应允许经理向商店添加全新产品。
我正在努力在MySQL中创建数据库设置 - 错误不断出现“第1行中的MySQL错误” - 我可能需要再次关注此问题。
DROP DATABASE IF EXISTS manager_viewDB;
CREATE DATABASE manager_viewDB;
use manager_viewDB;
CREATE TABLE products (
item_id INT(11) NOT NULL AUTO_INCREMENT,
item_name VARCHAR(20) CHARACTER SET utf8,
department_name varchar(50) DEFAULT NULL,
item_price INT(11) DEFAULT NOT NULL,
item_quantity int(11) DEFAULT NOT NULL,
PRIMARY KEY (item_id)
);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Mini Mac", "Computers", 689, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("ECHO plus", "Amazon Devices", 79.99, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Funny Cat Mug", "Handmade", 20, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Wine Barell Top Mirror", "Home and Kitchen", 328, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Hand Stamped Bracelets", "Wedding", 20, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Kawaii - Animal Plush", 22, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Weave Blanket - MDA", "Handmade", 60, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Retro Tiki - Cellphone", "Handbags and Accessories", 22, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Handmade Leather Bag", "Handbags and Accessories", 70, 10);
SELECT * FROM products;
INSERT INTO products (item_name, department_name, item_price, item_quantity)
VALUES("Devialet Gold Phantom", "Electronics", 2990, 10);
回答如下:
我在这里看到一些问题。
删除DEFAULT或在创建表时指定DEFAULT值。
您的item_name只有20个字符,但您尝试插入的名称长于该字符。
此外,VALUES(“Kawaii - Animal Plush”,22,10)在期待4时只有3个值。