there is -p option please used that.
On Thu, Feb 10, 2011 at 12:47 PM, Johan De Meersman wrote:
> On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma >wrote:
>
> > 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 i
On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma wrote:
> 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 it
will yield a statem
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
--no-d
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
the
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 t
> From: Adarsh Sharma
>
> 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 change its value! PK = ide
On Wed, Feb 9, 2011 at 7:42 PM, Jerry Schwartz 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 years since I
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 wrote:
[JS] Actually,
On Wed, Feb 9, 2011 at 7:02 PM, Jerry Schwartz 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
> dataset Access w
>-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 co
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 060
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 with
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
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
* there
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
3
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
16 matches
Mail list logo
