Will do. Thanks!
--Walt
On Sun, May 17, 2009 at 2:37 PM, Baron Schwartz ba...@xaprb.com wrote:
Walt,
I mentioned your question to Vadim Tkachenko who knows the most about
it, and he suggested that it might be more appropriate to discuss on
the percona-discuss...@googlegroups.com mailing
could give me some information, or point me to some good
documentation, It would be much appreciated.
Thanks,
--Walt
turned on the slow query log ?
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
Once you have logged slow queries, than you can run explain on them and
possible tune your indexes better.
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
-p
mysql show tables;
Empty set (0.00 sec)
mysql
Thanks !
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
directory. Once you've done that,
the machine will boot and maybe you can find something in the mysql
error log. If you don't see anything there, adding strace to the mysql
startup script might give some more info which would be helpful in
solving your problem.
walt
--
MySQL General Mailing
file on that system. I don't know
how it got there. By looking inside the file it appears to be related
to MyODBC 3.5.11.
Just for kicks I copied this file to the second system, but got the same
error when trying to run ./configure.
Any ideas?
-Ryan
Ryan,
It's part of unixODBC-devel
walt
, show me which tree to bark at?
Thanks,
--Walt Weaver
Bozeman, Montana
Walt Weaver wrote:
Hi,
I have a job runnning that's modifying a column on a 15-million-row table
and is throwing out the following error:
Output: Replication Error 1114, slave: replicatenj07, error: Error 'The
table '#sql-5303_3c' is full' on query. Default database
'customer__upgrade'. Query
Thanks, as it turns out the solution to the problem was a bit more mundane:
we ran out of disk space on the partition the tables are on. :)
--Walt
On 10/11/05, walt [EMAIL PROTECTED] wrote:
Walt Weaver wrote:
Hi,
I have a job runnning that's modifying a column on a 15-million-row table
a company
just because he's caught up in the groovy sunshine world that's Open Source.
And, as an employee of a company that's very, very heavily committed to
MySQL (we're just about completely moved off of Oracle and are using InnoDB)
this whole thing leaves us rather worried.
Thanks,
--Walt
Here's a SQL statement that converts dates to epoch time in Oracle.
I'm too lazy to convert it to MySQL but it should give you a start.
select 86400 * ( to_date('14-feb-2000 10:38:39', 'dd-mon-
hh24:mi:ss')
- to_date('01-jan-1970', 'dd-mon-') )
from dual;
--Walt
to a text file and then use a perl
script to look for insert into table_name or update table_name and keep
reading lines until you hit a ;.
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
We've run into a problem where binary char column types crash our c++
application when migrating from RedHat 7.3 to RedHat ES. Is there a way to
specify the data type to be returned in the select statement. In the below
example, selecting office_id will crash the app if it's left as a binary
the appropriate patches on Oracle can make a big
difference too.
--Walt
-Original Message-
From: Jaime [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 16, 2004 4:59 AM
To: [EMAIL PROTECTED]
Subject: MySQL vs Oracle
Hi all!
I'm developing a system using both MySQL and Oracle
It's probably not odd.
Does every query take 10 seconds to execute, or is that how long it
takes to return data?
Why don't you run tkprof on the Oracle queries to see how long they
actually take to complete?
--Walt
-Original Message-
From: Jaime [mailto:[EMAIL PROTECTED]
Sent
Perl/DBI is a possibility.
--Walt
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 8:48 AM
To: [EMAIL PROTECTED]
Subject: ORACLE to MySQL migration
Hello colleagues,
I have to migrate a lot of ORACLE 8.1.7 databases to MySQL
I used to program with VB using MS access as the db. VB was very quick to develope
nice looking forms. Which language would be the best to use with mysql to create
similiar forms. These forms would be for scrolling through the db, adding, updating,
deleteing, printing...
Walt
I am new to mysql and started a tutorial for it and php. Mysql is running ok on my
redhat server. I thought VB might be to unstable. VB is easy to use but I think its
not web based. Also all the job adds I see want mysql and php.
thanks for responding
Walt
- Original Message -
From
that could up date the db woul dbe
nice. The big question is where to begin, which language to use for a simple form and
how to hook the form to the db.
tia Walt
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: Walt [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, February 20
Those were my exact thoughts being a former cne and msce. I know how to write the
code whatever form I want, web based or standalone, I can also create the necessary
db in mySql but how do they get hooked up?
Walt
- Original Message -
From: Donny Simonton [EMAIL PROTECTED]
To: 'Walt
I need a little advice on where to get started. I want to create a db and simple form
that will populate the db. Which language is best? What should I read to help me
along?
tia Walt
Pete,
I was just glancing at this and it looks like you have about 13.5GB of
memory allocated on a 8GB machine (4096+4096+512+4096+1024).
Are you swapping badly??
walt
Lancashire, Pete wrote:
I'm doing some tests on a small Sun server, a 280R to demo
MySQL vs. Oracle. For the demo I using
) UNION (SELECT FROM table WHERE
condition2);
walt
Bill Marrs wrote:
I've noticed that If I use an OR in my query, mysql seems to choose not to
use my indexes. Though, it would seem to help (as, if I do the query in
two steps, I can get faster results than as one query).
Is there some way I
Ross,
rpm -qlp package_name.rpm will list all the files in an rpm for you. You
may
need to install the client rpm as well.
walt
Ross O wrote:
I was able to successfully install MySQL server 4
under windows, but am a little confused about doing it
through linux.
My main confusion
Or use an outer join with where members.list_id is null, as was
mentioned on the list earlier today.
--Walt
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 3:18 PM
To: [EMAIL PROTECTED]
Subject: Re: A challenge I think
Hi
.
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Xavier Fernández i Marín wrote:
Hi,
I've been inserting a csv file of about 150Mb into a mysql database. The
problem is that there is no enough free space on the hard disk, and the
process have been collapsed.
Now I've been trying to access to the database to drop the table and change
on the tables since mysql has crashed.
walt
Birju Shah wrote:
Hello,
Thankyou for your quick response.
When I start getting this error, the mysql crashes, any application which I
try to start which uses mysql backend, says mysql.sock error could not
connect .
-
DBI connect
correctly. What is the -number supposed to be?
walt
On Wednesday 14 January 2004 05:03 am, you wrote:
Hello Walt,
I did and it says the following
mysql -u websquash -number
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
One more thing, I just saw
PROTECTED]
---
In theory there is no difference between theory and practice. In practice
there is.
- Yogi Berra
---
Joshua,
The key buffer is not used for innodb tables. innodb_buffer_pool_size is
where you want to do your tweaking.
walt
--
MySQL General Mailing List
For list archives: http
as the OS root user.
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hope this helps!
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
before posting, so if
I missed a prior post forgive me.
-walt
.
The machine is a Dell PowerEdge 4400 with 2 Xeon 1G processors and 2GB of memory.
There are 4 disks running raid 0+1. Attached the my.cnf for your easy review. Thanks
a lot in advance.
snip
Rainer,
The 12+ load avg. is HIGH. What is % idle when the load average is
high?
walt
--
MySQL General
- http://otl.sourceforge.net/home.htm
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does anyone know if it is better to have 1 large innodb datafile on a disk or
if it is better to have a few smaller datafiles?
Here is what I have. Both drives are 15K scsi running at full 160MB/S speed.
/var/lib/mysql/ - contains all myisam tables as well as a 1GB innodb
datafile.
/mysql2 -
I'd bump up these two settings.
innodb_buffer_pool_size=32M
innodb_additional_mem_pool_size=16M
I'm not sure what the max is on innodb_buffer_pool_size,
but that is where innodb caches data. The more that is in cache
means less disk reads which equals speed.
walt
K Old wrote:
Hello
it where it runs in a
continuous loop checking every X seconds or use the cron daemon to
launch the script. The advantage to using the cron daemon is that daemon
will email you if something goes wrong in your script.
Just my $.02
walt
--
MySQL General Mailing List
For list archives: http
On Tuesday 05 August 2003 09:06 am, Richard Gabriel wrote:
My database experiences a similar effect, but I can't pinpoint the specific
queries because it gets thousands per second. I have not noticed the
problem on a machine that is only used occasionally. Is there a way to get
queries out
Fabio Bernardo wrote:
Hi there,
Do you know a sql command which I can write to obtain the last date that I
updated a table
Fabio,
mysql SHOW TABLE STATUS LIKE 'table_name'
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
On Wednesday 06 August 2003 11:50 am, Andy Smith wrote:
There is one more thing I can think of to check...
Can you send me a copy of the
master.info file. I've had to manually change it before after changing
the master in the my.cnf file. I found out later that you could do
CHANGE MASTER
On Tuesday 05 August 2003 08:58 am, Jonathan Patton wrote:
Walt,
Thanks for the suggestion. I ran myisamchk on the table and it said it was
corrupted. So I ran myismachk on the table with the -r and it said the
table was fixed. I then ran the update queries I was running before and
received
On Wednesday 06 August 2003 11:13 am, Andy Smith wrote:
On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote:
On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote:
Andy,
I don't see
log-slave-updates
in your master setup. I see log-bin, but I think that only applies
On Wednesday 06 August 2003 11:26 am, Andy Smith wrote:
Andy,
I just noticed that you have
a mix of port numbers. Can you try
`netstat -an | grep 3306`
from the command line and see if the master is indeed listening on that
port?
$ netstat -an | grep 3306
tcp0 0
,
Have you tried running myisamchk on the database in question before
running queries on it?
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
first.
create database sampdb
then do the grant all
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Monday 04 August 2003 02:10 pm, Richard Gabriel wrote:
I have been getting this type of error ever since I upgraded from MySQL 3
to 4. I actually have set up a cron to check/repair tables hourly because
of this. The following diagnoses have been suggested, but I would bet it's
an obscure
you tried adding
[mysqladmin]
user=root
password=blabla
to the .my.cnf file for the user running the script?
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is the script we
use to backup all of our tables except for 100_PATS and 400_PATS as
those tables are dropped and reloaded everynight anyway.
Hope this helps!
walt
#!/bin/bash
cd /var/lib/mysql/NEA/
FILES=`ls *.frm`
for file in $FILES; do
LEN=${#file}
STRIP=$((LEN -4))
table=`expr substr $file 1
Anthony,
Try adding this to the my.cnf file
set-variable =sort_buffer=30M
walt
arobins wrote:
I would like to change the sort_buffer variable but
that variable doesn't seem to be configurable.
i.e.
I get the following when doing mysql --help.
Don't understand why only these variables
MySQL technical support from https://order.mysql.com/
That is great news! Will a single table be able to span several
datafiles?
Thanks!
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Andrew,
They will roll over. We're at -bin.1268
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the machine is under a high I/O load.
Have you considered using 15k rpm drives? Is your raid setup hardware or
software?
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
images from fileserver a and 1999
images from fileserver b, etc... The OS on each fileserver can then
cache what is requested most often.
Good luck!
walt
-
Before posting, please check:
http://www.mysql.com/manual.php
because it's fast and
you don't have to deal with pointers.
walt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
On Wednesday 19 March 2003 12:38 pm, Dan Nelson wrote:
In the last episode (Mar 19), Philipp said:
i just talked about openmosix because i read about shared memory
segments. my only desire is to make mysql able to spawn 1000-1500
connections and *not* to tell my client cant create new
if changing those values will
help.
Does your syslog say anything when these problems occur?
walt
walt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sherif,
What version of RH and what version of mysql? Does the mysql error log
show anything?
Does the syslog show anything strange?
walt
-
Before posting, please check
user connected to the db, but we could handle requests from
multiple
web servers).
Hope this helps!
walt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
it bogs down and test all running queries on another system
and see if
you can tweak them or move the logic out of the database into the actual
code
that's making the query.
Hope this helps!
walt
-
Before posting, please check
Smurf wrote:
Description:
select distinct FOO from BAR reports multiple NULL rows
How-To-Repeat:
Unknown. It's a large table (1 entries or so). The problem
didn't show with a simple test table.
The table:
-- MySQL dump 10.0
--
-- Host: localhost
Paul DuBois wrote:
At 10:34 -0500 3/13/03, Keith C. Ivey wrote:
I am curious why a DATE takes 3 bytes and a TIME takes 3 bytes, but a
DATETIME takes 8 bytes, even though TIME covers a much greater range
than the time part of a DATETIME, but that's just one of the
mysteries of MySQL that's
email. Are you able to connect to the master?
If so, the only Privileges you should have are replication unless other
Privileges have been
granted to userforreplica.
walt
-
Before posting, please check:
http://www.mysql.com
://lists.mysql.com/php/unsubscribe.php
Paul,
Why are you running Client 3.23.36? As far as the error goes, it looks like you
need to run something like this
on the master
GRANT SOME_PRIVILEGE ON database_name to [EMAIL PROTECTED]
or
GRANT ALL PRIVILEGES ON database_name to [EMAIL PROTECTED]
walt
and false
values like below
('123673852','False','E : JUST an ID CARD','False',
'Dental','8/19/2001','True','TN','??',0,0,'TX','True','False','False','False','False','Fa
lse',1,'NotRequested','N1TN236012')
walt
-
Before posting
wrote which archives the logs in 2 places. We run it every 5
minutes from the cron dameon
It's designed to check a slave database located 40 miles away before moving the
logs. Since you are not keeping
the logs around, you may want to change the mv command to rm.
Hope this helps!
walt
#!/bin/bash
I ran into a problem a few weeks ago with a query that would take up to 2
minutes to return 0 rows found when selecting anything other than the primary
key (0 rows is correct). When I selected just the primary_key, the query
would take less than 3 seconds. The 2 columns involved in the where
and what OS?
walt
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
(http://www.somewhere.com) when
you pull them from the db?
If so, you'll still have to build the a href part in the html so it is
infact a hyperlink.
walt
-
Before posting, please check:
http://www.mysql.com/manual.php
to look for
\n
walt
sub nea_quote
{
my ($input) = @_;
if (length($input) == 0)
{
$return_string = NULL;
return $return_string;
}
else
{
$return_string = $dbh-quote($input);
return $return_string;
}
}
-
Before
I've run into an interesting problem. I have a large innodb table (2274962
rows, 46 columns, 2 datafiles - 4.5GB total).
When I run a query that uses a clustered_index in the where clause and the
data I'm selecting is not the primary key of the table, it takes up to 2 1/2
minutes to return
Peter Zuidema wrote:
Please help,
We have big performance problems.
This is the situation:
We haven an Windows NT server with a P355 processor and 256MB Ram. We have
installed version 3.49 of mysql
(we have also tried version 3.52).
When we do a select on a table which contains about
, but
is in the 1.2.4 How Big Can MySQL Tables Be?. I don't know if there
is any problem or change like this need for InnoDB, since Innodb is
not mentioned I would suspect it is not needed.
walt
-
Before posting, please check:
http
mysql_install_db. You shoud be able to start mysql
from the script
/etc/init.d/mysql
walt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
the master and the slave. Then delete log files on the master including the
*.index file. I'd then delete
any files on the slave that deal with replication (master.info).
Once all this is done, try restarting the master
to see if it still has problems.
walt
://lists.mysql.com/php/unsubscribe.php
Petre,
If you run
netstat -an |grep tcp
do you see that the mysql port (3306 ) listening?
Also, even if you dont have a firewall,
if you run
iptables -L
does it show all rules set to ACCEPT?
walt
On Tuesday 22 October 2002 03:41 pm, Petre Agenbag wrote:
Hi Walt
Thanks for the quick reply.
Answer to both questions is yes.
As a matter of interest,
What I usually do is to create a myodbc db with a myodbc user and
password myodbc
I create this db and user with the mysql_setpermission
something like this to your .bashrc
sq ()
{
/usr/bin/mysql -u user_name database_name $1
}
which will let you do
sq file_name_with_sql
walt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
still like to know for future what causes this, as I'm to
decide soon what to upgrade to, 7.3 or 8.0, at this point, I'm leaning
heavily towards 7.3 as my gutt tells me this might be some kind of a
bug.
Thanks for the help so far.
On Tue, 2002-10-22 at 22:07, walt wrote:
On Tuesday 22
Heikki Tuuri wrote:
Walt,
- Original Message -
From: walt [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Saturday, October 12, 2002 11:20 AM
Subject: innodb not using correct index
Is there a way to find out what index an sql query is using? I know you
can
use
On Tuesday 15 October 2002 10:59 am, Heikki Tuuri wrote:
Walt,
- Original Message -
From: walt [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 5:56 PM
Subject: Re: innodb not using correct index
Heikki Tuuri wrote
with
numeric fields.
walt
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Jesse,
Check out
http://www.faqchest.com/prgm/mysql-l/mysql-00/mysql-0012/mysql00122707_12134.html
and search for curse
Found it using google
walt
[EMAIL PROTECTED] wrote:
Hi everyone!
I'm trying to build /mysql-3.23.53 on a sparc Solaris 9 box but
without any luck
Please guys can anyone give me an idea about?
Any help will be highly appreciated
-Jose
Specs: solaris 9, gcc-3.2, mysql-3.23.53
configured as:
CC=gcc CFLAGS=-O3 \
On Tuesday 15 October 2002 04:53 pm, [EMAIL PROTECTED] wrote:
Thanks very much for your replay
Is very interesting but how to change that declaration on mysql or
on the headers if there is any to modify. I have others Linux boxes
running mysql fine but each time I have to deal with the others
On Tuesday 15 October 2002 05:07 pm, Jesse Sheidlower wrote:
I did check out the link below, in which someone else has an
error identical to mine, and Sinisa Milivojevic replied
basically saying that the answer is described in detail in the
Manual.
Well, I can't find it in the Manual. There
Is there a way to find out what index an sql query is using? I know you can
use explain, but those are just possible indexes that the query might use.
I'm trying to find out exacly what execution path it is taking. Something
similar to Oracle's set autotrace on;
MySql version -
Scott Pippin wrote:
I am trying to set up two data files in case the first one fills up. I
tried to use the following in my.cnf but it says there is an error. If
I take out the reference to the second data file everything works
AIX 4.3.3
MySQL 4.0.4
is the biggest bottleneck
we have.
Thanks!
walt
-
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 [EMAIL
I have a few questions regarding recovering an innodb tablespace/datafile.
Here's the situation.
I lose a drive on my master database that contained an innodb datafile. I then
shut the database down and umount that drive.
What would I need to copy from the slave database in order to bring the
Franz Alt wrote:
I use some mail-lists for mysql, php and security with Outlook Express.
When I reply, some lists set their list-adress automatically, some the
adress of the person originally posting. The second version may not so good
IMHO, because I think so many replies are not going to
understand,
it's because the indexes are kept along with the data unlike myisam where the indexes
are
seperate files.
Hope this helps!
walt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
I'd use the InnoDB table type and establish a primary key/foreign key
relationship (parent-child) between the two. That way referential integrity
will be done for you by the database.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Chris Burger [mailto:[EMAIL PROTECTED]]
Sent
the current
mysql directory,
mount the dedicated partion as /var/lib/mysql/ and copy the files from the mysql
directory you
renamed . Of course, be sure to stop mysql and check permissions of the new
location.
walt
-
Before posting
a sub_routine like below and call it instead of dbh-quote.
walt
#
# # nea_quote
# replacement for direct dbh-quote which doesn't work well with
# mysql which returns '' instead of NULL.
sub nea_quote
{
my ($input) = @_;
if (length
generating?
walt
-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
This must be a great scam. I'm starting to see'em all over the place.
--Walt
-Original Message-
From: Ocita Gabriel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 3:53 PM
To: [EMAIL PROTECTED]
Subject: Goodday
Attn: mysql ,
My name is Ocita G, the manager, credit
Try this (not sure the syntax is exactly right since I'm more used to
Oracle's outer join syntax):
select * from main left join activity on main.user = activity.id
where activity.id is null;
This should return only the users in main that are not in activity.
--Walt Weaver
Bozeman, Montana
and MD5'ing at the data source.. Are you saying you dont
want to use PHP to insert and email the passwords?
walt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
?
hope this helps
walt
-
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 [EMAIL PROTECTED]
To unsubscribe, e
1 - 100 of 167 matches
Mail list logo
