Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
Description
Tried a tutorial creation:
MariaDB [test]> CREATE TABLE candidates ( |
-> candidate_id NUMBER,
|
-> first_name VARCHAR2(50) NOT NULL, |
-> last_name VARCHAR2(50) NOT NULL, |
-> job_title VARCHAR2(255) NOT NULL, |
-> year_of_experience INTERVAL YEAR TO MONTH, |
-> PRIMARY KEY (candidate_id) |
-> );
|
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INTERVAL YEAR TO MONTH, |
PRIMARY KEY (candidate_id)
|
)' at line 6 |
Interval ddl:
http://www.oracletutorial.com/oracle-basics/oracle-interval/
Attachments
Issue Links
- is duplicated by
-
MDEV-12513 INTERVAL data type
- Open