innodb problem

[matteo . pozzi]

Hello, my name's Matteo, probably my question
is basic but I'm new with mysql.
I've an application that write some milion of row in mysql innodb
table. Every day my application creates a new table, write data
and drop table oldest than 15 days.
After the drop table execution command the disk space on my linux server

doen't shrink and the disk space grow winthout end.
is there a way or configuration setting to resolve this problem?

Many thanks if someone can help me!!!

 Best regards, Matteo







--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL and ADO:Bug?

[Matteo Ferrari]

Hi, I have been trying for 4 days but I can't solve this problem and I
don't know why.
It's a bug?

I have a table (children) which has a field called borough; I have to
extract the sum of the children of each borough so I use this simple
query:

select count(*) , borough from children group by borough order by
borough

that works.

If I try to call this query from a VB6 project it doesn't work, that is,
it returns an empty recordset.
This is the code that I'm using


Dim rec As ADODB.Recordset
Dim cnn As ADODB.Connection
Dim cmd As ADODB.Command

Dim GlConnString as String
Dim strSQL As String

Set rec = New ADODB.Recordset
Set cnn = New ADODB.Connection
Set cmd = New ADODB.Command

strSQL = select count(*) , borough from children group by borough order
by borough

GlConnString =
"server=localhost;db=MyDB;driver={MySQL};uid=root;pwd=MyPwd;OPTION=35"

cnn.CursorLocation = adUseClient

cnn.ConnectionString = GlConnString

cnn.Open

cmd.CommandType = adCmdText

cmd.CommandText = STRsql

Set cmd.ActiveConnection = cnn

Set rec = cmd.Execute

---at this point I have an empty recordset
If I try with this query
select borough from children group by borough order by borough
that is, removing count(*) works!

I'm using
Windows 2000
MySQL 3.23.49
MyODBC 2.50.39
ADO 2.52.6019.1

Help me, please!
Thanks
Teo







-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

instead of subquery?

[Matteo Ferrari]

Hi.
I have this table (A)

IDJOB ¦ IDKIT

  4 ¦  19   
  4 ¦  19 
  2 ¦  19 
  2 ¦  5

I need to extract IDKIT with IDJOB<>2 if and only if IDKIT <> IDKIT when
IDJOB=2
In this case my query should return null
With a subquery I can do this and it works

SELECT idkit from A where A.id_job<>2 and A.id_kit not in  (select
A.id_kit from A where A.id_job=2)

Anyone could suggest how I could do this in mysql without subquery?

Thanks in advance

Matteo

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Bug MySQL?

[Matteo Ferrari]

Hi
I'm trying to extract data from 2 tables (A and B) with a subquery

A has the fields (ID_person, name)
B has the fields (ID_person,ID_country)

This is my query

select *
from A
where A.id_person IN (select B.id from B where B.ID_country =7)

But I receive a message error.
If I try to run each single query separately they work.
The subquery returns (for example) 1 and if I write

select *
from A
where A.id_person IN (1)

it works.
The strange thing is that if I try to run the subquery with Access or
SQL with SAS it works!
It is a bug?
I wait for your answer.

Thanks
Matteo


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Compiling Mysql++-1.7.9 on Linux with GCC 3.0

[Matteo Limonta]

Hi boys,

I have a problem when I make mysql++-1.7.9 API with gcc 3.0.
Can somebody help me, where is the problem ?
Is mysql++-1.7.9 compatible with the last ANSI/ISO C++ rules ?


Matteo Limonta




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL and MyODBC

[Matteo]

Hello to all,

i'm developing a software in V.b.6 based on MySql d.b.
Early i'll need to create a package in order to install this software.
So, i need to know if i must to include, into the packege, only d.b.
files and the ODBC or i must the install the complete version of
MySQL.

Another little question... If it's necessary only the ODBC, i must install
them by the set-up downloaded from the site or can i copy and register
the dll of ODBC?

Thank you in advance.

Matteo.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Two query issues -- need help

[Matteo Dell'Orto]

Hi all, I have two little problems:

1.In a query, I get errors when a record's field contains the '
character. In fact the query starts like