由:java.sql.sqlsyntaxerrorexception:[…]版本导致，在第1行“order(id)”附近使用正确的语法

Question

spring.jpa.hibernate.ddl-auto=update

org.hibernate.tool.schema.spi.CommandAcceptanceException：通过JDBC语句执行DDL“CREATE table order（id bigint not null auto_increment,order_date date,user_id bigint,primary key(id))Engine=MYISAM”时出错

由：java.SQL.sqlsyntaxerrorexception引起：您的SQL语法中有一个错误；请查看与您的MySQL服务器版本相对应的手册，以便在第1行“order(id)”附近使用正确的语法

我的映射如下所示：

@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@MappedSuperclass
public abstract class BaseEntity {

    @Id
    @GeneratedValue(
            strategy = GenerationType.IDENTITY
    )
    private Long id;
}


@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@Entity(name = "Order")
@Table(name = "order")
public class Order extends BaseEntity {

    private LocalDate orderDate;

    @OneToMany(mappedBy = "order", cascade = CascadeType.ALL)
    private List<OrderedTicket> orderedTickets = new ArrayList<>();

    private Long userId;

}


@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@Entity(name = "OrderedTicket")
@Table(name = "ordered_ticket")
public class OrderedTicket extends BaseEntity {

    private Integer amount;

    @OneToOne
    @JoinColumn(name="ticket_id")
    private Ticket ticket;

    @ManyToOne(cascade = CascadeType.ALL)
    @JoinColumn(name = "order_id")
    private Order order;

}


@Getter
@Setter
@NoArgsConstructor
@Entity(name = "Ticket")
@Table(name = "ticket")
public class Ticket extends BaseEntity {

    @Enumerated(value = EnumType.STRING)
    private TicketType type;
    private Integer price;
    private Integer totalAmmount;
    private Integer inStock;

    @ManyToOne(cascade = {
            CascadeType.DETACH,
            CascadeType.MERGE,
            CascadeType.PERSIST,
            CascadeType.REFRESH
    })
    @JoinColumn(name = "event_id")
    Event event;

    @Builder
    public Ticket(TicketType type, Integer price, Integer totalAmmount, Integer inStock, Event event) {
        this.type = type;
        this.price = price;
        this.totalAmmount = totalAmmount;
        this.inStock = inStock;
        this.event = event;
    }

}

Answer 1

您不应该将表命名为ORDER，因为ORDER是一个保留的SQL关键字。

你可以这样做，但你总是必须在引号中附上订单。

请查看MySQL手册中所有保留的关键字：