--- "Keith C. Ivey" <[EMAIL PROTECTED]> wrote:
> On 21 Nov 2002, at 18:20, Hans Zaunere wrote:
>
> > > but as long as it's a DATETIME
> > > column then you are looking for a range of values, so 'range' is the
> > > best you'r
--- "Keith C. Ivey" <[EMAIL PROTECTED]> wrote:
> On 21 Nov 2002, at 15:18, Hans Zaunere wrote:
>
> > Because it seems ineffncient to me, as MySQL must be doing more work to
> > calculate the range. Even EXPLAIN tells me this, by showing that a
> > less-th
--- "Keith C. Ivey" <[EMAIL PROTECTED]> wrote:
> On 21 Nov 2002, at 14:38, Hans Zaunere wrote:
>
> > I've played around with a couple different methods, but the only way I
> can
> > see to use the INDEX (according to EXPLAIN) is doing a query along the
better;
although I'd think that DATETIME would be proper here.
Any insight into the "best way" to do this (ie paying attention to only the
date part of DATETIME during a straight comparison, while using the
advantages of a fast numeric index), or any alternatives, would be greatly
appr
I use the -lmysqlclient command line argument to gcc
under Linux. It compiles fine and everything works
great.
However, if I move the compiled binary to another
system, which doesn't have the mysql client libs
installed, when I try to start the program, I get:
error while loading shared librar
We have about 300,000 records currently in a MySQL
database. A new system has been built on Oracle, and
now we must migrate the data from MySQL to Oracle (I
know, it's not something I wanted to do.) What is the
best way to do this? Import into another database
(something like Access) then expo
Can someone explain to me when and when not to use
single, double, or no quotes at all around values in a
query. I noticed when I updating an enum field I
needed a quote, but not when updating an int field.
Or could someone point me to a good online reference
on the subject.
Thank you,
Hans
[
Is there a way to have MySQL label columns returned
from a select query with the complete column name, in
table.column format?
So if a column name is id, which is in the main table,
can MySQL return main.id instead of just id.
Sure I could alias each column, but if there is 30
columns, that's
--- Frank Fisher <[EMAIL PROTECTED]> wrote:
> I have an upcoming project which will require me
> doing a recursive
> function in PHP, doing a tree calculating optimum
> route between defined
> points in the database.
Maybe it's just me, but it sounds like you need to
reconsider you're databa
Is there a way to have MySQL label columns returned
from a select query with the complete column name, in
table.column format?
So if a column name is id, which is in the main table,
can MySQL return main.id instead of just id.
Sure I could alias each column, but if there is 30
columns, that's
> > And I was thinking, since a socket is a socket (just a file descriptor)
> NO - a socket is not a file descriptor,
> something like a communication end/handshake point
> read more
> http://orkinos.cmpe.boun.edu.tr/netlab/courses/cmpe476/netprog/SocketsFAQ.txt
>
Sure they are file descriptors,
> > > > my $dbh = connect("DBI:mysql:database:localhost", "user",
> "password");
Well I uncovered an interesting thing. If I use the regular old
bin/mysql client to connect to the database (both on the same machine)
and I run: ./mysql -uroot -p -h localhost
Then run netstat -an , it sho
nning
out of sockets or file descriptors. Do you know of any Linux kernel specific issues
that hinder the
use of a lot of local UNIX sockets. Any references/studies of the Linux kernel's
problems with this
sort of thing. Would it be better to just switch to TCP/IP sockets?
Thank you,
Ha
to
the server, which is the same as if I had to connect remotely? The above perl line is
called
from local scripts, executing from the perl interpreter via cron, and also in mod_perl
scripts,
running from Apache. These are essentially the same, correct?
Thank you
Hans Zaunere
[EMAIL PROTE
This link, http://www.mysql.com/doc/P/r/Problems.html is a life-saver. Check
out A.9 for your specific problem.
Hans
[EMAIL PROTECTED] wrote:
> I used mysqladmin to create a database and set the grant properties to
> root@localhost with the password, but now am unable to use mysql at all.
>
e for
additional questions/info.
Thank you,
Hans Zaunere
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thre
16 matches
Mail list logo
