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 s
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 char(30
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 wa
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 p
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 posting,
the daemon and restarted and everything was OK.
> My questions:
> > >
> > > 1) What could cause this behavior ?
> > > 2) Is there any way to monitor such a behavior ? any
> > > commands, scripts that could test for inactivity etc.
> > >
> > > Needless to
y 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
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
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
>
