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 ; Quote 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. Quote 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. Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/226125-problem-with-tables/#findComment-1167329 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.