At 08:55 4-4-01 +0200, Nicolas Villatte wrote:
>is it possible? If yes, how ?
Yes.. BLOB (BinaryLargeOBject) Check the archive, and manual.
Bye,
B.
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
I have inherited a client with a flat file shopping cart. I have added a
MySQL database to record the orders, and am using DBI with Perl and PHP3 to
do the interaction with the MySQL database.
The site is a local theater that sells concert tickets. They have sold as
many as 4 tickets per second
is it possible? If yes, how ?
-
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 PROTECTED]>
To unsub
-Ursprungliche Nachricht-
Von: Foresight Systems Ltd. [mailto:[EMAIL PROTECTED]]
Gesendet am: Mittwoch, 4. April 2001 10:57
An: Brian Warn;
Betreff: Mysqld problem Re: ownership/permission problems
Dear Sir,
Since you already have mysql running, we seek your help in sorting out
some p
Dear Sir,
Since you already have mysql running, we seek your help in sorting out
some problem.
mysqld starts and ends instantaneously.
We are using Red Hat Linux 7.0 /Apache Server on PIII 550 intel
processor.
We have compiled the mysql and installed version 3.23.32.
The contents of our my.cnf fil
Dear Sir,
We are getting problems in running mysql after installation.
Since you have already running mysql we seek your advise on the
following.
We are using Red Hat Linux 7.0/Apache Web Server on PIII 550 intel
processor.
We have compiled the mysql and installed version 3.23.32.
The contents of
Oson take a look at mysql documentantion. You can do this with match
against.
A IR system is somewhat different than a DB. But mysql is both an IR and
a DB.
Oson, Chris M. wrote:
> Hello,
>
> I have a site that I'm trying to implement a search engine on existing and
> archived news stories o
To whom it may concern,
I have a case in a select statement I am using and it looked like this:
CASE
WHEN
discount.price is not null
THEN
discount.price
ELSE
prod.price
END as sort_price
and I noticed the order was all screwe
Hi,
I would like to know how to store chinese in MySQL Databases. What
type of column should I use ??
Thank You
Mark Lo
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
Dear Homeowner,
Due to a slowing economy interest rates are the lowest they've been in years. Take
advantage of these low rates by refinancing your home. We have a loan program for any
need: Debt Consolidation, Home Improvement, Purchases, Rate & Term Refinance, Second
Mortgages, Home Equity
Taing Nguon wrote:
>
> > Make sure that the files are not world readable.
>
> In Linux system, In order to run CGI in PERL script, that perl script
> must be 755. It is read by any users and Perl is written in text format, so
> Its is easy to know user and password of MYSQL. How do you think
I use mysql with japanese -sjis text (i think it also handles -euc and
perhaps others, including Korean) with no problem for inserting and
searching. However, to have it sort it the Japanese or Korean way, you
should take a look at the following 2 references:
http://www.mysql.com/doc/C/h/Characte
http://www.TheCasino.com: Better Than Life! (tm)
Since 1999 - Now With 100% "Buffer Bonuses" On All Deposits!!
Dear [EMAIL PROTECTED],
This email is to confirm that we have "removed" you from our mailing
list - per your request!
You will no longer be considered for TheCasino.com Monhtly Pr
http://www.TheCasino.com: Better Than Life! (tm)
Since 1999 - Now With 100% "Buffer Bonuses" On All Deposits!!
Dear [EMAIL PROTECTED],
This email is to confirm that we have "removed" you from our mailing
list - per your request!
You will no longer be considered for TheCasino.com Monhtly Pr
"Taing Nguon" <[EMAIL PROTECTED]> wrote:
>
> > Make sure that the files are not world readable.
>
> In Linux system, In order to run CGI in PERL script, that perl script
> must be 755. It is read by any users and Perl is written in text format, so
No entirely true. The reason the files are
Dear MySQL Kitchen List,
Congratulations! You just won US$10.00!!
We just gave away US$25,000.00!! And you MySQL Kitchen List are among the lucky 2500
people
randomly selected to receive a FREE US$10.00 Trial Account at TheCasino.com - the
Internet's Premier Online Casino!
Account Status for
> Make sure that the files are not world readable.
In Linux system, In order to run CGI in PERL script, that perl script
must be 755. It is read by any users and Perl is written in text format, so
Its is easy to know user and password of MYSQL. How do you think about
this?Need More HELP
> I would think that if the user does not have grant options set on the
> particular DB in the mysql.db table, then he would not be able to access
it
> using DBI, even if he is a local user.
I have already tried to do it by myself. and I found that although any user
has no MYSQL user's account,
> How does one tell if mysql is using BDB?
SHOW TABLE STATUS;
Type = BerkeleyDB
http://www.mysql.com/doc///S/H/SHOW_TABLE_STATUS.html
Do I have to somehow specify BDB
> when creating a new database?
CREATE TABLE [...] TYPE = BDB;
http://www.mysql.com/doc///C/R/CREATE_TABLE.html
I've ins
How does one tell if mysql is using BDB? Do I have to somehow specify BDB
when creating a new database? I've installed BerkeleyDB and mysql, yet it
doesn't look like it's using bdb. Unable to rollback any insert's.
Thanks,
Albert
--
Using Windows and Statically Compiled MySQLGUI 1.7.4, it appears to refuse to connect
until I go to Options and Apply again every time I wish to connect.
Grant/revoke crashes the application, while appearing to be downloading data through
my modem. I don't get to the grant/revoke screen.
Rega
In that case I refer you to the archives:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:70079:hkagoolipmedibdijphh
That message mentions that in his normal operation he is handling 1631
queries per second without even phasing the machine. He also mentions that
he got the machine digesting over 6
On 03 Apr 2001 16:49:36 -0700, Eric Fitzgerald wrote:
> Depends on your hardware...
>
> 500 machines of logging, how many entries per second?
I'm not sure, but i believe most of those machines will not send more
than a couple of events per second. Some of them (but not too many) will
surely send
Depends on your hardware...
500 machines of logging, how many entries per second? I've seen people
report their MySQL installs doing hundreds or thousands of queries per
second, and not even phasing the machine.
- Original Message -
From: "Florin Andrei" <[EMAIL PROTECTED]>
To: <[EMAIL
What is the maximum number of connections MySQL can handle?
I would like to use MySQL as a logging server, for some 500 machines,
but i'm not sure it is able to handle so many simultaneous connections
(the clients will do only INSERT or INSERT DELAYED).
--
Florin Andrei
-
To access the Unix database from NT, there is a good tool I use called
webmin (http://www.webmin.com/). It is written in perl and uses a http
connection through a different port. I don't know about connecting to NT
from Unix, I only have databases on Linux.
len.
-Original Message-
F
Db -> table1, table2 and table3
SELECT table1.task, table2.comment, table2.remarks, table3.history
FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;
Results (roughly) in:
+--++--+-
"Martin Jeremic" <[EMAIL PROTECTED]> wrote:
> Can somebody tell me where i'm wrong ?
>
> insert into table3 select * from table1 where RecNo = 12 ---> this
> works
>
> insert into table3 select * from table2 where RecNo = 12 ---> Nothing
> Happens
Post to the list the output of:
DESCRIBE tabl
Friends,
I need to manager database MySQL on UNIX Server from Windows NT and I found the
software netadmin.exe, that it is very good, written and maintained by David Axmark.
I didn´t find how to create tables on UNIX server from windows NT... If somebody
knows how to do this, please t
You probably need to boost the memory limits up in your shell (ie with bash
see man ulimit)
Mike
Jeremiah Griffin wrote:
>
> Howdy,
>
> I am trying to run mysqldump and I am getting a memory error.
>
> =
> mysqldump: Out of memory (Needed 65576 bytes)
> mysqldump: Got error: 2
could i respectfully request help, i am totaly lost
as to how to format this code
as well as only been with mysql & perl for 2
weeks.
i am trying to take a real time internet tcp feed
that is a comma deliminated row
and input into fields in a mysql
database
my attempt although possibly
Can somebody tell me where i'm wrong ?
insert into table3 select * from table1 where RecNo = 12 ---> this
works
insert into table3 select * from table2 where RecNo = 12 ---> Nothing
Happens
There are 3 fields in all tables, 2 LongText, and 'RecNo' -
AutoIncrement
Thanks in advance
--
Martin
it matters what you run the mysql client as
if I'm root
root: #> mysql -u foo -p
the program mysql is running as root and hense writes the history file to
root's home dir.
if I'm me
andrew: $> mysql -u foo -p
it'll write it to ~andrew/.mysql_history
regards,
-- Andrew
- Original Messa
Howdy,
I am trying to run mysqldump and I am getting a memory error.
=
mysqldump: Out of memory (Needed 65576 bytes)
mysqldump: Got error: 2008: MySQL client run out of memory
=
I have 256 megs of ram on the server and I just added another 256 megs ...
same error
I've posted this problem before, but I didn't get any responses.
Has anyone had problems with errors like this with replication:
010403 3:34:26 Error reading packet from server: bogus data in log event (read_errno
0,server_errno=65535)
This seems to happen when I do a large number of inserts
delete from user where user='tvinhas' and host='localhost';
delete from db where user='tvinhas' and host='localhost';
Cal
http://www.calevans.com
-Original Message-
From: Thiago Vinhas de Moraes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 2:51 PM
To: [EMAIL PROTECTED]
Subj
I finally did find a discussion in Monty's book on p. 417 about this.
Thanks,
Brian
- Original Message -
From: "B. van Ouwerkerk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 11:20 AM
Subject: Re: ownership/permission problems
>
> >I haven't had any success
"Thiago Vinhas de Moraes" <[EMAIL PROTECTED]> wrote:
> Can anyone help me with a probably simple issue?
>
> All I need to be happy forever is to the inverse of the following:
>
> insert into user (host, user, password) values ("localhost", "tvinhas",
> password("phl1nao8"));
>
> and
>
> insert int
My apologies, I didn't clarify that I *was* using a full-text search.
-Original Message-
From: Lindsay Adams [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 11:52 AM
To: [EMAIL PROTECTED]
Subject: Re: Full Text Search Question
To do a full word match like you are wanting, you w
Have you tried using REVOKE instead?
Are you sure YOU have DELETE privilege on the mysql database?
You should be able to: DELETE FROM mysql.user where User='tvinhas';
And from the other databases that use the User field.
On 4/3/01 12:51 PM, "Thiago Vinhas de Moraes" <[EMAIL PROTECTED]>
wrote:
Hi
Does anyone know why no matter what user I log into my database undr, the
only history file that is being written to is root's :
/root/.mysql_history
Why is a history file not created in the users home directory?
Thank You so much to anyone who has the time to help.
Scott
--
Hi,
I have one site developed with php+mysql. We have about 10.000 visits per day with
more or less 250/300 users on prime time. When users increase over 200 mysql starts
runing some errors and restarting...
Number of processes running now: 0
010402 21:33:13 mysqld restarted
/usr/sbin/my
Hi!
Can anyone help me with a probably simple issue?
All I need to be happy forever is to the inverse of the following:
insert into user (host, user, password) values ("localhost", "tvinhas",
password("phl1nao8"));
and
insert into db (host, db, user, Select_priv, Insert_priv, Update_priv,
"Peter M. Perchansky" <[EMAIL PROTECTED]> wrote:
> I'm using the datetime format and the data is stored in mySQL as
CCYY-MM-DD
> HH:MM:SS
>
> I want to use a SELECT statement where the ORDER BY clause is based on the
> date portion (CCYY-MM-DD).
>
> How would I write the clause to ignore the time
On Tue, 03 Apr 2001 15:00:31 -0400, "Peter M. Perchansky"
<[EMAIL PROTECTED]> wrote:
Greetings:
I'm using the datetime format and the data is stored in mySQL as CCYY-MM-DD
HH:MM:SS
I want to use a SELECT statement where the ORDER BY clause is based on the
date portion (CCYY-MM-DD).
How would
"Hamid Hashemi Golpayegani" <[EMAIL PROTECTED]> wrote:
> Then two MySQL installed on a machine can use the same port 3306 or one of
them must changed to another port ?
They'll need to be on separate ports and have separate socket files. You'll
just have to append the port to the host as follows
I have not been able to find any documentation on binding a mysql
process to a specific interface. The application would be for setting
up a high availability, failover environment where a server can take
over an IP and services running on that machine, given that the file
systems can be shared v
Can a program connect to an Oracle (or Sybase, Informix or DB2) database using MySQL++?
Greetings:
I'm using the datetime format and the data is stored in mySQL as CCYY-MM-DD
HH:MM:SS
I want to use a SELECT statement where the ORDER BY clause is based on the
date portion (CCYY-MM-DD).
How would I write the clause to ignore the time portion?
Thank you.
__
To do a full word match like you are wanting, you would need to break up the
sql query to do this:
... WHERE field LIKE "%word1%" AND field LIKE "%word2%" ...
That is how you have to do it if you are not using one of the latest 3.23
versions of mysql. If you have a newer version of mysql, check
Hi all,
I have an upcoming project to port a large application, currently
uses Oracle as its database, to a new architecture.
As part of this conversion, we're investigating the possibility of
changing the database component to Mysql.
Having never worked with Oracle, I'm at somewhat of a loss
Design Question
Hello,
I have a table design question relating to best practice and performance.
Monthy is somewhat of a SQL guru and so may be many others on this list,
this may actually help a lot of folks out there:
Example:
I want to get a listing of all applicable rates for a delivery:
>I haven't had any success so far finding any help in the manual or Monty's
>book about this particular condition, so any help is appreciated.
I don't know about the RPM's. But if you would install from source there is
a directory called Docs containing a manual.txt I did NOT compare this with
> In the field were "Windows DSN name" what do I put there.
Also if i just created a database in mysql called customer
would i put the that name in "MySQL database Name"
-
Before posting, please check:
http://www.mysql.co
Hello,
I have a site that I'm trying to implement a search engine on existing and
archived news stories on a medium text datatype in a database.
I read the documentation and got it running, but unless I missed something
it's not doing what I want it to do.
For example, if I put in the keyword
On Tue, 3 Apr 2001, Marcos wrote:
> hi,
>i would like to show 5 random field from a total of 100.
>id is my primary key
>
>id name
> --
>abmarcos
>akjohn
>
>
> how can i show 5 of them randomly?
>
> thanks in advance,
>
> marcos
Whe
After installing the server and client RPMs on my RH 7 box and verifying that
everything worked properly as root. Since I want mysql to run as the mysql user, I
searched for every directory where mysql occurred and changed ownership from root:root
to mysql:root. I can start safe_mysqld fine a
Hi,
I'm running MySQL 3.22.32 on Slackware Linux (not sure about the exact
configuration or kernel - don't have telnet access to the machine at the
moment; apologies). I have three tables:
* domains - a large monolithic table with 1 primary key and 3 other
keys, 43
fields in total, 1344 bytes
Ok i'm still a little bit lost. I have a database in MySQL called "irm"
In the ODBC Data Source 32 bit I went in user dsn and added user data source
called irm the driver is mysql
not this is were i dont understand .
In the field that says Windwos DSN name I put "irm"
MySQL I put the ip addres
I am using mysql to store content that will contain double-byte (korean,
japanese) language text -- What is it that I need to specify when inserting
that type of text (if anything) and how do I retrieve it? I am writing in
Java using JDBC to a mySQL database.
Thanks,
Kim Albee
hi,
i would like to show 5 random field from a total of 100.
id is my primary key
id name
--
abmarcos
akjohn
how can i show 5 of them randomly?
thanks in advance,
marcos
[EMAIL PROTECTED]
--
Hello,
I have a table design question relating to best practice and performance.
Monthy is somewhat of a SQL guru and so may be many others on this list,
this may actually help a lot of folks out there:
Example:
I want to get a listing of all applicable rates for a delivery:
a rate can be defi
I think that must install them on diffrent ports .
On Tue, Apr 03, 2001 at 05:27:16PM +0100, Aigars Grins wrote:
> > Then two MySQL installed on a machine can use the same port 3306 or
> > one of them must changed to another port ?
>
> Unless you have some auto-magical port-proxy thingy you hav
> Then two MySQL installed on a machine can use the same port 3306 or
> one of them must changed to another port ?
Unless you have some auto-magical port-proxy thingy you have to have
different ports for each working server on the same machine.
Or does MySQL have native handling of this? (I woul
When you set to ignore a table on the slave ( say replicate-ignore-table=foo.bar ),
will the updates
be sent to the slave and then filtered out, or will they not be sent at all to the
slave machine from the server?
Just wanna know, because I got a table with lots of updates and have set the sla
Make sure that the files are not world readable.
On Tue, 3 Apr 2001, Taing Nguon wrote:
> Date: Tue, 3 Apr 2001 09:52:30 +0700
> From: Taing Nguon <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: MySQL Security
>
> Dear sir or madam
>
> MySQL user's account is not related to user's a
I think what Kris needs answered is...
If mysql.a.com and mysql.b.com are two virtual hosts on the same
physical server, can
mysql -h mysql.a.com dbname
and
mysql -h mysql.b.com dbname
be differentiated. I'm fairly sure that mysqld has an option so that the
IP to bind to can be specified to
Hello.
On Tue, Apr 03, 2001 at 11:51:47AM +0200, [EMAIL PROTECTED] wrote:
> Hi,
>
> we currently have a situation with our mysql-3.22.29 under
> Solaris-2.7, where the databases itself are put on an NFS-mounted
> filesystem. Yesterday we had a crash of the system and isamcheck
> tried to recover
Hello.
On Tue, Apr 03, 2001 at 10:53:06AM +0100, [EMAIL PROTECTED] wrote:
> Hi,...
>
> Does anyone knows how many databases can handle on MySQL Server?
AFAIK, it is only limited by your operating system (databases are
stored as directories, so the question is how many directories your OS
is a
Hi ,
You must go to control panel of windows in Data Sources(ODBC) section and add your DSN
of you new MySQL database and then you can explor the database by browsing your ODBC
avilable databases . You can check MyODBC manual for this .
On Tue, Apr 03, 2001 at 06:55:52AM -1000, Luis wrote:
>
Luis wrote:
>
> Good morning all, last night I installed MyODBC on my laptop. What i dont
> understand is how do i connect threw access now?
>
> I'm a little confuse, can anyone help me understand how MyODBC works.
>
> luis
It is an ODBC driver for Mysql.
Create a databsae in mysql
go to th
On Tue, Apr 03, 2001 at 10:46:22AM -0400, Steve Werby wrote:
> "Kris Van Hulle" <[EMAIL PROTECTED]> wrote:
> > Does mySQL have support for virtual domains ? And if so, how can
> > i set it up ? (relevant documentation, ...)
>
> MySQL has its own security system that doesn't rely on the
> security
On my replicated linux machines with the latest 3.23.36 rpm from mysql.com, I
have been getting the following errors lately:
010403 17:08:35 Slave: received 0 length packet from server, apparent master
shutdown: (0)
010403 17:08:35 Slave: Failed reading log event, reconnecting to retry, log
"Bob Hall" <[EMAIL PROTECTED]> wrote:
> Quorting someone else who's name is no longer present:
> >Is there any way to make one field in a table calculate another field.
> >I'm making a DB that calculates commissions. So in the money_made
> >field would have the # of sales (sales field) times whate
Good morning all, last night I installed MyODBC on my laptop. What i dont
understand is how do i connect threw access now?
I'm a little confuse, can anyone help me understand how MyODBC works.
luis
-
Before posting, please c
"Ashley M. Kirchner" <[EMAIL PROTECTED]> wrote:
> If I list 15 to 30
> projects per page, that's 31 to 61 queries for one page: once to the
> projects table to get the projects, then for each project I make two
> queries, one to the history table and one to the comments table to get
> the accurate
"Kris Van Hulle" <[EMAIL PROTECTED]> wrote:
> Does mySQL have support for virtual domains ? And if so, how can
> i set it up ? (relevant documentation, ...)
MySQL has its own security system that doesn't rely on the
security/authentication system of the underlying operating system. In the
manual
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"
Hi
I have a WebObjects Application that I was using with
openbase and when I switched over to MySQL the app. could no
longer save the blob to the db. Is there some way to save a
picture in a blob in binary or should I be doing it another way.
thank
Ian
_
I have a DB that (for the purpose of this email) contains three
tables: projects, comments, and history. Each project will have its set
of comments added, and as the project advances over time, also its set
of history items.
This information gets displayed on a web page roughly in the
f
Hiya,
I'm running MySQL 3.23.36 on my Windows 2000 workstation and I noticed
that all table names are converted to lowercase by default??? After some
going through the docs I found the following setting:
lower_case_table_names
So I figured I add:
lower_case_table_names=0
to my 'C:\WINNT\my.in
Hi.
Does mySQL have support for virtual domains ? And if so, how can
i set it up ? (relevant documentation, ...)
Kris
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi,
I am using MySql on Redhat Linux 7.0. Recently I downloaded mySql++.
I installed and confugured it as per the instruction given. But when
I try to run the files in the examples directory I get the error
'Segmentation Fault (core dumped)', pls help.
Sudheer
___
Alex,
a possible temporary workaround you can try: use
LOCK TABLES intraday_PAR WRITE;
in your deleting transaction. It will lock updaters out
of your table while the delete batch is running.
There probably is a bug in hangdling of concurrent deletes
and updates in Innobase. I will try to repe
hello mysql;
how can I recreate indices from .frm and .MYD?
laplace:/mnt/bigboy/mysql/newage# /usr/local/mysql/bin/myisamchk -rv
USR_User.MYD
/usr/local/mysql/bin/myisamchk: error: 'USR_User.MYD' doesn't have a
correct index definition. You need to recreate it before you can do a
repair
it ex
Andre,
there is probably a bug in inlining of functions in gcc on HP-UX.
You should edit mysql/innobase/include/univ.i and put
#define INSIDE_HA_INNOBASE_CC
on line 11.
You will probably get another compiler error in mysql/innobase/os/os0thread.c
Edit also that file, on line 81, call of pthrea
Jeff S Wheeler writes:
> Tried to post this to mailing.database.mysql, but earthlink's news servers
> suck, and it seems the message got dropped. Bleh. Anyway..:
>
> Jeff S Wheeler <[EMAIL PROTECTED]> wrote in message news:...
> Below is a filled-out mysqlbug form. Indexes on HEAP tables
Derek Sivers wrote:
>
> Doing a "make" on the newest MySQL stable 3.23.36 source tarball - on a
> stock Cobalt RaQ3 (Linux 386) which I've installed MySQL on many times before.
>
> Got this strange error:
>
> gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O6
> -DDBUG_OF
>Is there any way to make one field in a table calculate another field.
>I'm making a DB that calculates commissions. So in the money_made
>field would have the # of sales (sales field) times whatever the
>commission would be.
Yes sir, but don't do it. That's the classic example of something
th
>Bonjour,
>
> I have a table created with :
>
>CREATE TABLE intraday_PAR (
> symbole char(20) NOT NULL default '',
> date datetime NOT NULL default '-00-00 00:00:00',
Don't use reserved words for column names.
> first double(17,5) NOT NULL default '0.0',
> high double(
Hi,
May be, you run out of memories. Try to use --large-table command to
startup mysqld.
Hope this help..
- Original Message -
From: "BAUMEISTER Alexandre" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 6:49 PM
Subje
Tried to post this to mailing.database.mysql, but earthlink's news servers
suck, and it seems the message got dropped. Bleh. Anyway..:
Jeff S Wheeler <[EMAIL PROTECTED]> wrote in message news:...
Below is a filled-out mysqlbug form. Indexes on HEAP tables are ignored in
numerous queries in whi
Raf Geusens writes:
> Hi,
>
> I know I've allready posted this question but it's rather important for my
> final work. I'll add some extra information at the bottom.
> I've got a question 'bout the number of number of writes a MySQLserver can
> handle in a second. I've written a program w
Scott Ellsworth writes:
>
> Please find ctype.h attached. (I could have just trimmed, but it seemed
> likely that you might want info I blatantly trimmed away...)
>
> Also, on another topic, I tried building the berkeleydb option the other
> day, and got an error on startup about a lack
Silvio Picano writes:
> >> Might the NFS dependence be a problem?
>
>
> What does "some other processes access the files" mean? Are you thinking
> like automated system backup software, or my own database client
> accesses?
>
Both, as well as copying files, checking file system ...
>
skick writes:
> I am havving the same problem. I even tried compiling a version. If it
> is a window manager problem then how do I fix it. It seems like it
> should work wiith both the kde 2.0 window manager and the enlightenment
> window manager that is part on gnome.
>
Hi!
Please try
Leo McCarthy writes:
>
> Hello,
>
> The configure program doesnt recognize my machine type. I am running
> SuSe v7.0 on a S/390 mainframe. uname -m returns S390, uname -s returns
> Linux and uname -p returns unknown. When I try to configure I get:
>
> Checking host system type... Inval
Bonjour,
I have re-run my query without the other program trying to UPDATE
the table :
mysql> delete from intraday_PAR where date<'2001-04-03 00:00:00';
Query OK, 364842 rows affected (32.95 sec)
It works.
Why did both threads lock each other.
There is one doing a lot of UPDATE
Bonjour,
I may have copy all the lines from "mysqladmin process-list".
While I'm doing my "DELETE FROM", another program is doing UPDATE on
the query, but this should not be a problem.
[12:32pm]# mysqladmin proc
+++---+---+-+--+--+-
Bonjour,
I have a table created with :
CREATE TABLE intraday_PAR (
symbole char(20) NOT NULL default '',
date datetime NOT NULL default '-00-00 00:00:00',
first double(17,5) NOT NULL default '0.0',
high double(17,5) NOT NULL default '0.0',
low double(17,5) NOT NULL defaul
1 - 100 of 116 matches
Mail list logo
