Dear Sir,
I am working at a project developed by using MySql to store various information. The
program is written on VC++6.0 paltform.
I met with a problem that the program using mysql_init function to call mysql can't
be interrupted by ctrl - C. The program can only be interrupt by ctrl_
"Some suggestions have been to recreate the tables and indexes using the
64bit binary on the opteron system."
I'm confused - are you running the 32-bit binary, or the 64-bit binary?
David
- Original Message -
From: "Santiago Flores" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday
I'm just curious.. what kind of application(s) are you hosting in such a
server???
"Santiago Flores" <[EMAIL PROTECTED]>
26/09/2003 11:50 a.m.
To
<[EMAIL PROTECTED]>
cc
Subject
Mysql 64 bit vs. Mysql 32bit
Hello. We recently aquired a dual Opteron system to run mysql on. We were
previ
hi, just donwloaded mysql and connector/j. the driver seems to work fine
for simple stuff. but i can not get all of the tests to run (please see
typescript below).
ant test give ms a :Overriding previous definition of reference to
non.test.sources
the perf tests seem to be missing.
has anyone
Hi,
Table order can definitely make a difference in the order that MySQL
actually reads them. Like if MySQL *thinks* the cost to join 2 different
tables is equal, it will use the one that's listed first, first. But if
you know the cost is different and change the table order, it can help
the optim
Hi,
- Original Message -
From: "Roman Neuhauser"
Sent: Friday, September 26, 2003 6:05 PM
Subject: Re: FOREIGN KEY Weirdness in mySQL 4.1 with VARCHAR
> # [EMAIL PROTECTED] / 2003-09-26 15:12:03 -0700:
> > --- Harald Fuchs <[EMAIL PROTECTED]> wrote:
> > > Ed Smith <[EMAIL PROTECTED]> wri
Could anyone tell me how to configure MySQL to apply openssl in win32 platdform?
I have tried --with-vio --with-openssl but it seems doesn't work.
FYI, I manage to compile openssl with Perl and VC++. But when I use show
variables have_openssl to check the status, it still return me no.
Details in
In the last episode (Sep 26), David Griffiths said:
> - Original Message -
> From: "Mike R. Duncan" <[EMAIL PROTECTED]>
> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, September 25, 2003 2:55 PM
> Subject: RE: Ideas on cre
SELECT count(*)
FROM commercial_entity, country, user_account, address_list
LEFT JOIN state_province ON address_list.state_province_id =
state_province.state_province_id
LEFT JOIN contact_info ON address_list.contact_info_id =
contact_info.contact_info_id
WHERE address_list.address_type_id = 101
AN
Hi
At 11:07 26/9/2003 -0300, Luiz Rafael Culik Guimaraes wrote:
>Dear Friends
>
>where i can find an mysqlclient.lib compiled for borland compiler
thansk, but for libmysql.dll i created then import lib, but still asking for
function inside mysqlclient.lib
Regards
Luiz
---
Outgoing mail is ce
# [EMAIL PROTECTED] / 2003-09-26 15:12:03 -0700:
> --- Harald Fuchs <[EMAIL PROTECTED]> wrote:
> > Ed Smith <[EMAIL PROTECTED]> writes:
> > > Greetings. When I execute the SQL script below in
> > > mySQL 4.1, I get
> >
> > > ERROR 1216: Cannot add or update a child row: a foreign key
> > > constr
IMO, this is a bug in mySQL. It's fine to convert to
fixed to variable length under the hood; however, it
should not impact implementation.
What's the best work around for this "feature"? It
looks like I will be forced to change my enroll to use
VARCHAR. I shouldn't have to do this to make it w
Has anybody out there used sas as a frontend of MYSQL. It is a great
datamanagement and statisics program, but it seems to have a few
problems dealing with mysql.
One, it really wants to use cursors (which mysql doesn't support yet)
but thats fine. In the absence of that when you set mysql as a
-->-Original Message-
-->From: Robert Hamel [mailto:[EMAIL PROTECTED]
-->Sent: Friday, September 26, 2003 1:41 PM
-->every 5mins or so. We have a process to remove the bin-logs but I
was
-->wondering if it would be safe to remove entries or even rotate the
bin
-->log index. E.g. copy the e
We have 7/24 replication configuration that is generating 5M bin logs every 5mins or
so. We have a process to remove the bin-logs but I was wondering if it would be safe
to remove entries or even rotate the bin log index. E.g. copy the existing bin log
index to filename.0 then echo "" > bin-log
Heikki,
Great! Thank you!
Regards,
Eduardo
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 26, 2003 4:31 PM
Subject: Re: Multiple tablespace + subqueries
> Eduardo,
>
> - Original Message -
> From: ""Eduardo D Piove
Eduardo,
- Original Message -
From: ""Eduardo D Piovesam"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, September 25, 2003 10:45 PM
Subject: Multiple tablespace + subqueries
> Hello all,
>
> We want to use MySQL (InnoDB) for a corporate/non-stop environment, b
>Description:
bin/mysqld_safe --user=mysql fails with the following error
(from data/host.err file)
030925 10:58:58 mysqld started
030925 10:58:59 InnoDB: Started
030925 10:58:59 Fatal error: Can't open privilege tables:
Out of mem
I get this:
/usr/local/mysql/bin/mysqld_safe: line 342: 23172 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD
$defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR
$USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1
When attempting to do:
Select n from table.n where field1='x'
I have recently re-entered the job market and I was wondering if anyone has
found that having certification really helps in landing a position. If so,
which cert do you have?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/
# [EMAIL PROTECTED] / 2003-09-25 14:59:33 +0100:
> CREATE TABLE `pheno` (
> `id` smallint(5) unsigned NOT NULL auto_increment,
> `relevant` enum('y','n') default NULL,
> `phenotype` varchar(50) NOT NULL default '',
> PRIMARY KEY (`id`,`phenotype`),
> KEY `id` (`id`),
> CONSTRAINT `0_12
Hello. We recently aquired a dual Opteron system to run mysql on. We were
previously using a dual Athlon MP system. We have encountered the following
issue. We have a script that updates records in some rather large tables.
This script runs more slowly on the opteron system than on the athlon
syste
hi
i am trying to follow the steps in installing mysql
database. i should to install the , mysql package
(binary) under /usr/local/. i tried the commad
rpm -i --prefix=/usr/local/
MYSQL-server-4.0.15-i386.rpm MYSQL-client-4 (do not
remeber the name).
when i execute i get "NOKEY, keyid 5072e1f" wh
I have a query that is pulling user comments, supplied by via web
internface and creating a text file out of them. In these comments are all
sorts of carrige returns. I've tried stripping them out with the following
queries, but once imported into excel, the carrige returns are still there.
so ob
At 11:07 26/9/2003 -0300, Luiz Rafael Culik Guimaraes wrote:
Dear Friends
where i can find an mysqlclient.lib compiled for borland compiler
Don't exists. Best to use the dynamic library libmysql.dll and
linking statically through a *.lib file created with implib
tool.
I use mysql 4 as an windows
"Robert Morgan" <[EMAIL PROTECTED]> wrote:
>
> Hi I'm running mysql 4.0.14
> I'm doing an update from a webpage involving 3 tabIes, using 3 update queries and
> need to be able to roll back to
> before the first update query if the second or third query go pear shape. So I need
> to set a savepo
On Friday, September 26, 2003 7:10 AM, Patrick Shoaf wrote:
> ...Given that problem, and my success accessing MySQL
> from any place with a natural (not ODBC) driver, I would look to ODBC
first
> the MySQL second.
I'm coming into this discussion late, so I apologize if this is too
elementary or
I found in other discusion thread that currently it's not possible...
What i did was to "split" the code in multiple SQL Statements, i put
them in an array and executeted one by one... this solved the problem,
but i'm concerned about performance issues.
FB
> I think you can't.
> Even MySQLcc ru
Roman,
- Alkuperäinen viesti -
Lähettäjä: "Roman Neuhauser" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Friday, September 26, 2003 12:02 PM
Aihe: Re: innodb: storage requirements
> # [EMAIL PROTECTED] / 2003-09-25 08:58:09
Bo,
- Alkuperäinen viesti -
Lähettäjä: "Bo Lorentsen" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Friday, September 26, 2003 9:41 AM
Aihe: Re: REFERENCES question in mySQL 4.1 - Take 2
> On Fri, 2003-09-26 at 01:14, Heikki
Dear Friends
where i can find an mysqlclient.lib compiled for borland compiler
I use mysql 4 as an windows server
Regards
Luiz
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/03
Hi all,
We want to migrate to MySQL, and because of its speed, we want to use
MyISAM db. I plan to write code as an "alternate" transaction mechanism.
But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like).
In PL/SQL it is possible to use in your stored procedures transac
[EMAIL PROTECTED] wrote:
>
> I have a table with a foreign key that references two
> different parent tables.
> I can't insert a row into this child table unless the
> data is in both parent tables. I don't want the data to
> be in both parent tables.
>
It's how foreign key constraints work. For
At 3:47 -0500 22-09-2003, Andy Callan wrote:
I tried to "kill 3306" and it claimed there was "no such process"
I have a GUI fronted called MacSQL already installed that i was using before
when I could only edit test_... db's in mySQL but I doubt that could
be causing
a problem since it did
a minor tweak should result from doing
count(1)
instead of
count(*)
>From what I know (not much) the * causes the db to do a secondary lookup for the
>names of the columns, even though you're not using it at all.
As you're selecting every record in the table, I'm pretty sure indexing won't hel
I believe the problem is in the ODBC drivers on MS Winx platforms. I have
no problems accessing MySQL from MySQL Control Center or from perl or other
programs NOT using ODBC. I have a MS FoxPro application using ODBC to
connect to MS SQL Server via TCP/IP and MS FoxPro has problems connecting
Greetings. When I execute the SQL script below in
mySQL 4.1, I get
ERROR 1216: Cannot add or update a child row: a
foreign key constraint fails
It is, of course, choking on the enroll row insert.
Why is this happening? Here are some things that make
the problem go away:
1. Take out the "name
Hi: Issuing a simple group by like this:
select C_SF, count(*), sum(je) as sum_je
from kp_data
group by C_SF;
against a large (1.4G) table holding a 5 mln records with 60 columns
takes about 330 secs on my Win2000 development box,
a 2.0GHz P4 w/ 1G RAM and an IDE MAXT
Waseem Ahmad Zia <[EMAIL PROTECTED]> wrote:
>
> I require information that latest version(4.0.15) of mysql provides support for
> executing subqueries and prepared statement,if it is possible in this new version of
> mysql then i require information about drivers for prepared state ment and how
Waseem Ahmad Zia wrote:
Hello hi
I require information that latest version(4.0.15) of mysql provides
support for executing subqueries and prepared statement,if it is
possible in this new version of mysql then i require information about
drivers for prepared state ment and how to user sub quries in
Hello hi
I require information that latest version(4.0.15) of mysql provides support for
executing subqueries and prepared statement,if it is possible in this new version of
mysql then i require information about drivers for prepared state ment and how to user
sub quries in mysql
bye
Waseem Ahma
Heloo hi
I require information that latest version(4.0.15) of mysql provides support for
executing subqueries and prepared statement,if it is possible in this new version of
mysql then i require information about drivers for prepared state ment and how to user
sub quries in mysql
bye
Waseem Ahma
Bang on, Emery. Works a treat. Thanks very much.
Matt
Director General: NEFACOMP wrote:
Using the Query of the players already selected build a list like :
$player_list="player1, player2, player3, ...";
and then use that list to not return selected ones
SELECT player_id FROM pl
Using the Query of the players already selected build a list like :
$player_list="player1, player2, player3, ...";
and then use that list to not return selected ones
SELECT player_id FROM playerTable WHERE player_id NOT
IN($player_list);
I don't know exactly how your tables are
Hi,
I asked for some help about a week ago and thanks to everybody who got
me a little closer to the solution.
I am developing an online fantasy rugby game. Visitors buy and sell
players and earn points depending on those players' performances in real
matches.
The only problem I have is that
Hi,
I have a table with a foreign key that references two
different parent tables.
I can't insert a row into this child table unless the
data is in both parent tables. I don't want the data to
be in both parent tables.
Is there a way round?
thanks
Rich
--
MySQL General Mailing List
For list
# [EMAIL PROTECTED] / 2003-09-25 08:58:09 +0300:
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > > > Also, is there a way to *measure* the fragmentation of a table?
> > > > If there is, how should the info be interpreted?
>
> Sorry, no. But adding such a feature would be easy: just look at page
The problem is not when sending FLOTs to the server, but it when RECEIVING
floats FROM the server.
Thanks
Emery
- Original Message -
From: "Mike R. Duncan" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, Se
Do you have a database you want to create that table in?
You can use the test database if you are just testing.
In that case you do: mysql> USE test
If you want to create your own database:
mysql> CREATE DATABASE database_name
mysql> USE database_name
And then continue your queries.
Thank you very much.
Emery
- Original Message -
From: "Brent Baisley" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 21:28
Subject: Re: MySQL powered MailServer
> I don't know about the hMailServer, but
I think you can't.
Even MySQLcc runs one after one.
In fact it takes one statement and runs it. After that, it runs the
following statement. The thing is not sent on the server at once.
I might be wrong! (not an expert)
Thanks
Emery
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[
Further examination of the documents reveals a variable that addresses
this... I fixed it with this entry in my.cnf:
set-variable= lower_case_table_name=0
According to the MySQL manual lower_case_table_name defaults to 0 for all
instances except Windows, where it defaults to 1... Not clear wh
52 matches
Mail list logo
