cameeob2003 Posted June 28, 2006 Share Posted June 28, 2006 I was wondering what the: TYPE=MyISAM AUTO_INCREMENT=26 ;In something like:[code]CREATE TABLE `news` ( `id` int(11) NOT NULL auto_increment, `picture` text NOT NULL, `content` text NOT NULL, `title` text NOT NULL, PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=26;[/code]is doing. Im new to SQL so im just trying to get on my feet about it all. Quote Link to comment https://forums.phpfreaks.com/topic/13089-help-figuring-out-what-a-sertain-strand-does/ Share on other sites More sharing options...
Wildbug Posted June 28, 2006 Share Posted June 28, 2006 That sets the next value of the AUTO_INCREMENT column, typically used in a table dump like that one. So your next value will be 26 in that table. Presumably, there were also 25 lines in the dumpfile, too? Quote Link to comment https://forums.phpfreaks.com/topic/13089-help-figuring-out-what-a-sertain-strand-does/#findComment-50415 Share on other sites More sharing options...
fenway Posted July 3, 2006 Share Posted July 3, 2006 Yeah, most mysqldumps produce that line for no reason whatsoever, since MySQL will handle auto-increments all on its own. However, this is a great way to start at a non-zero value. Quote Link to comment https://forums.phpfreaks.com/topic/13089-help-figuring-out-what-a-sertain-strand-does/#findComment-52279 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.