Hi guys,
I have a query.I am not sure if this is a bug or a feature (ha ha
ha...).
Table - abc
name varchar(30),
address varchar(50)
Then I run this sql.
create table temp_abc as
select * from abc;
datatypes of the columns changes:
Table - temp_abc
name
What do you mean by optimization of the column? Are you saying that
char takes less space than varchar or the performance on char is better
in queries compared with varchar ?
The whole concept of CREATE AS is that you want target table to
inherit all the properties with the data of the
There are couple of ways you can do it.
1) You can use the following sql to find out duplicate rows and then
write few more sql to delete duplicate.
SELECT column(s), count(*)
FROM
table-a
GROUP BY column(s)
HAVING count(*) 1;
then massage the data with couple of more sqls.
2) This
Ken,
Thanks for your help. I got it working. For now I needed to reverse
engineer the database. The trickier part was the username and password.
I initially gave mysql login name. But actually you have to give either
DB owner or root.
Unfortunately we do not have support contract. Somebody
Has anyone got Erwin working with mysql. I guess all directly
non-supported DBs by Erwin are suppose to work via ODBC but I have not
been able to find ODBC driver (either generic or for mysql).
thanks
Vivek
-
Before
this behavior ?
2) Is there any way to monitor such a behavior ? any
commands, scripts that could test for inactivity etc.
Needless to say that I am a newbie on mysql front.
Vivek Chaudhary
Database Administrator
IT STMicroelectronics, Phoenix.
Phone:(602)485-2271
Fax
for inactivity etc.
Needless to say that I am a newbie on mysql front.
Vivek Chaudhary
Database Administrator
IT STMicroelectronics, Phoenix.
Phone:(602)485-2271
Fax: (602)485-6402
Cell:(602)363-1492
Email: [EMAIL PROTECTED
commands, scripts
that could test for inactivity etc.
Needless to say that I am a newbie on mysql front.
Vivek Chaudhary
Database Administrator
IT STMicroelectronics, Phoenix.
Phone:(602)485-2271
Fax: (602)485-6402
Cell:(602)363-1492
Email: [EMAIL PROTECTED
So far I have seen this feature in Oracle and DB2 alone. I am yet to
find any other RDBMS.
Vivek Chaudhary
-Original Message-
From: len [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 13, 2002 7:10 AM
To: mysql
Cc: len
Subject: Bill-of-Materials
Hello!
As a newbie