Several posts on other lists are complaining of the same problem I am
seeing.
The "mysqladmin -u root shutdown" command just hangs on both
the 3.23.43 release and 4.0-alpha release for Mac OS X.
Yes, I have verified that:
1) The root account in mysql has Shutdown privilege
2) Its not just the
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 to
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
--
> 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 ke
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 compl
>Description:
getpwent on FreeBSD requires the file /etc/spwd.db to exist in
order for it to be successful. In a chroot'd environment, this
file disappears, and mysqld errors out with a "Can't find user"
error message, even though the user exists on the system.
>How
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 [Pre
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
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.
>
> Na
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)
PH
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
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
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
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.
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
- 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 fi
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.
Th
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, i
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: Saturd
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 varchar(60)
and on and on. I'd love to hear from som
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 J
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
- 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 shoul
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 ide
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 a
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 wrot
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 t
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 union..
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
Umm you need a common package on each and then the server package on the
server and the client package on the client? At least that's how it works
on my machines which all run Linux. Some dist's might package it slightly
differently though.
"All the best people in life seem to like LINUX." --Stev
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/ (
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 havi
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 thi
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-
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 to
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
>
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 03:06:58PM
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
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
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 s
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. (/mysql/mysqlad
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 ch
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.
I
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 terrib
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
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 = tbl_networkpartloc.cCom
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
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 a
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
49 matches
Mail list logo