FUDforum: comp.lang.php » Reset Auto Increment to lower value

Home » Imported messages » comp.lang.php » Reset Auto Increment to lower value

Show: Today's Messages :: Polls :: Message Navigator

Re: Reset Auto Increment to lower value [message #180135 is a reply to message #180133]

Fri, 11 January 2013 16:18

Captain Paralytic
Messages: 204
Registered: September 2010

Karma:

Senior Member

On Jan 11, 1:55 pm, makam...@gmail.com wrote:
> 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-co...
>
> 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)
> )

Why would it work, you haven't specified a composite primary key?

Report message to a moderator

[Message index]

		Reset Auto Increment to lower value By: makamo66 on Thu, 10 January 2013 17:55
		Re: Reset Auto Increment to lower value By: Denis McMahon on Thu, 10 January 2013 20:17
		Re: Reset Auto Increment to lower value By: Captain Paralytic on Fri, 11 January 2013 10:05
		Re: Reset Auto Increment to lower value By: makamo66 on Fri, 11 January 2013 13:55
		Re: Reset Auto Increment to lower value By: M. Strobel on Fri, 11 January 2013 14:05
		Re: Reset Auto Increment to lower value By: Captain Paralytic on Fri, 11 January 2013 16:18
		Re: Reset Auto Increment to lower value By: Luuk on Fri, 11 January 2013 19:07
		Re: Reset Auto Increment to lower value By: Luuk on Fri, 11 January 2013 19:22
		Re: Reset Auto Increment to lower value By: makamo66 on Fri, 11 January 2013 19:37
		Re: Reset Auto Increment to lower value By: makamo66 on Fri, 11 January 2013 19:38

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) ] [

]

Current Time: Wed Nov 27 22:38:34 GMT 2024

Total time taken to generate the page: 0.04006 seconds