-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I was wondering if anyone knows of a module for perl to talk to mysql w/o
DBI/DBD. Some sort of shell interface or something.
Mike.
- --
*
* Mike Baranski *
* Security Managment Consulting *
* 919
On Saturday 21 July 2001 00:28, Jeremy Zawodny wrote:
> On Thu, Jul 19, 2001 at 03:15:02PM -0500, Tom Wheeler wrote:
> > Our two most important requirements for the database engine are
> > speed and scalability. We will be inserting probably 5,000,000
> > records per day into our database
>
> Sou
Read the man page for gcc and note the command line switch to point the
linker at specific libraries, then use those switches on the command line.
This is a linker error, rather than a compiler error:
Example:
g++ myGreatProgram.cpp -L/usr/mysql/lib -lmysqlclient
On Wednesday 18 July 2001 1
On Wednesday 18 July 2001 13:32, you wrote:
> I recently got into a discussion with a colleague that was interesing. He
> is a database warehouse guy, so I assume he knows more than I do on this
> subject, but he was unable to explain things to me very well :)
>
> The question is how does mysql o
Did you build PHP with mysql support, and are you requring the mysql/php
module in your program, something is not set up correctly.
On Wednesday 18 July 2001 11:01, Rick Makla wrote:
> What can I do to fix this error or can you referance me to a point where
> I can look at to try to fix the prob
Just go (in windows explorer) to view->optoins, and uncheck hide extensions
of known file types, and the extensions will show up. You can also
un-associate it through this.
On Tuesday 17 July 2001 15:47, Dinkler, Fred wrote:
> Problem under Win2000 with any file having a .cnf extension.
>
> Th
On Tuesday 17 July 2001 15:44, Colin TMC wrote:
> I am moving from MS SQL to mySQL, Can anybody know how to create and grant
> rights for a new user except of root?
>
> Thanks!
>
>
> -
I know a lot of you don't believe it, but thi
It'll compile for you, jump between error
messages, auto save files, all without leaving the keyboard. I
realize that vi does some of the same stuff, but emacs is to vi what
an RV is to a bicycle...
MWB.
- Original Message -
From: "Mike Baranski" <[EMAIL PROTECTED]&
It'll compile for you, jump between error
messages, auto save files, all without leaving the keyboard. I
realize that vi does some of the same stuff, but emacs is to vi what
an RV is to a bicycle...
MWB.
- Original Message -
From: "Mike Baranski" <[EMAIL PROTECTED]&
Also, if you want the real deal, go get emacs, either at
http://xemacs.org
or http://www.gnu.org
It's the best (no flames here), but has a pretty steep learning curve.
-- Original Message --
From: "Steve Brazill" <[EMAIL PROTECTED]>
Reply-To: "Steve Brazil
>
>
>But this fails.
>
>
>
>
>I am not a SQL guru, and would appreciate any help
>
>
>Rob
>
>
--
\\|//
(@ @)
---oOO---(_)---OOo
|
Is there any way to flush all insert delayed tables at once, with 1 command?
--
\\|//
(@ @)
---oOO---(_)---OOo
||
| Mike Baranski |
| Security Managment Consulting |
| http
Question about this, when I do mysqladmin processlist, I get Repair with keycache as
the state, what exactly is this? Can this be optomized?
Mike.
P.S. Thanks for the gcc3 patch!
-
Before posting, please check:
http://www
Does mysql++ work any better with gcc 3.0 than it did with 2.96 (The RedHat "release"
(I use the term loosly)).
M
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Well, you could also use these switches with the rpm command:
--prefix
This sets the installation prefix to for
relocatable packages.
--relocate =
For relocatable packages, translates the files that
would be put in to
Can't you set that in the my.cnf file, the data directory?
Mike.
-- Original Message --
From: Trond Eivind Glomsrød <[EMAIL PROTECTED]>
Date: Wed, 11 Jul 2001 16:25:52 -0400 (EDT)
>On Wed, 11 Jul 2001, Mike Baranski wrote:
>
> Mine
iable will speed this process up? I can allocate some more
memory for this type of thing, I just need to know where...
Thanks
Mike B.
--
\\|//
(@ @)
---oOO---(_)---OOo
||
| Mike Bar
inor >technicalities!
>
>Many thanks in anticipation
>
>Sara
>
>
--
\\|//
(@ @)
---oOO---(_)---OOo
||
| Mike Baranski
ld include this...
-- Original Message --
From: Gerald Clark <[EMAIL PROTECTED]>
Date: Wed, 11 Jul 2001 14:36:20 -0500
>I am sure you can change the base if you can compile it.
Have you verified that the relocated RPM install works properly?
I have n
I was wondering if anyone had any suggestions on the following problem. I have a
table with about 7 million rows, and I'm using the following join:CREATE TABLE
badge_history_resolved SELECT badge_history.id AS id, badge_history.xact_date AS
xact_date, badge_history.xact_time AS xact_time, badg
The explain result (product of rows) is less than 200,000. I'll include it here, but
I don't know if it's readable or not:
++++---+-+--+---+--
Dear Sirs,
We have a very large database (badge_history has > 4,000,000 rows) and the
explain for our query looks like this:
By using indexes for a query, the product of the row estimates from an
explain statement are less than 200,000. The problem is that this query
times out. There is only
Thanks for the advice last time folks, I think that one's working.
Here's a tougher query, any ideas on how to speed this one up:
SELECT DISTINCT badge.last_name AS last_name, badge.first_name AS
first_name, badge.bid AS bid, badge.employee AS employee,
badge_type.description AS type, badgests.co
For the following select:
SELECT DISTINCT badge_history.xact_date AS xact_date,
badge_history.xact_time AS xact_time, badge_history.last_name AS
last_name, badge_history.bid AS bid, badgests.cond_desc AS status,
department.description AS department, badge_history.reader_desc AS
reader_desc, area.
I seem to be having a problem on linux with the mysql c api hanging sometimes when I
try to make 2 connections in a threaded program, with p threads. It's redhat 7 box,
and it is an intermittient problem. Sometimes it works great, and sometimes it hangs
on the second connection. Anyone know
I've got the following file on RH Linux 7.0:
#include
#include
int main()
{
MYSQL mysqlConnection;
mysql_init(&mysqlConnection);
mysql_options(&mysqlConnection,MYSQL_READ_DEFAULT_GROUP,"Finance Manager");
if (!mysql_real_connect(&mysqlConnection,"localhost","root"
This gives me a seg fault, I know I have the correct user/pw, but I can't get the
thing to run past "First", any ideas why the connect is not working properly?
#include
#include
#include
void main()
{
string dbname = "test2";
string hostname = "localhost";
string uname = "mike";
27 matches
Mail list logo
