Description:
does not pass value of --socket to mysqld
mysqld does not use environment MYSQL_UNIX_PORT
How-To-Repeat:
change value of socket and execute
Fix:
don't change value of socket
Submitter-Id: submitter ID
Originator:xyy
Organization:
MySQL
MySql Front works fine on XP Home as well.I agree-very helpful tool for a
someone new like me.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
MySQL, as of yet, doesn't support sub-selects !
-Message d'origine-
De : daniel [mailto:[EMAIL PROTECTED]]
Envoyé : jeudi 11 juillet 2002 02:37
À : [EMAIL PROTECTED]
Objet : subselect in an insert
why is it that this doens't work?
INSERT INTO mytable (column0, column1, column2,
Frederick,
Thursday, July 11, 2002, 6:30:34 AM, you wrote:
FRB I had a problem using mysql-max stable versin running
FRB on redhat linux 7.1. The data has been lost every
FRB other day it will come back again. What should I do?
First of all give us some more info...
What do you mean data has
mysqlc,
Thursday, July 11, 2002, 8:31:10 AM, you wrote:
m Description:
m does not pass value of --socket to mysqld
m mysqld does not use environment MYSQL_UNIX_PORT
m How-To-Repeat:
m change value of socket and execute
m Fix:
m don't change value of socket
It
Bennett,
Thursday, July 11, 2002, 6:17:51 AM, you wrote:
BH I have a database in which one MYD file has apparently been corrupted:
mysql use tracerlock;
BH Reading table information for completion of table and column names
BH You can turn off this feature to get a quicker startup with -A
BH
daniel,
Thursday, July 11, 2002, 3:37:07 AM, you wrote:
d why is it that this doens't work?
Because your syntax is wrong. If you want to use INSERT .. SELECT
statement, please, look at the manual for correct syntax:
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
d INSERT INTO
Description:
The tokenizer is not behaving correctly with certain tokens relating to
comments.
Correct Behaviour:
mysql SELECT + /* foo */ 200;
ERROR 1064: You have an error in your SQL syntax near '+ /* foo */ 200' at
line 1
Incorrect Behavior:
mysql SELECT -
Hi all.
Which is the best journaling file system for mysql and innodb?
Ext3, XFS or Reiserfs?
Innodb needs a journaling file system or is better use ext2?
Iago.
-
Before posting, please check:
in INSTALL-SOURCE I saw Reiserfs, but ext3 should do the stuff fairly...
-Message d'origine-
De : Iago Sineiro [mailto:[EMAIL PROTECTED]]
Envoyé : jeudi 11 juillet 2002 10:20
À : MySql Mail List
Objet : Best Journaling file system?
Hi all.
Which is the best journaling file system for
On Wed, 10 Jul 2002, Kevin Fries wrote:
One of our servers (of many running the same software and mysql version) is
frequently getting
ERROR 1030: Got error 127 from table handler
on two of its tables.
mysql version is 3.23.49.
We can not recover with myisamchk -r, but
Hello,
when i change my configfile my.cnf, i have to restart my server. is
there another way without restarting mysqld ?
thanks
Hussein Morsy
Duessldorf,Germany
-
Before posting, please check:
Hello,
I have written a UDF for MySQL in C++ that allows you to use XPath
expressions in your queries. I'd appreciate any ideas anyone might have
about this. It seems like it could be very useful, especially for
databases that integrate XML with relational tables. It requires
the libxml2
EMS HiTech company is announcing the next version (1.8) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What's new in version 1.8?
1. Export Data Dialog
Hi All,
I am running MySQL 3.23.49 on Red Hat Linux 7.3 (installed from rpm included
in RH distribution). I am using ext3 file system. In my my.cfg is
skip-locking.
The system is Intel i810, Intel Celeron 433 MHz, 64 MB RAM. It is used only
as a database server which is accessable only from our
So, you've got a text file with addresses to be deleted? Hmm, that's not too
hard to manage. I suppose that on each line, there is one email address and
only that address? With PHP, i'd do something like:
?php
echo pre;
mysql_connect(host, user, pass);
mysql_select_db(database);
$textfile =
* Richard Fox
This question relates to both mysql in general and the mysql++ C++ API in
particular, thus the adressing to both lists.
I have a DateTime object (really a formatted string) say 2002-07-10
11:38:38. I want to subtract some variable number of hours (from 0 to 11)
from it. How do
I've been handed a 'data.seq' file containing a really useful database.
This is currently hosted on my future employer's site using Oracle. I wish
to look up some of the data there and pull it into my Filemaker database.
I'm using Filemaker for historical reasons and plan to move to MySQL in a
* I was wondering, is there some application for Windows that gives a
frontend to MySQL similar to MS Access? Or maybe connect from
access to
MySQL ? (guess not, right?)
You *can* use MS Access. The MySQL server can be on Windows or Linux or
anywhere you like. You'll need an ODBC driver -
On Thu, 2002-07-11 at 06:47, [EMAIL PROTECTED] wrote:
Hello MySQL list,
I have set up a master-slave replication and am reading the following in the
.err file of the slave:
Error reading packet from server (server_errno=1159)
Where can I find a list of server_errno's and their
Hello All,
I m using linux and gcc complier.
Myodbc driver and itz APIs working fine in my
application to manipulate the database.
I m having one problem.
First i run query Select id...from ...
then I use SQLBindCol to bind the columns after that i
use SQLFetch to fetch the rowset.
then i
[EMAIL PROTECTED] wrote:
Not surprisingly, I'm still confused. Could you hold my hand?
Here's what I've got --
This is my table --
CREATE TABLE churchmail (
email varchar(30) NOT NULL
);
It has one field containing 40,000 email addresses.
I have a text file -- remove.txt, which
No, those are termcap database entries.
Configure is looking for libtermcap or libterminfo int .the /lib directory.
If you are running RedHat Linux you need to install the ncurses rpm.
David Johnston wrote:
When running ./configure I am getting the error no termcap libraries but in
No1.
Sounds like a permission problem. Make sure that you
have that domain in the list of computer allowed to
connect to MySQL. Refer to MySQL manual to get more
information about this.
No2.
PC based application won't run on Linux unless you run
them under an PC-emulator which I don't even know
Naathan wrote:
Hello,
Greetings!
I am trying hard to connect to MySQL database stored on Linux machine
through a
VB program running on windows on another machine.
My problems are ..
Problem No1:
My Windows machine is under a Windows NT domain.
Linux machine is under another Windows NT
I have installed mysql on OS X server. I used the pkg install.
Everything appears to have run fine except when I do safe_mysqld the
daed starts and stops. See error log below.
Any ideas?
020701 19:46:50 mysqld started
020701 19:46:50 /Library/mySQL/libexec/mysqld: Table 'mysql.host'
Dough! They started behaving like big corporations
already; certification, consulting, etc, etc.
:-)
--- Defryn, Guy [EMAIL PROTECTED] wrote:
I was wondering if anybody heard about a possible
release of books that help you prepare for the Mysql
certification?
Cheers
New error msg, I think I have permissions right
020711 08:37:57 mysqld started
020711 8:37:57 /usr/libexec/mysqld: Can't create/write to file
'/usr/var/e-mac
.pid' (Errcode: 13)
020711 8:37:57 /usr/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno
: 13)
020711 8:37:57
I need to use the C++ API for mysql under a Linux system.
I compiled the tarball downloaded from mysql.com/Downloads but
I get several errors during compilation of C++ code.
Can anyone supply some information.
Thanks.
-
Before
Bhavin,
I am using distinct all 15 fields and order by all 15 fields, but there is
different order on 15 fields for distinct and order by.
Thanks
At 08:24 PM 7/10/2002 -0700, Bhavin Vyas wrote:
Via mysql, you are trying to do a distinct 'field1'. So any field1
duplicates will be removed. Where
Attn: mysql ,
My name is Mr. Oluwafunmi G, the manager, credit
and foreign bills of Ecobank Plc. I am writing in
respect of a foreign customer of my bank with account
number 14-255-2004/utb/t who perished in a plane crash
[Korean Air Flight 801] with the whole passengers
aboard on August 6,
This opens so many possibilities ... manage MySQL tables in MS Access using
MyODBC. Guess this works for remote MySQL servers too?. Almost don't dare to
ask, but is this also possible from PostgreSQL? I'm in two situations with
alike problems, one using MySQL and the other one PostgreSQL .. I'll
Dear MySQL user,
During 2002, MySQL AB will release two levels of official MySQL
certification: MySQL Core Certification and MySQL Professional
Certification. This e-mail describes the upcoming program as
well as some of your opportunities.
Contents
1. The MySQL Certification
sql,query
How can i have each users database to be stored in it's home dir ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
On Thursday 11 July 2002 04:20 am, Iago Sineiro wrote:
I vote for Reiserfs personally. I've been running it for a year, its totally
stable, and reasonably fast. ext3 is OK as well, but its slower and at least
in theory does not provide an absolutely guaranteed consistent file system
100% of
As i selling web hosting with mysql as a package, and i like to restrict on
the amount of space used. I had setup quotas on the plans. How can i create
databases to the user's account, home dir, so that the customer can check
his quota.
Or how should i go about restricting?
sql,query
A. John Peters wrote:
New error msg, I think I have permissions right
No you don't.
Mysql must own the database directories and files.
020711 08:37:57 mysqld started
020711 8:37:57 /usr/libexec/mysqld: Can't create/write to file
'/usr/var/e-mac
.pid' (Errcode: 13)
020711
Do not give your bank details to anyone offering large amounts of money for
nothing.
What normally happens is that you give your details over - then you are
sucked dry - watch out.
Regards
Watch out mysql list
-
Before
Hi everybody,
I've got a MEDIUMBLOB column in a table, where I want values to be unique. So
I made it UNIQUE.
When my program wants to enter a value, it first does a select * from table
where column =x in order to see if x already exists, if not, it does an
insert. Now the interesting point:
Setup a user level my.cnf file and make sure the data dir isn't overriden by
the other levels of my.cnf
Just a theory, I haven't tested it !
-Original Message-
From: Info [mailto:[EMAIL PROTECTED]]
Sent: 11 July 2002 15:17
To: [EMAIL PROTECTED]
Subject: Re: creating database
sql,query
UmI don't think anyone (or hope noone) on this list is stupid
enough to get sucked in by a piece of spam.
--
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Thu, 11 Jul 2002 15:39:33 +0100
Kevin Passey [EMAIL PROTECTED] wrote:
Do not give your
You can go this link and get MySQL in package form it works great...
http://www.entropy.ch/software/MacOSx/mysql
Hope this helps.
Chuck Payne
Magi Design and Support
http://www.magidesign.com
-
Before posting, please check:
Hi all,
I am getting the error when trying to connect server from my client:
ERROR 1044: Access denied for user: '@NRICRIV1.ad.rivenet.com' to database
'mysql'
any answer?
thanks,
anjani
-
Before posting, please check:
A.,
Thursday, July 11, 2002, 4:36:40 PM, you wrote:
AJP I have installed mysql on OS X server. I used the pkg install.
AJP Everything appears to have run fine except when I do safe_mysqld the
AJP daed starts and stops. See error log below.
AJP Any ideas?
AJP 020701 19:46:50 mysqld started
Thomas,
Wednesday, July 10, 2002, 3:40:40 PM, you wrote:
TS On Wed, 10 Jul 2002, Victoria Reznichenko wrote:
oliver,
Wednesday, July 10, 2002, 2:33:06 AM, you wrote:
Description:
o I was trying to find every row in a table which contains the umlaut
o ü (ue). MySQL listed
robbat2,
Thursday, July 11, 2002, 11:57:16 AM, you wrote:
Description:
r The tokenizer is not behaving correctly with certain tokens relating to
comments.
r Correct Behaviour:
r mysql SELECT + /* foo */ 200;
r ERROR 1064: You have an error in your SQL syntax near '+ /*
Wouter,
Thursday, July 11, 2002, 2:23:55 PM, you wrote:
WvV * The mysql index and data files, can they be exchanged from a Windows
WvV Platform to Linux? Need they be prepared in some way maybe?
In general you can just copy files and then check permissions. But
usage of mysqldump is more
Jan,
Thursday, July 11, 2002, 1:25:11 PM, you wrote:
JK I am running MySQL 3.23.49 on Red Hat Linux 7.3 (installed from rpm included
JK in RH distribution). I am using ext3 file system. In my my.cfg is
JK skip-locking.
JK The system is Intel i810, Intel Celeron 433 MHz, 64 MB RAM. It is used
MySQL,
This is a bug, isn't it?
mysql select 798 between 75.2 and 999.1;
++
| 798 between 75.2 and 999.1 |
++
| 1 |
++
1 row in set (0.01 sec)
mysql select 798 between 75.2 and 1e30;
a and b r not tables but views. i am using multiple views .
The sql for the views are as follows:
CREATE view cch_dubber_dublist_view_a1 as select distinct
a.playlist,a.material_id,a.destination_locator,a.destination,a.air_time,a.traffic_duration,a.comment,a.title,a.device_name,m.media_locator
Probably execution with nice will help.
Edwin Wang wrote:
I want to find a way to limit how much of a system processor (cpu) the
mysql server will use, so that I don't run the risk again of having
googlebot or other web robots interrupt my other server operations in my
computer.
Thank you
This is not possible.
Info wrote:
sql,query
How can i have each users database to be stored in it's home dir ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi!
First of all, MEDIUMBLOB type is case-sensitive.
I checked this sequence and everything worked as
expected. I think you have a mistake in your table.
What does SHOW CREATE TABLE table give?
Second, there is no needs to check that the value is already
presents using SELECT just to avoid
It means you don't have enough privileges to access
'mysql' database. You can add these privileges using
GRANT command under user 'root' (or under another
superuser). Check manual, the section about privileges.
anjani.sinha wrote:
Hi all,
I am getting the error when trying to connect server
On Thu, 11 Jul 2002, Victoria Reznichenko wrote:
robbat2,
Thursday, July 11, 2002, 11:57:16 AM, you wrote:
Description:
r The tokenizer is not behaving correctly with certain tokens relating to
comments.
r Correct Behaviour:
r mysql SELECT + /* foo */ 200;
r
filter: sql, mysql, query *bites filter :-]*
Hi gang.
I have the following problem facing me: Currently, we are utilizing
mysql to handle our business data needs. To this end, we have lots of
customers who access their data through a web-based interface. That
accounts for probably around
I'm running PHP 4.1.2 and MySQL 3.23.39. I have a simple query that works if
I telnet into MySQL and run the query manually. If I try and use it in a PHP
page, I get the Supplied argument is not a valid MySQL result resource
error. However, if I take out the ORDER BY RAND() part from the query,
But the default table type is already MyISAM
That is the normal behavior for ISAM type files.
Convert them to MYISAM.
Richard Fox wrote:
Hi,
I have a mysql table which has a run_id which together with user_id
forms
the
primary key for the table. run_id is not null and
Sure it is. It's just TRICKY. :)
step 1. Create database.
step 2. Move database to users' homedir
step 3. Symlink $USERHOME/databasedir/ to $MYSQLDATADIR
Alexander Barkov wrote:
This is not possible.
Info wrote:
sql,query
How can i have each users database to be stored in it's
I tried to automate the starting and stopping of the mysql service upon
reboot. I created the two links for mysql.server to the associated rc.d
directories(rc0.d and rc3.d). I rebooted my RH 7.2 box and nothing
happened. The real kicker is that I cant even manually start mysqld mysqld
start.
first make sure there is a mysql.sock file in var/lib/mysql;
second make ps -ef | grep mysqld --if the output is xxx xxx xx grep mysqld
then the server is down for sure
third go to the binary of mysql and execute safe_mysqld (means it forks
itself and is running in the background
Thank-you Chuck, Ralf, Phil, Daniel, and Wouter. All your great advice worked,
and helped me device a method of attack. What I eventually did was edit the text
file itself, with vi, to add delete from churchmail where email = ' to the
start of each line, and to add '; to the end of each line,
[snip]
I'm running PHP 4.1.2 and MySQL 3.23.39. I have a simple query that works if
I telnet into MySQL and run the query manually. If I try and use it in a PHP
page, I get the Supplied argument is not a valid MySQL result resource
error. However, if I take out the ORDER BY RAND() part from the
What does your PHP code look like ? It might be a syntax problem inside PHP
-Message d'origine-
De : Jamie Tibbetts [mailto:[EMAIL PROTECTED]]
Envoye : jeudi 11 juillet 2002 18:22
A : [EMAIL PROTECTED]
Objet : ORDER BY RAND() not working
I'm running PHP 4.1.2 and MySQL 3.23.39. I
$id = mysql_query(SELECT * FROM products WHERE sale_price IS NOT NULL ORDER
BY RAND() LIMIT 3,$link) or die(mysql_error());
PHP code:
$result = mysql_query(SELECT * FROM products WHERE sale_price IS NOT NULL
ORDER BY RAND() LIMIT 3) or die(mysql_error());
The error message is as follows:
You
i'm just wondering why when i hit 'reply' to a message on this list, that it
goes to the individual sender, and not the list itself. doesn't that defeat
the purpose of a mailing list? aren't all responses to a post supposed to
be threaded on the list rather than stored in the original sender's
You should be using 'safe_mysqld ' (v3.2) or 'mysqld_safe ' for v4.0.
Did you look at the hostname.err file to see what the problem was?
This file should be in the same location as hostname.pid file.
-Chait
-Original Message-
From: David Kramer [mailto:[EMAIL PROTECTED]]
Sent:
What causes this error when trying to replicate mysql server:
020711 10:50:50 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'jupiter-bin.001' at
position 1262
020711 10:50:50 Error reading packet from server: log event entry
exceeded max_allowed_packet -
Got it on a none server machine I had typed my chown without the /P at
the end.
Also used the package from entropy. I may have used it before.
John
On Thursday, July 11, 2002, at 08:43 AM, A. John Peters wrote:
New error msg, I think I have permissions right
020711 08:37:57 mysqld
[snip]
PHP code:
$result = mysql_query(SELECT * FROM products WHERE sale_price IS NOT NULL
ORDER BY RAND() LIMIT 3) or die(mysql_error());
The error message is as follows:
You have an error in your SQL syntax near 'RAND() LIMIT 3' at line 1
[/snip]
Using;
$query = select * from tblBAR WHERE
I would use this query:
SELECT DISTINCT SUBSTRING(email,LOCATE('@', email) ) FROM AddressList ;
Cheers,
Kent
sql, query, y'hear
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Thu, Jul 11, 2002 at 10:28:39AM -0700, daniel wrote:
i'm just wondering why when i hit 'reply' to a message on this list,
that it goes to the individual sender, and not the list itself.
doesn't that defeat the purpose of a mailing list? aren't all
responses to a post supposed to be
In the last episode (Jul 11), daniel said:
i'm just wondering why when i hit 'reply' to a message on this list,
that it goes to the individual sender, and not the list itself.
doesn't that defeat the purpose of a mailing list? aren't all
responses to a post supposed to be threaded on the
Under redhat you can type setup and choose the services you want to
start during boot.
Justin Best
NOC - Infostations
On Thu, 2002-07-11 at 09:45, David Kramer wrote:
I tried to automate the starting and stopping of the mysql service upon
reboot. I created the two links for mysql.server to
Most likely this will solve your problem. This comes right from the mysql website
documentation. It is for the C API but I'm sure the same concepts go for C++ as well.
If this doesn't work provide more info on the program you are using for coding and the
errors you are getting. Thanks.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 11, 2002 12:01 PM
To: Roma
Subject: Re: How do i unsubscribe from the mysql list
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
Hi!
InnoDB is a MySQL table type which provides transactions, row level locking,
automatic crash recovery, foreign keys, and hot backup capability to MySQL.
InnoDB is included in all distributions of MySQL-4.0, not just in
MySQL-Max-4.0.
Since InnoDB in MySQL/InnoDB-4.0.1 was the same as
Just to clarify, I should always boot mysql using safe_mysqld, I thought
this was used only for setting up your initial database and setting the root
password. Most Documenation I found said to use it mysql.server as the
start up process..
Thanks for the Help!!!
DK
-Original
Here's a small script to use for automaticly starting the mysqld demaon. Cut and Past
it into a file and call it mysqld then save it in the /etc/rc.d/init.d directory. Upon
reboot you should see that you mysql server is up and running ( use ps -A as root and
look for the mysqld pid's). As for
[snip]
I am just wondering, how can i unsubscribe from this list. I am sure, i can
block this email address, but i would prefer to unsubscribe. anybody has the
instructions. I would really appreciate that
[/snip]
Uhlook at the message footer, where it says To unsubscribe, e-mail
I have three tables, affiliates, clients, and sales.
The affiliates table stores all of the information about affiliates,
clients about clients, sales about sales. In the clients table, there is
a field for affiliate_id (affiliates refer clients), and in the sales
table there is a field for
Hi,
I have a MyISAM table which has a run_id which together with user_id forms
the
primary key for the table. run_id is not null and auto-increment. I delete
records from this table, and add new records. I want the run_id to keep
incrementing and not reuse values, but here is the actual
Hello All,
I'm having trouble with ordering. I've got data in a varchar field that
currently gets ordered like this when I use 'order by myfield asc':
aristo 1001
aristo 156
aristo 222
I'd like it to order like this:
aristo 156
aristo 222
aristo 1001
How can I do this in MySQL? Is there a
On Thu, Jul 11, 2002 at 08:32:28AM -0500, Gerald Clark
[EMAIL PROTECTED] wrote:
Naathan wrote:
I am getting the following error message like .
[TCX][MyODBC]Host local id address is not allowed to connect this MySQL
server
Kindly let me know how to connect the MySQL database stored on
To summarize: I was getting a cannot connect through
socket... error. It would appear that the server is not running and the
socket doesn't exist. So I tried to start the server (as root) using
safe-mysqld and mysql.server start, but in either case I recieve the
message:
chown:
OOPS!
Bob Bell wrote:
On Thu, Jul 11, 2002 at 08:32:28AM -0500, Gerald Clark
[EMAIL PROTECTED] wrote:
Naathan wrote:
I am getting the following error message like .
[TCX][MyODBC]Host local id address is not allowed to connect this MySQL
server
Kindly let me know how to connect the MySQL
Use adduser, or the appropriate command for your version of UNIX to
create the mysql account.
Alex Jarvis wrote:
To summarize: I was getting a cannot connect through
socket... error. It would appear that the server is not running and the
socket doesn't exist. So I tried to start the
Try the following:
safe_mysqld --user=mysql
Also make sure that your data directory is readable and writeable by the
mysql user.
the socket file is generally just named mysql.sock and it would be in your
/tmp dir.
-Original Message-
From: Alex Jarvis [mailto:[EMAIL PROTECTED]]
I have three tables, affiliates, clients, and sales.
The affiliates table stores all of the information about affiliates,
clients about clients, sales about sales. In the clients table, there is
a field for affiliate_id (affiliates refer clients), and in the sales
table there is a field for
I don't think it's impossible. It might be nicer if you could use a
sub-select. But here's join.
SELECT DISTINCT affiliates.id, DISTINCT
sales.client_id,SUM(sales.client_id)
FROM affiliates,clients,sales
WHERE affiliates.id = clients.affiliate_id AND sales.client_id =
Hi.
I am trying to set up a mysql replication master servers in a circular
format in
different geographical locations (Los Angeles, New York, Chicago, and
Houston) but the client wants to keep working on the database and catch up
with the rest of the offices should there ever be a network
I am new to MySQL and I was trying to find out how to setup a record
with a datatype as a image jpg etc...
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello,
I am running mysql on linux and I have too many mysqld-max processes running
at the same time. Why is that and what can I do about it apart from killing
the processes after every boot?
Thanks in advance,
Balteo.
-
Greetings,
I am stuck with this problem:
I have the following table:
event_id time
1002000-10-23
1002000-10-23
1012000-10-24
1012000-10-25
I need to know all event_id's that have multiple times + time columns. Is it
possible to get that result in just one
They're threads. It's the way linux does threads. You only have 1
running.
[EMAIL PROTECTED] wrote:
Hello,
I am running mysql on linux and I have too many mysqld-max processes running
at the same time. Why is that and what can I do about it apart from killing
the processes after
Hi there,
I've just moved up from non-free os's to debian linux, and installed
a couple of database programs with the hope of getting started on some
projects I've been
thinking about. Several of these projects involve web archives. The
idea is, a url is entered with a bunch of
On 11 Jul 2002, at 17:41, Witness wrote:
SELECT DISTINCT affiliates.id, DISTINCT
sales.client_id,SUM(sales.client_id)
FROM affiliates,clients,sales
WHERE affiliates.id = clients.affiliate_id AND sales.client_id =
clients.id;
I don't think that's what Daren wanted. For one thing, I
Description:
i set up replication according to the directions in the manual. i have
repeatedly ensured that all the tables are synced up and the logs are
cleaned before restarting. it seems to work, but the slave is constantly
generating these errors:
020711 17:18:10 Error reading packet
Matt,
I tried this and still no cigar. The only difference that I could see was
that the mysql.server file location was different, i.e.
/usr/local/share/mysql/mysql.server, mine exists in
/usr/share/mysql/mysql.server. I altered the script to reflect this but
still the process does not start.
How about:
SELECT
event_id, time,
count(DISTINCT time) AS Ranges
FROM
events
GROUP BY
event_id HAVING Ranges 1
- Original Message -
From: Mihail Manolov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 11, 2002 2:58 PM
Subject: Help - query
1 - 100 of 114 matches
Mail list logo