ALTER TABLE sometable AUTO_INCREMENT = 1000;
On 10/17/2010 07:03 AM, short cutter wrote:
Hi,
Is it possible to change this directive's value without modifition to
my.cnf and restart mysqld?
I remember there is a set @@variable syntax, but not sure.
Thanks.
2010/10/17 mos:
At 08:55 PM 1
Hi,
Is it possible to change this directive's value without modifition to
my.cnf and restart mysqld?
I remember there is a set @@variable syntax, but not sure.
Thanks.
2010/10/17 mos :
> At 08:55 PM 10/16/2010, you wrote:
>>
>> After executing the SQL statement, the next Id inserted will be 1000
At 08:55 PM 10/16/2010, you wrote:
After executing the SQL statement, the next Id inserted will be 1000.
Oops. I meant :
After executing the SQL statement, the next Id inserted will be 1001.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
At 08:05 PM 10/16/2010, you wrote:
Hello,
I have a table which has the ID key with auto_increment and which is a
primary key.
If I insert the table with the id value which is generated by the
program, for example,
insert table (id, user_name, age) values (1000, 'kenn', 30);
the value 1000 is
Hello,
I have a table which has the ID key with auto_increment and which is a
primary key.
If I insert the table with the id value which is generated by the
program, for example,
insert table (id, user_name, age) values (1000, 'kenn', 30);
the value 1000 is inserted forcely, not generated by d
MAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 12, 2004 9:35 AM
Subject: Re: auto_increment id
> "Stefan Schuster" <[EMAIL PROTECTED]> wrote:
> >> "Stefan Schuster" <[EMAIL PROTECTED]> wrote:
> >>> Hi,
> >>>
"Stefan Schuster" <[EMAIL PROTECTED]> wrote:
>> "Stefan Schuster" <[EMAIL PROTECTED]> wrote:
>>> Hi,
>>>
>>> I have a question about auto_increment:
>>>
>>> I have 2 tables, on of them holds my "online transactions", the other
>>> one the "offline transactions". Every transaction is created in the
> "Stefan Schuster" <[EMAIL PROTECTED]> wrote:
>> Hi,
>>
>> I have a question about auto_increment:
>>
>> I have 2 tables, on of them holds my "online transactions", the other
>> one the "offline transactions". Every transaction is created in the
>> first table (call it t1) and then moved to t2. Th
"Stefan Schuster" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a question about auto_increment:
>
> I have 2 tables, on of them holds my "online transactions", the other
> one the "offline transactions". Every transaction is created in the
> first table (call it t1) and then moved to t2. The id is
Hi,
I have a question about auto_increment:
I have 2 tables, on of them holds my "online transactions", the other
one the "offline transactions". Every transaction is created in the
first table (call it t1) and then moved to t2. The id is generated using
auto_increment.
My problem is that the id
This would give you a list of all users that have entered things more than
once; However, it would not give you all the rows that are duplicated.
SELECT Count(User) from mail_form2 GROUP BY User HAVING Count(User) > 1
Hope this helps!
Daniel Von Fange
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Tom Churm wrote:
> hi,
>
> i have 2 questions that i badly need answered. i use phpmyadmin, but
> any answers containing SQL syntax should work in this app...
>
> 1)
> this should be simple but i don't know it. i use the following mysql
> table field as the Key for my tables:
>
> "id int(
hi,
i have 2 questions that i badly need answered. i use phpmyadmin, but
any answers containing SQL syntax should work in this app...
1)
this should be simple but i don't know it. i use the following mysql
table field as the Key for my tables:
"id int(10) unsigned NOT NULL auto_increment,"
13 matches
Mail list logo
