Dear all,
I have an auto-increment column in Mysql database table. Let's say the
column has below values :
1
2
3
4
5
6
7
8
9
10
Now if i deleted some rows where id= 3 ,5 and 8
The data look like as :
1
2
4
6
7
9
10
I want to have it id's as
1
2
3
4
5
6
7
and next data is inserted right
On 09/02/2011 11:41, Adarsh Sharma wrote:
Dear all,
I have an auto-increment column in Mysql database table. Let's say the
column has below values :
1
2
3
4
5
6
7
8
9
10
Now if i deleted some rows where id= 3 ,5 and 8
The data look like as :
1
2
4
6
7
9
10
I want to have it id's as
1
2
You do not want this really from the point you understood
what a primary key does in a database
The PRIKEY is unqiue for a record and if the record
does no longer exist his PRIKEY must never return
Sample:
* website
* shop-products
* you have prodid 500 costs 200$
* you delete the product
*
Thanks. The developer cheerily informs me that Access is 'deprecated' and will
be phased out. So, SQL it is.
I'm not sure what you mean by 'passthrough'. Do you mean
MYSQL
|
ODBC
|
Win app
?
If so, where do I go to learn how to configure MySQL and ODBC to dance together
nicely, and talk
No, what he is suggesting is that you use Access or MSSQL, and link Mysql to
either platform via ODBC so that you can use it indirectly. All databases are
not the same in terms structure and capabilities..you most likely will not be
able to swap one out for another and make it work directly
You should probably take this over to the MyODBC list.
I suggest that you get the Bullzip programs and look at what they do by way of
transferring the database structure. You'll learn a lot from that.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT
-Original Message-
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Wednesday, February 09, 2011 1:18 AM
To: Y z
Cc: mysql@lists.mysql.com
Subject: Re: Replacing MS SQL with MySql
No way to do that directly; however, using the MySQL ODBC connector
On Wed, Feb 9, 2011 at 7:02 PM, Jerry Schwartz je...@gii.co.jp wrote:
[JS] Actually, I've done a lot of tracing recently (to solve my own
performance problems), and Access 2007 is very clever at pulling parts of a
dataset and a number of other things. For example, when you are browsing a
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Wednesday, February 09, 2011 1:10 PM
To: Jerry Schwartz
Cc: Y z; mysql@lists.mysql.com
Subject: Re: Replacing MS SQL with MySql
On Wed, Feb 9, 2011 at 7:02 PM, Jerry Schwartz je...@gii.co.jp wrote:
On Wed, Feb 9, 2011 at 7:42 PM, Jerry Schwartz je...@gii.co.jp wrote:
*[JS] I don’t have any data at the moment. I know that I tried outsmarting
Access with pass-through queries, with little luck.*
Hmm. I seem to remember those working, but that was in access itself, I
think. It's been many
From: Adarsh Sharma adarsh.sha...@orkash.com
I have an auto-increment column in Mysql database table. Let's say the column
has below values :
I'll echo what others have said.
Auto-increment is typically used to generate unique primary keys. If this
column is your primary key, DO NOT
Thank you for your reply, Janusz.
I appreciate your help.
I have tried making that call before the INSERT statement, but to no avail.
The table collation is set to utf8 - default collation, and all columns are
set to Table default.
I am thinking that this problem might be due to me sending the
I can't help but wonder, if you send a string, does that mean you're putting
text in a blob ? Blobs are binary, and thus don't get encoded in the sense
of UTF8 vs Unicode. For a string, you may want a TEXT type column.
On the other hand, if you're indeed trying to insert binary data, it is not
Dear all,
I am researching all the ways to backup in mysql and donot able to find
a command that take individual backup of only one procedure in mysql.
I know this command and it needs some modification. Please help.
mysqldump -h192.168.0.10 -uroot -porkash --routines --no-create-info
On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
I am researching all the ways to backup in mysql and donot able to find a
command that take individual backup of only one procedure in mysql.
Have a look at the SHOW CREATE PROCEDURE syntax. It's not mysqldump, but
there is -p option please used that.
On Thu, Feb 10, 2011 at 12:47 PM, Johan De Meersman vegiv...@tuxera.bewrote:
On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma adarsh.sha...@orkash.com
wrote:
I am researching all the ways to backup in mysql and donot able to find a
command that take
16 matches
Mail list logo