i configured mysql with
./configure --prefix=/usr/local --localstatedir=/usr/local/var
--with-mysqld-ldflags=-all-static --disable-shared
--with-unix-socket-path=/usr/local/var/mysql.sock --with-pthread
--enable-thread-safe-client --with-mysqld-user=mysql --without-debug
On Thu, Aug 23, 2001 at 07:21:10PM +0200, Gregorio Ramón Alberdi Díaz wrote:
A query with a ORDER BY clause over a numeric field, will be fast if
this field have a index or this doesn't influence the anwer time of
the query.
MySQL is going to prefer an index on the column(s) used in the
Hi all,
Having ditched yesterday's attempts to get MySQL up and running with PHP I'm
trying again from scratch.
I'm currently downloading the 3.23.27-1 rpm's from ausmac.net. Theye are:
'db engine', client, devel, shared, bench (should I also download and
install the xmbase-grok as well.
In
Sorry, one more thing occurred to me. Should I install these in any
particularorder?
George
- Original Message -
From: George Pitcher [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 24, 2001 7:37 AM
Subject: installing mysql - what should go where [linuxppc]
Hi all,
On Thu, Aug 23, 2001 at 07:54:38PM +0200, Osus wrote:
[snip]
when I run this query
mysql explain select Nick from mytable where Inicial='P' AND Sexo=1 and
ok=1;
.
+--+--+---+-+---
--+---+--++
| table|
On Thu, Aug 23, 2001 at 01:50:36PM -0700, Angel Behar wrote:
Hi !!
I'm trying to compile mysql-3.23.41 on a FreebSD 3.3 box but I can't
I'm using latest gnu make version and this is the first time that I
have problems compiling mysql so if any of you can help me I'll
appreciate.
Martijn Rotteveel schrieb am Freitag, 24. August 2001, 00:21:53:
i need a SIMPLE method for performing some pre defined actions on my tables,
these actions involve retrieving strings, recombining them and inserting
into another table.
I don't know exactly what you mean, but if I do, I
On Thu, Aug 23, 2001 at 06:55:42AM -0700, xiyuan qian wrote:
Hi, I am running mysql-3.22.27 for many months. But today, the
mysqld always core dump. The running platform is FreeBSD3.4.
I checked the dumped core and find that it seems that the core dump
has something with the
does anyone know how i might be able to create a random number between 0 and
100 using java? using the number in my database.
thanks,
Kit
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Hi,
I want to write a program with VB in win98 box and connect to mySQL in
Linux. I think the only way to do is to connect thru ODBC with myODBC. But
with using ODBC, all ID password is given when setting up the DSN. And
this means everyone using this computer could access the mySQL server
Hi,
look at the latest patch:
http://www.innodb.com/bugfixes.html
Dvoek Michal wrote:
i configured mysql with
./configure --prefix=/usr/local --localstatedir=/usr/local/var
--with-mysqld-ldflags=-all-static --disable-shared
--with-unix-socket-path=/usr/local/var/mysql.sock
I have a problem
I'd like two instance of mysql on same machine
but informations about installation are pour, because
it's not clear which method have to follow for correct
installation.
In fact the script which I have to modify is mysql.server,
but exist the option file for each server called
Hi every body
I want to know if there is some easy way to duplicate an entire row, in one
table, only
changing one field?
Somethig like this,
this is the original table:
+---+-++-+
| ReleaseNumber | ReleaseDate | PrositeVersion
Hi all,
Yes, its me again. I've re-installed the MySQL-3.23.27-1 packages in this
order:
DB Engine (included shared files as it then told me that the -shared- pkg
was already installed)
client (must be installed before devel)
devel
Didn't install bench (should I?)
I still can't seem to find
plase help, i'm trying compile mysql 3.23.41 on Linux RH 7.1 kernel 2.4.9 gcc 3.0
with CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions
-fno-rtti ./configure --prefix=/usr/local --localstatedir=/usr/local/var
--with-mysqld-ldflags=-all-static --disable-shared
try driver vbmysql.dll at www.icarz.com/mysql/index.html
SF
At 16:00 24/8/2001 +0800, Jason Kwok wrote:
Hi,
I want to write a program with VB in win98 box and connect to mySQL in
Linux. I think the only way to do is to connect thru ODBC with myODBC. But
with using ODBC, all ID password
Hi,
I am a relatively new user of mySQL. I have written a program that uses JDBC
to access a mySQL database. I seem to find no other ResultSet metadata
statements other than ResultSet.getMetadata().getColumnName(1),
ResultSet.getString(1) etc and stuff.
I can use ResultSet.getRow() though
Hi!
Does anyone know the correct tag sequence to produce Mailing labels with
the 1.7.5.1 version of mysql, I try every wich way to produced them, but
I had to resort to export the data to excell or word in order to produce
them.
Bruno
ok, I'm not 100% sure about this but I've had what I think may be a similar
prob trying to get MySQL working with a radius server - header files and
shared libraries not being found by the radius server compile.
I _THINK_ its because when you install from a rpm of the binary you don't
get the
Ron DeAngelis writes:
main.cc: In function `void if_conn()':
main.cc:464: no matching function for call to `MysqlConnection::clinet_info
()'
main.cc:529: no matching function for call to `MysqlConnection::clinet_info
()'
make: *** [main.o] Error 1
I am using mysql++-1.7.9, and do not
Trond Eivind Glomsrød writes:
Peter Zaitsev [EMAIL PROTECTED] writes:
I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
somehow does not work with the following diagnose:
It builds just fine with glibc 2.2.4 on a current development version
of Red Hat Linux
Peter Zaitsev writes:
Hello Trond,
Thursday, August 23, 2001, 8:01:33 PM, you wrote:
Yes. I'm shure it builds OK then glibc is installed as standart.
I'm having a system with glibc 2.2.0 and trying to compile MYSQL with
glibc 2.2.4 laying in a special directory. But if fails. The
Hi
How can I turn off the error displaying ...
sometimes when the script could not connect to the DB or in fact I do not
want to show these Errors at all
OK for things like MYSQL_CONNECT or MYSQL_SELECT_DB I use OR DIE
but what can I use for query's inside of other select's ...
I can't
Martijn Rotteveel writes:
Hi all,
i need a SIMPLE method for performing some pre defined actions on my tables,
these actions involve retrieving strings, recombining them and inserting
into another table.
i thought about MySql++, but is there a simpler way to accomplish this kind
of
table a has ak1 and ak2 as primary key
table b has bk1 and bk2 as primary key
how do I join these tables?
if i write
where a.ak1 = b.bk1 and a.ak2 = b.bk2
data are returned multiple times.
/AM
-
Before posting, please
Hi,
I've read http://www.mysql.com/doc/L/i/Linux.html, and I want to build glibc 2.2.4 on
RedHat 6.2 and Slackware 7.1 (currently 2.1.x glibc's).
My question : how to build a glibc for MySQL-only, as recommended ? Thus, howto dump
it in some directory, and use it in the build process ? Also,
[EMAIL PROTECTED] schrieb am Freitag, 24. August 2001, 13:43:15:
table a has ak1 and ak2 as primary key
table b has bk1 and bk2 as primary key
how do I join these tables?
if i write
where a.ak1 = b.bk1 and a.ak2 = b.bk2
data are returned multiple times.
Well this should be. You should
But also consider, if you don't want to ask for
select
subject,subhead,subsubhead,data2,data3,see_also
from npl_detail
where (subject like '% asia %'
AND NOT subject like '%winter%')
OR
cut
ORDER BY
subject, subhead,
Dave,
DROP DATABASE for InnoDB type tables is in my
TODO list for August, and I am determined that
the September distribution will have it implemented.
But meanwhile, if you accidentally lose the .frm file
of your table, but the table still exists inside InnoDB,
you can use the following trick
Hi,
I am a newbie that has a question about what exactly is myODBC (for Unix)
doing. Is myODBC, 1) a wrapper over the mySQL database to make it conform
to the ODBC interface or 2) a plug-in driver that goes with a manager
program to allow the access of mySQL db? I am using an Irix
I know what you can do if you use php: prefix the function in
question with @, that will turn errors off. Example:
@mysql_connect(
instead of
mysql_connect(
Christian Eichert schrieb am Freitag, 24. August 2001, 12:47:55:
Hi
How can I turn off the error displaying ...
sometimes
Please tell us some details: what are your tables, which program
shall actually produce the labels etc.
A database holds data. If you manage to get them and stuff them
into Excel or Word, that sounds fine to me. How would you like to
do it?
Bruno Perozzo schrieb am Freitag, 24. August 2001,
Date: Thu, 23 Aug 2001 17:39:14 +0100
To: [EMAIL PROTECTED]
From: Lindsay G Mccracken [EMAIL PROTECTED]
Trying to do a set difference,
select * from staff where NOT IN (select * from Supervises where Role='0' );
Can't seem to get it to work, is there a different way of doing this in
In my understanding, myODBC is a middleware for programs which
don't know how to deal directly with mySQL. So if you use perl or
php, you won't ever use ODBC, as this only slows things down,
obviously. ODBC is kind of a workaround in my understanding.
Please correct me, if I'm wrong.
Wen Tien
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Network [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, August 22, 2001 3:08 AM
Subject: Re: replace/insert into ... 150,000 -plus rows
I'll not trust this task to anyone other than myself.
Then why are
I think this is a subselect and not supported yet - read on
subselects in the manual; I did a search and here we are:
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
Lindsay G Mccracken schrieb am Freitag, 24. August 2001, 15:02:11:
Date: Thu, 23 Aug 2001 17:39:14 +0100
To: [EMAIL
Would someone explain what is going wrong here.
obviously I'm not understanding something.
If the next query searches for patterns at the beginning of the string in a
column
mysql select count(*) from a where addy1 not regexp
'^(apt)|^(rm)|^(room)|^(ste)|^(suite)|^(fl)|^(floor)';
+--+
|
At 9:24 AM -0400 8/24/01, Network wrote:
Would someone explain what is going wrong here.
obviously I'm not understanding something.
If the next query searches for patterns at the beginning of the string in a
column
mysql select count(*) from a where addy1 not regexp
Dear all,
I have the following problem with load data... Please excuse layout, but the
linewidth is just too short
// ---
// Here is my table definition
// ---
mysql desc customer;
Hi,
I am using the INTO OUTFILE 'filename' function, to create .CSV output files
from my queries.
Whenever I do this, the table headings are removed from the output. Is
there a way to get the table headings displayed in the output file?
Andrew
Hi all,
I'm getting closer and closer to having MySQL/PHP/Apache set up on my
LinuxPPC box.
Now, I haven't been sitting twiddling my thumbs while I was waiting. Instead
I was building a database on MySQL on NT.
I would like to move this to Linux asap. There are 6 tables with between 8
and 40
41 matches
Mail list logo