bobgoodwin wrote:
I am running MySql 4.1.6 in FC-4 Linux amd it is a huge learning
exercise for me!
I am using O'Reilly's MYSQL Cookbook, have gone through numerous
pages of the "reference manual" and stuff on Google but still can get
the proper commands and syntax to alter the following
I am running MySql 4.1.6 in FC-4 Linux amd it is a huge learning
exercise for me!
I am using O'Reilly's MYSQL Cookbook, have gone through numerous pages
of the "reference manual" and stuff on Google but still can get the
proper commands and syntax to alter the following table "T1."
I wou
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Cc: "list mysql" <[EMAIL PROTECTED]>
Sent: Monday, December 09, 2002 2:06 AM
Subject: Re: alter table syntax
> In the last episode (Dec 09), k
Thanks for the suggestions.
It worked fine
regards
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 06, 2002 11:36 PM
Subject: re: Re: alter table syntax
> kayamb
In the last episode (Dec 09), kayamboo said:
> I don't get you.
> But when I executed the drop table syntax fromt he command line, the result
> was this error
>
> mysql> alter table town_db drop primary key ;
> ERROR 1025: Error on rename of '.\forest\#sql-cc_1' to '.\forest\town_db'
> (errno: 150
an you make me clear?
regards
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Cc: "list mysql" <[EMAIL PROTECTED]>; "R. Hannes Niedner"
<[EMAIL PROTECTED]>
Sent: Saturday, December 07, 2002 2:
kayamboo,
Friday, December 06, 2002, 9:15:04 AM, you wrote:
k> When I tried to drop the key, this was the error
k> mysql> alter table town_db drop primary key ;
k> ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to '.\forest\town_db'
k> (errno: 150)
k> I suppose some lock in the index somew
In the last episode (Dec 06), kayamboo said:
> When I tried to drop the key, this was the error
>
> mysql> alter table town_db drop primary key ;
> ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to '.\forest\town_db' (errno:
>150)
And what does "perror 150" return (it's a shell command, not
R. Hannes Niedner" <[EMAIL PROTECTED]>
To: "MySQL Mailinglist" <[EMAIL PROTECTED]>
Sent: Friday, December 06, 2002 3:50 PM
Subject: Re: alter table syntax
> ALTER TABLE town_db1 DROP PRIMARY KEY;
> ALTER TABLE town_db1 ADD PRIMARY KEY(town, subcity );
>
> On
ALTER TABLE town_db1 DROP PRIMARY KEY;
ALTER TABLE town_db1 ADD PRIMARY KEY(town, subcity );
On 12/5/02 10:31 PM, "kayamboo" <[EMAIL PROTECTED]> wrote:
> sql, mysql, query
>
> Hello folks
>
> This is my table structure with MySql 4.0.3-beta-max-nt with InnoDB
>
> +-+--+
sql, mysql, query
Hello folks
This is my table structure with MySql 4.0.3-beta-max-nt with InnoDB
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+---
Gary,
Monday, February 18, 2002, 2:30:03 PM, you wrote:
GP> I've read and re-read the manual and searched mailing list archive and still
GP> can't see what is wrong with this statement - I'm sure someone can put me
GP> out of my misery ! I'm simply trying to move the position of the Cat2
GP> col
I've read and re-read the manual and searched mailing list archive and still
can't see what is wrong with this statement - I'm sure someone can put me
out of my misery ! I'm simply trying to move the position of the Cat2
column.
mysql> alter table bollinks3 change Cat2 Cat2 smallint(5) unsigned n
13 matches
Mail list logo
