ourse, you can't return a pointer to buff in this case. if you want
to return the argument you will have to allocate memory in _init and
pass it along in initid->ptr which then could used instead of buff etc.
cheers,
--
Murad Nayal M.D. Ph.D.
Department of Biochemistry and Molecular Bi
; >>
> >> [EMAIL PROTECTED] mark]$ mysql -u mark -ppassword
> >> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
> >> YES)
the user mark has permissions to access only the marksstuff database.
but you're not specifying the dat
?
if so is there any way to insure that rows retrieved are returning in
the order by were inserted in, say other than ordering by some
'insertion counter' (such a counter is of no use otherwise in my
application!).
thanks for the help.
--
Murad Nayal M.D. Ph.D.
Department of Bioche
Hello,
from the InnoDB documentation
"To be able to recover your InnoDB database to the present from the
binary backup described above, you have to run your MySQL database with
the general logging and log archiving of MySQL switched on. Here by the
general logging we mean the logging mechanism
Hello,
This actually brings up a question I've been meaning to ask.
from the InnoDB documentations
"To be able to recover your InnoDB database to the present from the
binary backup described above, you have to run your MySQL database with
the general logging and log archiving of MySQL switched
Hello,
I experiencing a problem I hope someone here can help with:
I have several C-coded clients running and performing inserts and
updates on a database. I would like to make sure that the -entire-
client session is atomic. i.e. if a client dies in the middle of the
computation (not uncommon)
Hi all,
I am in the process of planning for the construction of a very large
database and I wanted to do a reality check before hand. in this
database a typical table would be 100,000,000 rows and some tables could
be as large as 100 times that, 10,000,000,000. I am wondering:
1- is it possible
thank you all for the help!
best
Murad
Dan Nelson wrote:
>
> In the last episode (Mar 14), Murad Nayal said:
> > how can I force mysql interactive client (actually the client library as
> > well) to use a TCP port on the local host
> >
> > if I do:
> >
>
Hello,
how can I force mysql interactive client (actually the client library as
well) to use a TCP port on the local host
if I do:
mysql -h localhost -u user -p --port=2000
I get:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock'
what might be a problem is: i
Thanks a lot Walt,
do you happen to have any code examples/fragments handy you can share?
thanks again
walt wrote:
>
> Murad Nayal wrote:
>
> > Hello,
> >
> > I wonder if anyone has encountered this problem before and has any
> > ideas. I need to run prog
Hello,
I wonder if anyone has encountered this problem before and has any
ideas. I need to run programs on a linux cluster that make client
connections to an mysql database on a different server. this linux
cluster is set up where only the main node has an internet connection.
so the problem is
I think i found a way to do this: in case anybody is interested:
select customer from purchases group by customer having sum(case when
purchase = 'freezer' then 1 else 0 end) = 0;
I am finding that SQL is trickier (and more powerful) than I thought
originally!!
Murad Nayal wrote:
&
Hello Stefan,
thanks for the feedback. I think I probably misstated my problem. I just
emailed a more explicit example of the sort of thing I am trying to do.
for the sake of completeness I'll reproduce it here:
table
id customer purchase
1 c1 microwave
2 c1 car
3 c1 freez
FROM table1 t1 LEFT OUTER JOIN table2 t2 ON t1.field1=t2.field2
> WHERE t2.field2 IS NULL
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]] On Behalf Of Murad Nayal
> > Sent: Monday, December 09, 2002 11:38 AM
> > To: M
Hello all,
I need to run query like (in mysql < ver.4):
select * from table1 as t1 where not exists (select NULL from table2 as
t2 where t1.field1 = t2.field1)
I know you can emulate an 'exists' subquery with a join. but I just
can't think of a way to emulate a 'not exists' without a subquery.
ement such function.
many thanks
Murad Nayal
-
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 P
Alan McDonald wrote:
>
> You can't count the join?
> Alan
if you count the (unqualified) join you'll end up with the product of
the two table counts.
Murad
>
> > -Original Message-
> > From: Rick Baranowski [mailto:rickb@;baranconsulting.com]
> > Sent: Wednesday, 13 November 2002 12:
sible' SQL query!
in any event, I am still new to SQL. please correct me if I'm wrong.
Murad Nayal
Charlie wrote:
>
> Thanks for the reply, but it isn't quite what is needed.
>
> The problem is that I need all the records between the two occurances of
> identical value
thanks jeremy for the reply
Jeremy Zawodny wrote:
>
>
> >
> > any idea why is it that the mysqld daemon is not using the CPUs and/or
> > why is this taking so long??
>
> You might benefit from a larger key buffer.
>
> Can you show us the output of "vmstat 1" for 10 or 20 seconds?
>
What woul
Hello,
I am struggling trying to optimize the performance of mysql over rather
large databases. for now there is one issue I don't understand and I am
wondering if anybody can help with any hints.
I am trying to create an index for a large table (100,000,000 rows). the
index is for a column of
20 matches
Mail list logo
