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
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
A.id_job2 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
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
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
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
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 ! sql query "insert into dbase
values ('@qfield1', '@qfield2'...).
2.I need to split query results in multiple pages (e.g. with a next
button) so that my