> Is it possible to connect a database two times
> simultaneously with the C-API?
works...
just wrote a bug with a pointer
sry for posting
Robert
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Is it possible to connect a database two times
simultaneously with the C-API?
I always get a segfault when connecting a second
time.
I need this because I want to feed a second table
with data processed within a mysql_use_result
fetch. I can't use mysql_store_result, because the
result set is
mysql> SELECT weekday, count(weekday) AS number FROM data WHERE type='x'
GROUP BY weekday ORDER BY weekday ASC;
+--++
| weekday | number |
+--++
| monday | 14 |
| thursday | 28 |
| friday | 44 |
| saturday | 13 |
+--++
4 rows in
I've had the same problem once.
Reading the manual I found out that MySQL is not SQL conform
and does not support sub-selects.
You'll have to rewrite the statement that you don't need a sub-select
or if not possible create a temporary table.
Regards,
Robert
- Original Message -
From: "B
I haven't installed mysql from the scratch, but used a precompiled
version that comes with my distribution. Since I've updated it
I see some *-bin.* files grow steadily very huge.
What are these files in my /var/lib/mysql directory good for?
Some kind of journalling for replication?
Do I really
