Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #8068

Re: Reset Auto Increment to lower value

Show all headers | View raw

Am 11.01.2013 14:55, schrieb makamo66@gmail.com:
> On Friday, January 11, 2013 5:05:54 AM UTC-5, Captain Paralytic wrote:
>> On Jan 10, 5:55 pm, makam...@gmail.com wrote:
>>
>>> I need to create a tiles table that has a structure like this forhttp://www.myownmealplanner.com:
--cut
>>
>>> I can't just create new tables for new users because I'm using cakephp and that would require new models, views, and controllers for every new table. How do I get the sub_tile_id to auto_increment starting at every new user id? According to the manual I can't restart auto-increment with a lower value than it has already displayed so this needs to be done with php somehow.
>>
>>
>>
>> If you are uaing MySQL then this is the default behaviour:
>>
>> http://stackoverflow.com/questions/3804845/auto-increment-usage-in-composite-key
> 
> This didn't work

what?

> CREATE TABLE `tiles` (  
> 	`sub_tile` ENUM('1','2','3') NOT NULL,
> 	`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,  
> 	`user_id` INT(22)
>  )
> 

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Reset Auto Increment to lower value makamo66@gmail.com - 2013-01-10 09:55 -0800
  Re: Reset Auto Increment to lower value Denis McMahon <denismfmcmahon@gmail.com> - 2013-01-10 20:17 +0000
  Re: Reset Auto Increment to lower value Captain Paralytic <paul_lautman@yahoo.com> - 2013-01-11 02:05 -0800
    Re: Reset Auto Increment to lower value makamo66@gmail.com - 2013-01-11 05:55 -0800
      Re: Reset Auto Increment to lower value "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2013-01-11 15:05 +0100
      Re: Reset Auto Increment to lower value Captain Paralytic <paul_lautman@yahoo.com> - 2013-01-11 08:18 -0800
      Re: Reset Auto Increment to lower value Luuk <luuk@invalid.lan> - 2013-01-11 20:07 +0100
  Re: Reset Auto Increment to lower value Luuk <luuk@invalid.lan> - 2013-01-11 20:22 +0100
  Re: Reset Auto Increment to lower value makamo66@gmail.com - 2013-01-11 11:37 -0800
    Re: Reset Auto Increment to lower value makamo66@gmail.com - 2013-01-11 11:38 -0800

csiph-web