java - sql 行、冲突等问题
问题描述
我是这个网站的新手,我必须在我的数据库中输入此 SQL 指令,但我无法解决如下所示的错误:
*create table category ( id int(10) primary key not null auto_increment, name varchar(50));
create table product ( product_id int(10) primary key not null auto_increment, name varchar(50) , price double(10,2), category_id int(10), description varchar(1000));
alter table product add constraint product_ctgy_id_fk foreign key(category_id) references category( id);
create table userorder(order_id int(10) primary key not null auto_increment, user_id int(10) , price double(10,2));
create table user(user_id int(10) primary key not null auto_increment, fname varchar(10), lname varchar(10), email_id varchar(50), phone int(10));
alter table userorder add constraint order_user_id_fk foreign key(user_id) references user(user_id);
//alter table product add column description varchar(1000);
create table orderItems ( item_id int(10) primary key not null auto_increment, name varchar(50), quantity int(2), order_id int(10));
alter table orderItems add constraint order_id_fk foreign key(order_id) references userorder(order_id);
alter table userorder add column order_date date;
alter table user modify phone varchar(10);
alter table userorder modify order_date timestamp;
alter table orderItems add column hotness varchar(10);
alter table user add column address varchar(100);
insert into category values (1,"APPETIZERS");
insert into category values (2,"Soups and Salads");
insert into category values (3,"Tandoori Breads");
insert into category values (4,"Rice and Biryani");
insert into category values (5,"Tandoori Specialities");
insert into category values (6,"Chicken Entrees");
insert into category values (7,"Lamb Entrees");
insert into category values (8,"Sea Food");
insert into category values (9,"Vegetable Delights");
insert into category values (10,"Specials");
insert into category values (11,"Beverages");
insert into category values (12,"Beers");
insert into category values (13,"Deserts");
insert into category values (14,"Side Orders");
insert into product values (1, "VEGETABLE SAMOSA",2.95, 1,"Crisp patties filled with mildly spiced potatoes and peas");
insert into product values (2, "VEGETABLE PAKORA",2.95, 1,"Mixed Vegetable Fritters dipped in batter and fried");
insert into product values (3, "CHICKEN PAKORA",6.95, 1,"Boneless chicken dipped in spiced batter and fried");
insert into product values (4, "CHEESE PAKORA",5.95, 1,"Delicately spiced fried cheese fritters");
insert into product values (5, "FISH PAKORA",8.95, 1,"Fish filets dipped in Spiced batter and fried");
insert into product values (6, "CHICKEN SOUP",4.95, 2,"Indian style, lightly spiced");
insert into product values (7, "MULLIGATAWNY SOUP",3.95, 2,"Delicately Spiced Lentil Soup Garnished with Rice & Chicken");
insert into product values (8, "LENTIL SOUP",2.95, 2,"Mildly spiced");
insert into product values (9, "Vegeterian Salad",3.95, 2,"Lettuce, cheese, cilantro, cucumber, tomatoes");
insert into product values (10, "KACHUMBER/CHICK PEA SALAD",2.95, 2,"Cucumbers, Onions, Tomatoes, Cilantro, Chickpeas & Lemon");
insert into product values(117,"ASSORTED APPETIZERS ",8.95,1,"KABAB, SAMOSA, PAKORA, CHICKEN PAKORA, ONION BHAJI");
insert into product values(118,"PANEER TIKKA (CHEEESE)",12.95,1,"Marinated in spices, cooked in clay over, sautéed in bell pepper & onion");
insert into product values(119,"CHILI CHICKEN",13.95,1,"Boneless chicken sautéed with onion and Bell Pepper");
insert into product values(120,"ONION BHAJI",3.95,1,"Chopped onions dipped in batter and fried");
insert into product values(121,"GULAB JAMUN",3.95,13,"Indian Milk Cheese Balls, Fried & soaked in honey syrup");
insert into product values(122,"KHEER",3.95,13,"Indian Rice Pudding");
insert into product values(123,"PISTACHIO KULFI",4.95,13,"Indian Ice Cream With Pistachios");
insert into product values(124,"MANGO KULFI",4.95,13,"Indian Ice Cream With Mango");
insert into product values(125,"RAITA",2.5,14,"Cultured Yogurt with Cucumbers, Carrots & Spices");
insert into product values(126,"Plain Yogurt",2.5,14,"");
insert into product values(127,"MANGO CHUTNEY",2.5,14,"");
insert into product values(128,"HOT PICKEL",1.95,14,"");
insert into product values(129,"PAPADDAM",1.25,14,"");*
但出现错误“CONFLICT WITH "TABLE" and Entity name expected.
我该如何解决这个问题?我需要创建该列,因为我的 .war 需要它。否则它将返回 500 错误。
解决方案
看一下mySql的保留关键字: https ://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-U
似乎您尝试user
使用 mySql 关键字创建表。
尝试封装表名:
create table `user`(
或者,如果可能,将其重命名为 smth likeusers
推荐阅读
- neo4j - 在命令行中启动 neo4j 控制台时出现意外错误
- authorization - 我们可以在没有授权服务器的情况下使用 OpenId 连接登录在 Okta 中创建单页应用程序吗?
- azure - 如何使用 Azure 服务总线高级版的灾难恢复功能
- ios - 将 iOS 应用程序的新版本更新创建到 iTunes 连接时出错
- python - 在 Django 休息框架中批量插入和更新
- mysql - MySQL - 在性能之间复制数据库然后删除数据或新数据库然后插入
- java - 使用 Java 8 流仅列出特定深度的文件夹
- macros - Crystal lang:在宏中,将参数添加到调用节点的最佳实践
- kivy - Kivy Touch - Raspbian Stretch 26.07
- java - 将未导出/未打开的包添加到模块信息的 ModulePackages 的用例是什么?