Hi devs,
+-------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| ATTENDANCE_DATE | datetime | NO | | NULL | |
| STUDENT_ID | int(10) | NO | | NULL | |
| CLASS_ID | int(10) | NO | | NULL | |
| STAFF_ID | int(10) | NO | | NULL | |
| ATTENDANCE_STATUS | char(1) | YES | | NULL | |
| LATE_STATUS | char(1) | YES | | NULL | |
| LATE_TIME | varchar(7) | YES | | NULL | |
| DROP_TIME | time | YES | | NULL | |
| PICK_TIME | time | YES | | NULL | |
| REMARKS | varchar(200) | YES | | NULL | |
| SCHOOL_ID | int(11) | YES | | NULL | |
| CREATED_ON | datetime | NO | | NULL | |
| CREATED_BY | varchar(15) | NO | | NULL | |
| MODIFIED_ON | datetime | YES | | NULL | |
| MODIFIED_BY | varchar(15) | YES | | NULL | |
+-------------------+--------------+------+-----+---------+-------+
The above is the schema of the table I need to replicate.
The error message is:
Mysql2::Error: 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 '), null, 'I');
Did anyone face this issue before? Please help.
Thanks in advance