Table structure for table
CREATE TABLE IF NOT EXISTS `tbl_appointment` ( `ap_id` int( 11 ) NOT NULL , `ap_starting` time( 6 ) NOT NULL , `ap_ending` time( 6 ) NOT NULL , `ap_day` varchar( 255 ) NOT NULL ) ENGINE = InnoDB DEFAULT CHARSET = latin1;
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 '(6) NOT NULL,
ap_endingtime(6) NOT NULL,
ap_dayvarchar(255) NOT NULL )' at line 9`
I tried to import the SQL file to phpmyadmin. the file works fine on later version of XAMPP from what I have. I tried to edit the SQL file based on the error but to no avail.