On Sun, Aug 18, 2002 at 02:32:39AM -0400, Reid Sutherland wrote:
> 'processlist' displays the current list of mysql threads as seen by mysql.
> I'm looking for that same list but in real thread PID form. Right now I
> need to be able to tell which thread is which at a system level. Then I'm
Hi everyone,
'processlist' displays the current list of mysql threads as seen by mysql.
I'm looking for that same list but in real thread PID form. Right now I
need to be able to tell which thread is which at a system level. Then I'm
able to send a SIGKILL to some problem threads.
Is the
On Fri, Aug 09, 2002 at 04:20:42PM -0400, David Miller wrote:
> On Sun, 4 Aug 2002, Jeremy Zawodny wrote:
>
> Hi Jeremy;
>
> I didn't think my server would be doing any name resolution, particularly
> while replace()ing millions of rows in a table. That said,
> --skip-name-resolve *seems* to ha
Hi Folks,
I'm using the following SQL SELECT statement to query a list of labor items.
I'm able to compute my number of hours(thanks Paul) and the line amount
(hours*rate=lineTotal) and now what I would like to do is to keep a running
total for hours and lineTotal. Is there any way I can do that
At 16:23 -0700 8/17/02, Todd Schacherl wrote:
>Hi Folks,
>
>I have a MYSQL table with timeIn and a timeOut columns and I'm trying to
>figure
>out if I can calculate the difference within a SELECT statement. Both
>fields are type TIME (e.g., 00:00:00).
What units do you want the result in? To ge
Hi Folks,
I have a MYSQL table with timeIn and a timeOut columns and I'm trying to
figure
out if I can calculate the difference within a SELECT statement. Both
fields are type TIME (e.g., 00:00:00).
Thanks,
Todd Schacherl
[EMAIL PROTECTED]
One of the penalties for refusing to participate in p
Just created a table with a column named client_nr that is a foreign key
referencing to my Clients table:
CREATE TABLE Contacts (
contact_nrint not null auto_increment,
first_namechar(30),
last_namechar(30),
client_nr char (30),
emailchar(30),
tel_1char(5),
tel_2char(30),
EEK
Tables structures :P
mysql> describe CompanyDetails;
+---+---+--+-+-+
+
| Field | Type | Null | Key | Default |
Extra |
+---+-
Lo everyone,
I seem to be having a problem with the structuring of my query - more
specifically, with the WHERE clause...
mysql> SELECT ZoneName
-> FROM CompanyDNSZones
-> LEFT JOIN CompanyDetails ON
CompanyDetails.CompanyID=CompanyDNSZones.CompanyID
-> WHERE CompanyDetails.Com
Hello,
I am continuing to have what seems to be intermittent problems with
replication. I have attempted to exclude temporary tables from replication
by using ignore wild specifications in my.cnf on both master and slave.
For some unknown reason there are times that MySQL still tries to repli
> sqlst = "update sfproducts set projectdonations = projectdonations +
> &testvalue WHERE prodID = '" & sProdID & "'"
^^
$sqlst = "update sfproducts set projectdonations = projectdomains + " .
$testvalue . "WHERE prodID = '" . $sProdID . "'";
$sqlstr then looks like this:
update sfproducts
Hi
If I do this and projectdonations is say 5
sqlst = "update sfproducts set projectdonations = projectdonations + 1
WHERE prodID = '" & sProdID & "'"
projectdonations then = 6 - great
however the number I want to add is in a variable called test value and
if I do this and say testvalue is 6
Hi.
I'd like to know is it safe to tune mysql-4.0.2/myisam/ft_parser.c
#define true_word_char(X) (isalnum(X) || (X)=='_')
to
#define true_word_char(X) (isgraph(X) && (X)!='@')
Or is anywhere better place to redefine chars which are "accepted" by fulltext search ?
Regards.
--
Grz
That is what PHP / MySQL seems to be doing to the query once it is sent.
I want to pass NULL to the column not a blank field (i.e. "" for text and 0
for numbers). If I do INSERT INTO table SET required_field ="" I get the
same results. NULL means no value at all and "" is a empty string which i
Try this instead:
INSERT INTO table SET required_field =""
> -Original Message-
> From: Dan Tappin [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, August 17, 2002 12:56 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Strange PHP + MySQL add / update issue with NULL values
>
>
> I h
I have a table where I have specified several columns which I have specified
that NULL values are not allowed.
I have created a PHP based create / update / delete page where users can
update the table.
I have an INSERT script that takes the user input and generates the
following query statement.
Where is the Dolphin
- Original Message -
From: "Colin Faber" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 7:59 PM
Subject: For all you people looking for mysql shirts ;-)
> Hi guys,
>
> Just an FYI, We've finally decided to license out our logo to
> Caf
mysqlÄúºÃ!
Ìì½òÊб±´óҽԺǿֱ¿Æ¼Ì³ÐÖйú´«Í³Ò½Ñ§µÄ¾«Ë裬·¢¾ò³öÁËÇ峯Ãñ¼äÌØЧÖÎÁÆÇ¿Ö±ÐÔ¼¹ÖùÑ×µÄ"ÎâÊÏ"ÖÐÒ½ÁÆ·¨£¬ÓÐЧÖÎÁÆÇ¿Ö±¼¹ÖùÑס£
¸ÃÁÆ·¨²ÉÓöÀÌصĽ«Ö²¡Òò×ӰγöÌåÍâµÄ·½·¨,Ó¦ÓÃÏÊÖвÝÒ©Íâ·óÖÎÁÆ£¬ÎÞÐè¿Ú·þ£¬ÎÞ¶¾¸¶×÷ÓÃ,
¸ü²»»áÉ˼°³¦Î¸, Ò»°ãÇé¿öÖ»ÐèÁ½¸öÁƳÌ15Ìì
×óÓÒ¼´¿Éʹ»¼Õß½â³ý²¡Í´¡£
¾
Lo Victoria
FreeBSD 4.6-STABLE (Master), MySQL 3.23.51
Windows 2000 Professional (Slave):, MySQL 3.23.49-nt
I've recompiled the master about three times now, and it still crashed.
Eventually, it came to such a extend that the moment I open port 3306 MySQL
would crash. I can just use telnet 330
Hi!
> "duo" == duo fu <[EMAIL PROTECTED]> writes:
duo> Hi friends:
duo> I try to grant privileges to a user named 'glen' but not succeed. Here is
duo> the script:
mysql> select * from user where User='glen';
duo> | localhost | glen |...
mysql> grant all privileges on test.* to 'glen'@'l
Hi!
> "Daniel" == Daniel Kasak <[EMAIL PROTECTED]> writes:
Daniel> Would it be possible to add a 'drop table' command when a connection
Daniel> which has made a temporary table has been dropped, to make the logs
Daniel> match up with what actually happens? Thanks!
The later MySQL 3.23
Thanks for your input. Especially Tod for breaking it down at the hard ware
level and making me realize what is possible.
I have re-evaluated how this is going to work. Instead of trying this with
one query, I am using 2. I forget somethimes that MySQL is better at
running simple queries reall
Eric,
try using the mysqlbinlog program from some other version, maybe 4.0.0, or
3.23.xx.
I noticed a similar bug a while ago. mysqlbinlog seg faulted on a binlog
file.
I am forwarding this bug report to our replication expert.
Best regards,
Heikki
...
Hi,
I deleted a db I d
Tac,
Saturday, August 17, 2002, 12:57:24 AM, you wrote:
T> A simple query in MySQL 4 that gets a count from 3 inner joined tables:
T> select count(*) as C from quotes q inner join articles a using (article_id)
T> inner join media m using (media_id)
T> article_id and media_id are int(11), and a
Menard,
Friday, August 16, 2002, 8:44:38 PM, you wrote:
M> Me again
M> I found a work around to my problem:
M> select country, count(distinct client_name, client_address, etc..) clients
M> from addresses group by country
M> But I still don't understand why the below would not work. I downloaded
Chris,
Saturday, August 17, 2002, 2:04:40 AM, you wrote:
CK> Lo everyone,
CK> I've implemented replication on my MySQL Server... The master is mysql 3.23
CK> (FreeBSD Ports), and my one and only slave is mysql 3.23 (Win32). I added
CK> the slave so that I can have a hardcopy / backup database
Heikki,
> if you can compile with the gcc -g option and run mysqld inside gdb,
> then
> you probably see in what function and line it crashes.
That's what I am going to do.
> If you just take a connection to mysqld, it does not execute InnoDB code
> at
> all.
Well I was connecting to it before ok
Hello!
I have a problem when I trying to start mysqld (as a root, under RH 7.2).
Allegedly I don't have a rights to run this program...
What I have to do to run mysqld without rebooting system?
Best regards:
Krzychu
---
Super promocyjna oferta dla mieszkancow Krakowa
http://www.promo
Yuri,
- Original Message -
From: "Yuri" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, August 17, 2002 5:13 PM
Subject: Re: InnoDB on FreeBSD-Alpha problem
> Heikki,
> > > I get the mysqld compiling/running
> > > ok. DB dump is restore
Heikki,
> > I get the mysqld compiling/running
> > ok. DB dump is restored ok locally.
> > Locally everything wirks. But it
>
> what do you mean with this? If you issue SQL statements from the same
> computer, they work ok?
Exactly. If I connect via local UNIX socket all
happily works.
If I just
I wish to use mysql to do the rand id generation...
Tom
- Original Message -
From: "David Lloyd" <[EMAIL PROTECTED]>
To: "Tom Gao" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, August 17, 2002 11:59 PM
Subject: Re: generating random integer id
>
> [ mysql, query ]
>
>
[ mysql, query ]
> could someone point me to the right direction please
Are you generating it in MySQL (using sql) or are you using a
programming language to do it?
DSL
-
Before posting, please check:
http://www.mysql.com
hi guys,
I'm trying to generate randomly a number as the primary key the key is to
be an integer in mysql. So like auto_increment I can insert values and the
pk can be generated automatically.
could someone point me to the right direction please
thanks
Tom
33 matches
Mail list logo
