how can encrypt the pw to use mysqldump

Hi how can encrypt the pw to use mysqldump thank you _ Find info faster and easier with Internet Explorer 8. http://go.microsoft.com/?linkid=9655583

RE: Mistake #sql-9c8_21' (errno: 150) SOLVED.

Hello Martin/Michael, I have recreated all relationships one important thing is when I made reverse engineer in MicroOLAP database Designer, and create the script for these tables and relationships in some cases the fields are defined as "Not Unsigned Not NULL" when I delete "Not Unsigned" in al

Re: cannot alter table - solved

You do need the foreign keys for integrity and the columns which make the foreign reference should be indexed as well. My only point is that bookID is already indexed as the first element in the primary key, so the additional index on bookID alone is superfluous. - michael On Fri, May 22, 2009

Re: cannot alter table - solved

Michael Dykman wrote: > On Fri, May 22, 2009 at 12:26 AM, PJ wrote: > >> Michael Dykman wrote: >> >>> On Thu, May 21, 2009 at 11:06 PM, PJ wrote: >>> >>> I have a seemingly impossible situation. I cannot insert values into the tables and I cannot alter or delete the prima

Re: Update with value form another table

On Fri, May 22, 2009 at 1:22 PM, Chris W <4rfv...@cox.net> wrote: > Of course study to profile is a one to many relationship.  How do I run an > update to set  p.`Date` equal to s.`Date`? This is covered in the docs for UPDATE. Read that and come back if you're stuck. - Perrin -- MySQL General

Update with value form another table

I have a table with a date value that I need to update with a value from another table. The table I want to update is profile. The profile table is linked to the study table with the foreign key StudyID. the profile table has the date I want to update to the value in the date value in the s

RE: Mistake #sql-9c8_21' (errno: 150)

no puedo ver la disposición atada del esquema de la exhibición de la imagen. .please de la tabla relevante y crear la tabla, cree las declaraciones del índice Saludos Cordiales desde EEUU! Martin GMT+5(por la semana) __ Verzicht und Vertraulichkeitanm

Re: Date Time

On Fri, May 22, 2009 at 12:42 PM, John Meyer wrote: > Janek Bogucki wrote: >> >> Hi John, >> >> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes >> some information about acceptable literal forms for dates and times. >> >> 'Thu May 21 03:15:28 + 2009' is not an acceptab

Mistake #sql-9c8_21' (errno: 150)

Hpe you are doing well, and Trying to create a FK from "evaluacion" table to "seccion" table I got this error message, does anybody knows how to solve this, anyone have heard about this mistake, any help on this will be really appreciated. Saludos Arturo Hinojo NO imprimas este

RE: Question about Maria readers/writers

only if you are implementing INNODB Transactional Storage Engine MySQL uses table-level locking for MyISAM, MEMORY and MERGE tables, page-level locking for BDB tables, and row-level locking for InnoDB tables. http://dev.mysql.com/doc/refman/5.0/en/internal-locking.h

Re: Date Time

Janek Bogucki wrote: Hi John, http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes some information about acceptable literal forms for dates and times. 'Thu May 21 03:15:28 + 2009' is not an acceptable literal form but this is how to parse it APART from the time zone com

Question about Maria readers/writers

From the MySQL v6 manual: http://dev.mysql.com/doc/refman/6.0/en/se-maria-concurrency.html + When using transactional tables, Maria supports a single writer and multiple readers. The single writer supports both INSERT and

RE: Date Time

mysql> create table t(d datetime); Query OK, 0 rows affected (0.08 sec) mysql> insert into t(d) values(str_to_date('Thu May 21 03:15:28 + 2009', '%a %b %e %H:%i:%s + %Y')); Query OK, 1 row affected (0.00 sec) mysql> select * from t; +-+ | d | +-

Re: cannot alter table - solved

On Fri, May 22, 2009 at 12:26 AM, PJ wrote: > Michael Dykman wrote: >> On Thu, May 21, 2009 at 11:06 PM, PJ wrote: >> >>> I have a seemingly impossible situation. I cannot insert values into the >>> tables and I cannot alter or delete the primary key (which should not >>> exist) or delete the for

Re: Date Time

Janek Bogucki wrote: Hi John, http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes some information about acceptable literal forms for dates and times. 'Thu May 21 03:15:28 + 2009' is not an acceptable literal form but this is how to parse it APART from the time zone com

Re: Stored Procedure Data Types

Hi, Use a temporary table to store the ids and join to it for the final update? That will at least avoid an error when the cursor selects zero records. Cheers, -Janek On Wed, 2009-05-20 at 16:05 -0400, W. Scott Hayes wrote: > Hello, > > I would like to do a select on a table to get back the IDs

Re: Date Time

Hi John, http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes some information about acceptable literal forms for dates and times. 'Thu May 21 03:15:28 + 2009' is not an acceptable literal form but this is how to parse it APART from the time zone component. I could not see

MySQL 6.0.11 Alpha has been released!

Dear MySQL users, MySQL 6.0.11-alpha, a new version of the MySQL database system has been released. The main page for MySQL 6.0 release is at http://www.mysql.com/mysql60/ 6.0.11 will be the last release of 6.0. After this we will be transitioning into a New Release Model for the MySQL Serve