question

Strato avatar image
Strato asked

Got error while adding constraint

ALTER TABLE Events

ADD CONSTRAINT check_TicketPrice

CHECK (TicketPrice BETWEEN 10 AND 1000)

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(TicketPrice BETWEEN 10 AND 1000)' at line 2

mysqlphp
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.