· 8 years ago · Aug 16, 2018, 10:46 PM
1importing mysql database using mamp, phpMyAdmin
2CREATE TABLE IF NOT EXISTS `assignments` (
3`uid` int( 11 ) default NULL ,
4`rid` int( 11 ) default NULL ,
5`semester` varchar( 255 ) default NULL ,
6`year` int( 11 ) default NULL
7) TYPE = MYISAM ;
8
9MySQL said: Documentation
10#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax
11to use near 'TYPE=MyISAM' at line 6