my Perl/FCGI application does not release resources after
query the DB from Perl program , prepare statement is defiend localy
within function block with my style , still , the memory used by
statment stays reserved even if $stastment-finsih is called explictly.
any suggestions please !
Hi group
I don't know if my problem is Microsoft or MySQL so i try here first.
I have installed MySQL and MyODBC on the same machine as I have Access. I would like
to connect to MySQL using Access as frontend, but when I have done the whole procedure
with ODBC, I get a message, saying:
syd3:/mysql/var# ../bin/mysqlbinlog syd3-bin.001
# at 4
#010926 17:41:57 server id 1 Start: binlog v 1, server v 3.23.42-log
created 010926 17:41:57
# at 73
#010926 17:48:11 server id 1 Query thread_id=1119 exec_time=0
error_code=0
use agn_users;
SET TIMESTAMP=1001490491;
CREATE TABLE
Hi.
I have the following command:
mysqlimport -d -c, --columns=DATE,TIME,MSG --fields-terminated-by=,
--fields-enclosed-by=, dbase c:\file.txt
This reads the following from a text file:
26 Sep 2001, 05:42:24 : Text message to be read.
The date and time separator is a , and the time and message
Charles Lewis writes:
I have the following command:
mysqlimport -d -c, --columns=DATE,TIME,MSG --fields-terminated-by=,
--fields-enclosed-by=, dbase c:\file.txt
This reads the following from a text file:
26 Sep 2001, 05:42:24 : Text message to be read.
The date and time separator is
At 17:48 25/09/01 +, [EMAIL PROTECTED] wrote:
Hi!
Are you sure that the server was started ?
otherwise:
Run the server as standalone disabling the grant tables
with the argument --skip-grant-tables.
If you aren't able to access the server with the client,
maybe you got a corrupted file
Hi,
Excuse me if this is wrong, but I think its the INNER JOIN which is slowing
down the query.
Wouldnt it be better (less memory intensive) to just use:
FROM zipwork1 as z, pctwork1 as p WHERE z.run_id = p.run_id
to join the tables if they are 1-1 related.
Andrew Murphy
-Original
Hi!
Can somebody help me making a query for this:
I have one table with 3 columns (a,b,c).
a := id (reference to the second table) (key)
b := userid (key)
c := amount of units
and another table with two columns (a,d)
a := id (key)
d := price
I want a query which gives me the total bill for
Thanks for responding.
That's interesting. I will definitely give your sugestion a try. I thought
the two syntaxs had the same effect. What does the optimizer do
differently?
-Original Message-
From: Andrew Murphy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 5:12
Hi!
I am trying to replicate a database from one host (master) to other host
(slave), but on slave machine I got this error messages:
010926 11:24:09 Slave thread: error connecting to master:Access denied
for user: '0@localhost' (Using password: YES)(0), retry in 0 sec
010926 11:24:09 Slave
my e-mail address is [EMAIL PROTECTED]
database,sql,query,table
¤Þ¨¥ [EMAIL PROTECTED]:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
I just saw this in the manual and think it can do what you need:
It's an option of the myisamchk program
--set-auto-increment[=value]
Force auto_increment to start at this or higher value. If no value is given,
then sets the next auto_increment value to the highest used value for the
auto key +
Howdy list!
Get in trouble with:
SELECT COUNT (DISTINCT V_CODE) FROM INVENTRY;
- SYNTAX ERROR
The SQL numeric functions that don't seem to work:
COUNT
MIN
SUM
Nesting doesn't seem to work either:
SELECT P_CODE, P_DESCRIPT, PRICE
FROM INVENTRY
WHERE PRICE = (SELECT MAX(PRICE))
hello! how do you do.
I have installed the MySql database in my computer, but I don't know how to use
it,and there is no man page about the executable file,such as mysqladmin ...,could you
tell me where I can find it?
===
TOM163 ×Ý ºá ÓÊ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 26 Sep 2001, xuwenchuan wrote:
hello! how do you do.
I have installed the MySql database in my computer, but I don't know how to use
it,and there is no man page about the executable file,such as mysqladmin ...,could
you tell me where
Tobias Bohlin writes:
Get in trouble with:
SELECT COUNT (DISTINCT V_CODE) FROM INVENTRY;
- SYNTAX ERROR
Two errors in your query: MySQL doesn't allow you to
insert whitespace between the function name and the
parentheses, and you've misspelled inventory. :-o
//C
--
Carl Troein - Círdan
Dear Sir/Madam
I want change mysql character set because I have
problems in Data sort and search in persian language.
I have studied mysql help but I don't understand it.
please help me.
Yours Sincerely
S. Dinary
__
Do You Yahoo!?
Get email alerts
Hi Charles!
I have the following command:
mysqlimport -d -c, --columns=DATE,TIME,MSG --fields-terminated-by=,
--fields-enclosed-by=, dbase c:\file.txt
This reads the following from a text file:
26 Sep 2001, 05:42:24 : Text message to be read.
Carl's response was perfect end negated my
hi together,
we have small problems with a commercial used mysql-database under windows
nt 4.0 sp6. the used version of mysql ist 3.22.30. the communication between
database and our software ist running with the belonging ODBC-Driver. the
complete software is running at only one pc. our software
Hi,
I have problems with full-text search. My table contains text lines from
computer-generated log files rather than documents written by humans, and so
my first problem is that I need an exact match rather than a relevance
value, i. e. if the search string is 'ai', I really need all rows
Hi all,
I've done a decent amount of searching on Deja.com but haven't found anyone
with this particular problem.
I have two boxes running MySql on Win2k. Replication works great. One box
is Master, one is Slave. After the boxes are running, any write to the
Master is replicated to the
I did not see subselects in this list. Will MySQL support subselects in 4.x?
What exactly does the LOAD TABLE FROM MASTER 'automagically' comment mean?
Does that command sync the slave with the master at that point? If I have
three tables, A, B, and C, and I want to load them at runtime
Subselects are not yet supported in the 4.0 release.
- Original Message -
From: Kyle Hayes [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Wednesday, September 26, 2001 4:40 PM
Subject: Re: Features in 4.0
I did not see subselects in this list. Will MySQL support subselects in
Hello !
I'd like to know how I could use MySQL within Visual Age for Java's
Websphere Test Environment. More precisely, i'd like to use MySQL to support
the persistence capabilities of the EJB server of Visual Age for Java's
Websphere Test Environment.
Thanks for helping.
P. Gos
This email
On Wednesday 26 September 2001 16:34, you wrote:
Howdy list!
snip
Nesting doesn't seem to work either:
SELECT P_CODE, P_DESCRIPT, PRICE
FROM INVENTRY
WHERE PRICE = (SELECT MAX(PRICE))
FROM INVENTRY);
- syntax error
This is really weird. Why do You think it can
as appealing for most people. One of the changes that I
intend to make
is to allow the code to be smart enough to determine whether the user
has insert/update/delete permissions (verses just select) in which
case, it will link them to the master copy instead of a slave
for read
only
Hi!
R == R Talbot [EMAIL PROTECTED] writes:
R R Talbot wrote:
R R Talbot wrote:
R Still having compile problems and GNU binary
R produces the following info
cut
R bin/mysqld --help
R basedir: /usr/local/mysql/
R datadir: /usr/local/mysql/var/
R tmpdir: /tmp/
cut
As you
[PASCAL.GOS writes:]
I'd like to know how I could use MySQL within Visual Age for Java's
Websphere Test Environment. More precisely, i'd like to use MySQL to
support
the persistence capabilities of the EJB server of Visual Age for Java's
Websphere Test Environment.
You can only do this
Hi there,
In the Mysql query log, is there any way of logging for each query the
number of disk I/Os, amount of CPU time spent processing and network data
sent?
What about a way to ensure that each user and/or database gets a fair
turn at disk I/O?
Or even getting mysql to switch to a
On Wed, Sep 26, 2001 at 09:57:33AM -0600, Adam Douglas wrote:
: Is there a list of features that InnoDB provides? Is InnoDB
represented as a
: table type? The reason I'm asking all these questions and
require details is
: because MIS at where I work would like to have such
features in a
I get the following error when I try to start to start mysqld:
010926 2:23:55 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
I am a total newb and I don't have any idea how to get around this.
Any ideas?
-
Before
Amanda Shuler wrote:
I get the following error when I try to start to start mysqld:
010926 2:23:55 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
I am a total newb and I don't have any idea how to get around this.
Any ideas?
Who ever installed mysql did not run
Hi,
just read about the UNION operator beging supported with mySQL 4. How far
are those operators implemented yet? Will there be any chance that UNION
ALL and INTERSECT will be supported, too?
And last but not least I want to try mySQL 4 but can't find any download
link yet. Where can I
Hi,
How many OR or AND can I put in a select query statement?
ex:
WHERE mycolumn = 1 OR mycolumn = 3 OR mycolumn = 23 etc . . .
A thousand? How would that affect the database execution time?
-
Before posting, please
Is it possible to use a FULLTEXT index with HANDLER to search in the
database.
The advantage should be to avoid table locking.
http://www.mysql.com/doc/H/A/HANDLER.html
Please also reply to my E-mail address.
Thanks!
Jacob
[ www.sharksforum.com ]
You might want to try:
WHERE mycolumn in (1, 3, 23, ...)
Or even better, put your thousand records into a temporary table and then just do a
join.
--jfarr
- Original Message -
From: Mysql List [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: Wednesday, September 26, 2001 12:06 PM
If you use just 1 OR you will force a table scan and slow everything down ?
- Original Message -
From: Mysql List [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: 26 September 2001 20:06
Subject: How many OR, AND in a query?
Hi,
How many OR or AND can I put in a select query
Hello,
Where can I get a version of MySQL for Solaris
8, Intel version? Do I use the FreeBSD version of
MySQL or should I d/l the Linux version? I am just
getting used to the Solaris / UNIX environment.
Thanks,
Paul
__
Do
Hi all,
I am connecting to mysql through an application and I get this error
message:
java.sql.SQLException: Server configuration denies access to data source
Can anyone point me in the right direction?
Thanks in advance,
-Scott
Many thanks to [EMAIL PROTECTED] for a work around to my
question, here is the reply - as he/she cannot post to the list as their
email server adds an attachment, preventing the post. Thanks again, John.
---
Yes, I have had the same problem.
From what I can tell, the
Hi all,
I am running a query on mysql.The query is simple.It retrieves 2800 rows and 250
columns data.I created index for the query.But it still takes over a minute.
Could somebody tell me what should I do?And why it is so slow?
Thanks!
Dan
Does anyone know how to write a query to get out the sum of a whole
table column?
SELECT sum(column) FROM table {WHERE where-clause};
Also see the manual.
:wq!
Ralph
-
Before posting, please check:
Does anyone know how to write a query to get out the sum of a whole
table
column?
ex. I'm playing around with a database where customers can buy stuff.
I have a table where I save all the invoices, but now I want to write
a query that sums upp all the prices in the price column in that
table.
Well, a column can't be one value AND another value.
Mysql List wrote:
in() is usefull for OR ing, but is there a way to do this AND ing?
You might want to try:
WHERE mycolumn in (1, 3, 23, ...)
Or even better, put your thousand records into a temporary table and then
just do
On Wed, Sep 26, 2001 at 12:41:43PM -0700, Pauljames Dimitriu wrote:
Hello,
Where can I get a version of MySQL for Solaris
8, Intel version? Do I use the FreeBSD version of
MySQL or should I d/l the Linux version? I am just
getting used to the Solaris / UNIX environment.
I do
in() is usefull for OR ing, but is there a way to do this AND ing?
You might want to try:
WHERE mycolumn in (1, 3, 23, ...)
Or even better, put your thousand records into a temporary table and then
just do a join.
--jfarr
- Original Message -
From: Mysql List [EMAIL
Does anyone have any idea about when MySQL is going to support this.
Or if it already does?
Here is an excerpt from a book I have been reading on MySQL...
.
THE Create Table STATEMENT
Tables are created with CREATE TABLE. The full syntax for this statement is
pretty
horrendous because
As a side note, be sure that you do not use a float for any columns that deal
with money or you will get rounding errors.
--Bill
mysql
Yen-Chu Chen wrote:
Hi,
Assume the name of the column is 'price' and the name of the table is
'table', you could use
SELECT SUM(price) FROM
Hi!
On Sep 26, Jacob Friis Larsen wrote:
Is it possible to use a FULLTEXT index with HANDLER to search in the
database.
The advantage should be to avoid table locking.
http://www.mysql.com/doc/H/A/HANDLER.html
Please also reply to my E-mail address.
Thanks!
Jacob
No.
Though an idea
Hi,
Assume the name of the column is 'price' and the name of the table is
'table', you could use
SELECT SUM(price) FROM table;
On Wed, 26 Sep 2001, Micke wrote:
Does anyone know how to write a query to get out the sum of a whole
table
column?
ex. I'm playing around with a
Gerald Clark wrote:
You might want to try:
WHERE mycolumn in (1, 3, 23, ...)
Or even better, put your thousand records into a temporary table and then
just do a join.
--jfarr
I have yet to have a query that is to long when talking to MySQL via DBD, however, I
believe
that
Hi All,
I have built a PHP database driven website and am now looking for a good
script that I can place on the server to track visits to the site. I
want to
place all the info in a mySQL database and be able to view the results
on
the web. Can anyone point me to a good script for this purpose.
Thank You.. Monty
Yeah! I can write shell scripts and depending on
style usually interpet those written by others..
So, I will set about changing the script and email you
my results..
Thank You for taking the time to look at my problem.
Bob T
Michael Widenius wrote:
Hi!
R == R Talbot
Hi everyone,
TIMESTAMP types are supposed to contain millis and even nonos.
How can I ensure these are set, retrieved and used for ORDER BY and
comparisons in MySQL?
I cannot find a way to get even millis back.
Also MySQL does not seem to order by this information. See below example.
Is this a
On Thu, Sep 27, 2001 at 07:43:30AM +1000, mike wrote:
Hi All,
I have built a PHP database driven website and am now looking for a good
script that I can place on the server to track visits to the site. I
want to
place all the info in a mySQL database and be able to view the results
on
Getting an error message in the log saying...
fp=(nil), etc, etc, possible bug
from ibuf0ibuf.c, line 2339
What're the possible reasons I could be getting this bug?
Oh, forgot...
MySQL-max 3.23.42
innodb
Red Hat 6.2(2.2.14-6.1.1.smp)
Intel 866Mhz, 512MB Ram, 20+ GB SCSI HDD
Thanks,
Chris
At 3:07 PM -0500 9/26/01, Dan Liu wrote:
Hi all,
I am running a query on mysql.The query is simple.It retrieves 2800
rows and 250 columns data.I created index for the query.But it still
takes over a minute.
Could somebody tell me what should I do?And why it is so slow?
Thanks!
Dan
You may get
At 8:52 PM +0200 9/26/01, Ralph Graulich wrote:
Hi,
just read about the UNION operator beging supported with mySQL 4. How far
are those operators implemented yet? Will there be any chance that UNION
ALL and INTERSECT will be supported, too?
UNION ALL is implemented; I don't think INTERSECT is
On Wed, Sep 26, 2001 at 12:44:44PM +0300, Razvan CATINAS wrote:
Hi!
I am trying to replicate a database from one host (master) to other host
(slave), but on slave machine I got this error messages:
010926 11:24:09 Slave thread: error connecting to master:Access denied
for user:
At 6:03 PM -0500 9/25/01, [EMAIL PROTECTED] wrote:
Hi All,
I seen a post a few days ago on how to set the auto increment value
back to one
after deleting all the data from a table. I suppose I could just re-create the
table, but thought it be simpler to just alter the table to reset the auto
At 5:48 PM + 9/25/01, [EMAIL PROTECTED] wrote:
Upgraded win98 to win2000. Now unable to log onto mysql as
previously did mysql -h localhost -u me -p. Have tried
several diff host names to no avail. How can I correct?
Frank
Maybe the Win2000 install destroyed MySQL for you because it didn't
The upgrade changes the directory and file security. Try right mouse
clicking on the MySQL Folder select Properties security and advanced and
then the Owner tab. Check the replace owner on all subdirectories and the
click ok.
This will change the security settings to the new type and should then
Hi,
I want to escape single quotes in the result of a query run in a shell
script. I think REPLACE is the right function to use.
If, at the mysql prompt, I enter
mysql select replace(name, '\'', '\\\'') from cust_details where name like
'%\'%' limit 10;
I get
Hi can u tell me which version mysql can run under xp ?
-
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
Hi Anton,
- Original Message -
From: Tichawa Anton [EMAIL PROTECTED]
I have problems with full-text search. My table contains text lines from
computer-generated log files rather than documents written by humans,
and so my first problem is that I need an exact match rather than a
Hi Charles,
- Original Message -
From: Charles Lewis [EMAIL PROTECTED]
I have the following command:
mysqlimport -d -c, --columns=DATE,TIME,MSG --fields-terminated-by=,
--fields-enclosed-by=, dbase c:\file.txt
This reads the following from a text file:
26 Sep 2001, 05:42:24 : Text
Hi all, mysql-team
i have a very very complicated problem , hope to be clear.
i have a file report (.txt) with about 200,000 data about books (title,
clasif, year, publisher, authors, subjects, etc etc) without tabs or
separation, i built a parser to split each field and works fine.
Kyle Hayes writes:
I did not see subselects in this list. Will MySQL support subselects in 4.x?
What exactly does the LOAD TABLE FROM MASTER 'automagically' comment mean?
Does that command sync the slave with the master at that point? If I have
three tables, A, B, and C, and I want
I understand that mysqld will normally look in /etc for the my.cnf file
when it starts. I would like to change this behavior so that it will look
in /usr/local/etc. I know that I can do this with a command line option,
but I want this to be the default behavior. I thought the the configure
Hi~
I have a question. If I do nothing after I use mysql C API to connect to
mysql server, how long the connection will be kept? If there is a time
limit, what will happen if I execute some queries when the time is out?
Will the API function like mysql_query () reconnect to the server and
On Wed, Sep 26, 2001 at 05:16:26AM -0400, Will French wrote:
Thanks for responding.
That's interesting. I will definitely give your sugestion a try. I thought
the two syntaxs had the same effect. What does the optimizer do
differently?
Ask it and see...
EXPLAIN SELECT
Jeremy
--
Ask it and see...
EXPLAIN SELECT
Jeremy
mysql exlain why youre not writing all (non-select) queries to the binary
log when replicating databases;
ERROR 1064: You have an error in your SQL syntax near 'exlain why youre not
writing all (non-select) queries to the binary log when rep'
On Wed, Sep 26, 2001 at 04:53:18PM -0500, Gunter Leeb wrote:
Hi everyone,
TIMESTAMP types are supposed to contain millis and even nonos.
Not according to the documentation.
How can I ensure these are set, retrieved and used for ORDER BY and
comparisons in MySQL?
There is no built-in type
On Wed, Sep 26, 2001 at 07:40:45AM -0700, Kyle Hayes wrote:
I did not see subselects in this list. Will MySQL support
subselects in 4.x?
The last plan for sub-selects I heard was in 4.1.x.
What exactly does the LOAD TABLE FROM MASTER 'automagically'
comment mean? Does that command sync
Please help?
A friend sent me a mySQL database -- which I can see when I execute the
command show databases -- however I cannot see any of the tables in the db.
The DB has several subdirectories (including one called mySQL) -- and does
not look like the test db or mySQL db directories.
I
Sounds to me like the database was possibly created on a different
architecture, so the DB files are incompatible. Only way /I/ know of
(Warning: I Am Not A MySQL Guru) to transfer the DBs reliably is to dump
the DB to a flat text file on one platform, and then import it back into
MySQL on the
HI! I am waiting on the official launch of 4 and want to know more about
the union tables. Can someone give me the low down on this? I know I will
need it (I have to combine 15 tables into one big pile of data) so please
help. Thanx!
**
- Deryck Henson
-
I will check that -- now that you mention it I think the files were created
and run on a UNIX platform and I am on Win32.
Thanks for the quick reply!
MG
- Original Message -
From: Matthew Walker [EMAIL PROTECTED]
To: 'Yahoo Mail' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday,
On Mon, Sep 24, 2001 at 10:14:59AM +0200, Rafal Jank wrote:
Hi,
Why is mysql locking table during insert operastion? The version is
3.23.22, so it shouldn't behave like this...
Have you ever deleted records from the table (and not run an OPTIMIZE
TABLE afterward)? If there are holes in
Chris,
what is the exact error message? How do you know that
it comes from ibuf0ibuf.c, line 2339? Have you compiled
yourself?
Regards,
Heikki
Innobase Oy
Getting an error message in the log saying...fp=(nil), etc, etc, possible bug
from ibuf0ibuf.c, line 2339
What're the possible reasons I
Hi,
A minor bug report:
mysql tee c:\dev\sqlout.txt
mysql: Can't create/write to file 'c:\dev\sqlout.txt' (Errcode: 2)
Logging to file 'c:\dev\sqlout.txt'
If the file is locked for whatever reason, it crashes with:
The instruction at 0x77f821e1 referenced memory at 0x34. The memory
could not
On Tue, Sep 25, 2001 at 03:02:30PM -0500, Christopher Raymond wrote:
MySQL Gurus:
Is there a newsgroup server for this discussion list?
I don't think so.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell:
Pauljames Dimitriu writes:
Hello,
Where can I get a version of MySQL for Solaris
8, Intel version? Do I use the FreeBSD version of
MySQL or should I d/l the Linux version? I am just
getting used to the Solaris / UNIX environment.
Hi,
It seems that the latest build that we have
I have the following table mlist:
+--+-+
| mlist_id | addr_id |
+--+-+
|1 | 1 |
|2 | 2 |
|2 | 3 |
|1 | 3 |
+--+-+
This is the join table of my address book and my mailing lists. So person 1
Hi,
Is it possible to search with LIKE for a field name? I have database that
has various data and the field names are named by the language it is aimed for.
So can MySQL be used to search that field list for all fields having
specific string in them and then selecting all data pertinent to
85 matches
Mail list logo