FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » Reset Auto Increment to lower value
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Reset Auto Increment to lower value [message #180133 is a reply to message #180132] Fri, 11 January 2013 13:55 Go to previous messageGo to previous message
makamo66 is currently offline  makamo66
Messages: 4
Registered: January 2013
Karma:
Junior Member
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:
>
>>
>
>> user_id sub_tile_id
>
>> 1       1
>
>> 1       2
>
>> 1       3
>
>> 2       1
>
>> 2       2
>
>> 2       3
>
>> 3       1
>
>> 3       2
>
>> 3       3
>
>> etc.
>
>> 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-composit e-key

This didn't work
CREATE TABLE `tiles` (
`sub_tile` ENUM('1','2','3') NOT NULL,
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`user_id` INT(22)
)
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: php unit testing - how to find the right person
Next Topic: Anyone have experience with any php debuggers?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 15:36:29 GMT 2024

Total time taken to generate the page: 0.04485 seconds