cool_techie Posted January 30, 2011 Share Posted January 30, 2011 Can't understand what "TYPE=MyISAM AUTO_INCREMENT=1 ;" means in this code: CREATE TABLE `web_members` ( `id` int(4) NOT NULL auto_increment, `name` varchar(65) NOT NULL default '', `lastname` varchar(65) NOT NULL default '', `email` varchar(65) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; Link to comment https://forums.phpfreaks.com/topic/226125-problem-with-tables/ Share on other sites More sharing options...
Pikachu2000 Posted January 30, 2011 Share Posted January 30, 2011 That means the created table will use the MyISAM engine, and the AUTO_INCREMENT number starts at 1. Link to comment https://forums.phpfreaks.com/topic/226125-problem-with-tables/#findComment-1167320 Share on other sites More sharing options...
cool_techie Posted January 30, 2011 Author Share Posted January 30, 2011 Can you brief me on MyISAM engine. Link to comment https://forums.phpfreaks.com/topic/226125-problem-with-tables/#findComment-1167323 Share on other sites More sharing options...
Pikachu2000 Posted January 30, 2011 Share Posted January 30, 2011 http://www.google.com/search?q=myisam+vs+innodb&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a Link to comment https://forums.phpfreaks.com/topic/226125-problem-with-tables/#findComment-1167329 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.