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 would
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
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:19 AM
Subject: Re: alter table syntax
In the last episode (Dec 06), kayamboo said:
When I tried to drop
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)
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
kayamboo,
Friday, D
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 an SQL
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 somewhere
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 |
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
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 12/5/02 10:31 PM, kayamboo [EMAIL PROTECTED] wrote:
sql, mysql, query
Hello folks
This is my table
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
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
12 matches
Mail list logo