How do you find what position a value is in a larger query's result?
Well, if you put some sorting to your search, you will know the position of
your item by the count of the loop you are using to extract the data.
You use limit to return a max number of items, and keep a tab of where your
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
shetie dog writes:
Hi.
This may be a obvious problem but...
I want to re sequence a auto increment column called p_key starting with 1001.
Hmm... sounds like bad database design to me, but OK.
I found some information on this the Paul DuBois book MySql:
I tried dropping the column and
Hi,
How do I use a characeter set different from the server default?
Server is configured to use latin1 as default character set.
But for some occasions, I'd like to switch to big5 characeter set.
I tried to edit ~/.my.cnf and added
[mysql]
default-character-set=big5
But show variables still
Hello ,
Please help me (Urgent)
i have two tables
1. tbl_employeeinfo 2. tbl_networkpartloc
In these table i have common field called cCompany_ID.
1.
select count(tbl_employeeinfo.cCompany_ID)
from tbl_employeeinfo,tbl_networkpartloc
where tbl_employeeinfo.cCompany_ID =
On Fri, 19 Oct 2001 13:03:02 -0500
Eric [EMAIL PROTECTED] wrote:
Well, answering my own email, what I thought was a bug is not one at
all. I was mistaken in thinking that MySQL paid any attention to the
WHERE conditions when optimizing the join order beyond determining
which keys are used
Eric writes:
Well, answering my own email, what I thought was a bug is not one at
all. I was mistaken in thinking that MySQL paid any attention to the
WHERE conditions when optimizing the join order beyond determining
which keys are used for the join, correct?
This is really terrible
Hi!
On Oct 19, Mark Maunder wrote:
Hi,
I think this is a bug. The script to recreate the problem is included
below. This problem appears consistently as long as there's a fulltext
index and a regular index on the same field and you do an update to
change the case of a single char.
It is
i,
I need to know how to put email addresses into the mysql database without
encountering the escape character. All of the email addresses that contain
an underscore are receiving a backslash before the underscore. For example,
[EMAIL PROTECTED] turns into mike\[EMAIL PROTECTED] This escape
Hi,
I've been reading a document at
http://www.saturn5.com/~jwb/dbi-performance.html
by Jeffrey William Baker.
And I have changed my perl code in one script to use placeholders and
bound parameters.
On my test server 500 mhz rh 7.1 128 MB I haven't noticed any speed
differences.
Scott Alexander wrote:
I've been reading a document at
http://www.saturn5.com/~jwb/dbi-performance.html
by Jeffrey William Baker.
And I have changed my perl code in one script to use placeholders and
bound parameters.
On my test server 500 mhz rh 7.1 128 MB I haven't noticed any speed
Howdy,
I've been developing in MySQL for some time now, but as I go along I've
noticed that my naming conventions have changed dramatically, and I was
wondering if there is like a set of guidelines or something I could take
a look at. A set of standards, if you will, for naming conventions of
I have no problem using STRAIGHT_JOIN, etc. My problem is really just
figuring out the optimal join order. Is doing a SELECT COUNT on
each of the tables I'm going to join the way to do it? Isn't there
potential for the count to take as long as the full query processing
would take (especially
The information I require is the number of rows that will come from a
SELECT which places a certain range restriction on an unindexed
attribute...and I need this to not take much time relative to actually
executing the query (constant time would be best).
eric.
On Sat, Oct 20, 2001 at
Eric writes:
I have no problem using STRAIGHT_JOIN, etc. My problem is really just
figuring out the optimal join order. Is doing a SELECT COUNT on
each of the tables I'm going to join the way to do it? Isn't there
potential for the count to take as long as the full query processing
would
Dear Future Millionaire:
I'll make you a promise. READ THIS E-MAIL TO THE END! - follow what it
says to the letter - and you will not worry whether a RECESSION is coming
or not,
who is President, or whether you keep your current job or not. Yes, I know
what
you are thinking. I never responded
On Fri, Oct 19, 2001 at 07:22:20AM -0500, [EMAIL PROTECTED] wrote:
Is there away to control the max size of each database create by
user. I mean built into MySQL??
There is not.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454
Well, I would definitely have to do the count for each query; not
because my table sizes are changing (although they are at a fairly
rapid rate), but because the number of rows I want to select is vastly
different between queries. This is actually a self-join (refer to
first emails from me to
On Sat, Oct 20, 2001 at 05:02:22PM +0100, Mark Maunder wrote:
The only time you'll see a real performance increase is where you're
repeadedly calling execute() on the same statement handle with
different values for the placeholders - usually this occurs in a
loop. This will save you having
How can i connect mysql client to the mysql server? Does mysql need to be
installed on the client as well?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Jeremy Zawodny wrote:
On Sat, Oct 20, 2001 at 05:02:22PM +0100, Mark Maunder wrote:
The only time you'll see a real performance increase is where you're
repeadedly calling execute() on the same statement handle with
different values for the placeholders - usually this occurs in a
I have two lists of queries. One returns the intersection of all the
queries within itself.. the actual intersection being done by an external
function (which I'd like to change if I can learn how), the other the
union of all queries within itself.. again using an external function for
the
I have been trying to connect to mySQL for a couple of days now with no
result! I try to log in via telnet..to my remote server..I get in the system
but when I try to log in to the database, nothing!! I use this:
mysql -h localhost -u futureenter -p
it then asks for a password, I put it in and
On Sat, 20 Oct 2001, Adrian D'Costa wrote:
| Date: Sat, 20 Oct 2001 12:04:53 +0530 (IST)
| From: Adrian D'Costa [EMAIL PROTECTED]
| To: Clyde Jones [EMAIL PROTECTED]
| Cc: [EMAIL PROTECTED]
| Subject: Re: how to get the correct result -- Thrid Time --
|
| On Fri, 19 Oct 2001, Clyde Jones wrote:
I have been trying to connect to mySQL for a couple of days now with no result! I try
to log in via telnet..to my remote server..I get in the system but when I try to log
in to the database, nothing!! I use this:
mysql -h localhost -u futureenter -p
it then asks for a password, I put it in
I am not aware of any document that describes naming conventions, but
through my use of databases and design I have found a scheme that works for
me. I follow these rules:
1. The autoincrement field (or unique id) for a table is named tablename
++ id. So if the table is books the unique
- Original Message -
From: [EMAIL PROTECTED]
To: Yiu Wing [EMAIL PROTECTED]
Sent: Friday, October 19, 2001 4:14 PM
Subject: Re: Disable Beep
Your message cannot be postsed to mysql@ because it
contained an attachment. If you need to make a file publically available
you should upload
SELL YOUR PRODUCTS OR SERVICES AND MAKE
'BIG MONEY' $$$ WITH OUR EMAIL ADDRESSES
1) Let's say you... Sell a $24.95 PRODUCT or SERVICE.
2) Let's say you... Broadcast Email FREE to 500,000 PEOPLE DAILY.
3) Let's say you... Receive JUST 1 ORDER for EVERY 2,500 EMAILS.
CALCULATION OF YOUR EARNINGS
On Sat, Oct 20, 2001 at 07:40:18PM +0100, Mark Maunder wrote:
Jeremy Zawodny wrote:
so the database server can reuse the old execution plan. Let me
know if you want a example.
That's true for some database servers but not MySQL (yet).
I wasn't aware of that - thanks Jeremy. Any
i am totally new at this and trying to learn mysql. i just got on the list
but i cannot figure out what address to send a question to. how are you
doing it please?
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday,
Hi all,
I'm in the process of writing a searchable mailing list archive in
Perl MySQL.
I'm using Monty's old mail_to_db.pl script (which I got from the
MySQL site long ago) to load emails from their mailbox into MySQL.
Runs just fine, BTW.
However, when I run myisamchk on the mail table,
Hello,
Sorry about the previous message, I made a silly mistake. Now here's the
real one ;-)
Each time when there's something wrong with my statement, I can hear a beep,
which is quite annoying for me . How do I disable the beep sound in the
mySQL prompt. By the way, this is in a Linux box.
- Original Message -
From: [EMAIL PROTECTED]
To: Drops [EMAIL PROTECTED]
Sent: Saturday, October 20, 2001 9:00 PM
Subject: Re: Recover an overwritten password
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter
I've been having this debate in my mind and alternated my method on the
past few projects I've worked on, and now I ask you, the MySQL community.
What is the best way to have a preferences table?
Here's what I've been doing:
Table preferences
basepath varchar(255)
adminemail varchar(255)
and
Jindo,
there seems to be a compiler bug in pgcc. I was able
to get it working by adding some dummy code in function
dict_hdr_get_new_id in file
mysql/innobase/include/dict0boot.ic
Below is a new body for the function. I added a dummy
if in the middle of the the body and then it started to
work.
On 20-Oct-2001 Mike E wrote:
That seems to follow how I've been doing it as well.
For example, consider this database set up:
Table: news
Fields:
newsid int(10)
userid int(10)
dateposted datetime
subject varchar(255)
content text
Table: users
Fields:
userid int(10)
name
Would anyone know of a method to create/fake/move/configure and index on an
alternate disk than the base table? I hail from a platform that allows
specific disk specification for partition, index and alternate key files.
Naturally, I referenced Paul DuBois' amazing book, to no avail.
Just
Martin Heijkenskjöld writes:
I have been trying to connect to mySQL for a couple of days now with no
result! I try to log in via telnet..to my remote server..I get in the system
but when I try to log in to the database, nothing!!
You can't connect to the server via telnet. This is in the
Hi,
I have the solution for this problem.
Before compiling php, edit the /ext/mysql/php_mysql.c file in the php
distribution.
Then remove all the reference to mysql_connect, mysql_create_db and
mysql_drop_db :
function_entry mysql_functions[] = {
//PHP_FE(mysql_connect,
NULL)
On Sat, Oct 20, 2001 at 05:54:28PM -0400, tony.icuc wrote:
Would anyone know of a method to create/fake/move/configure and
index on an alternate disk than the base table? I hail from a
platform that allows specific disk specification for partition,
index and alternate key files.
Hi,
I am encountering a problem while I am updating records of a table.
Basically its a problem of updation of records using pattern matching.
I want all the recods that end with letter s be updated to record
without the letter s at the end. For eg, I want a record things
to be converted to
Oups sorry, bad news :(
In fact it still doesn't works, I compiled PHP with the option --with-mysql,
so PHP used his internal mysql client :(
BTW how can I compile mysql-4.0 with the USE_OLD_FUNCTIONS option ?
Thank you,
Jocelyn Fournier
- Original Message -
From: Fournier Jocelyn
Why is there a limit of 500 bytes on the primary key? (MySQL-Max-3.23.43 on
WinNT).
Is there a way to raise this limit? We have some tables with columns that
are VARCHAR(200), and need to make a primary key based on combinations of
these columns (in some cases, upto 4 columns), and MySQL
Is there a way to raise this limit? We have some tables with columns that
are VARCHAR(200), and need to make a primary key based on combinations of
these columns (in some cases, upto 4 columns), and MySQL complains for all
of these table definitions that Specified key was too long. Max key
Hi Mysqlers,
Does anyone know how to delete double quotes from my entries ''.
I thing you can use regular expressions.
Dexter
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Hi there.
I need advice on which is better to store date/time information on a
database and retrieve data between two given dates.
It appears to be pretty simple to use timestamp, which value is always
bigger as time goes on, and I could compare using logical operators in a SQL
query. Is this
46 matches
Mail list logo