you
could retrieve the users table from phpnuke with some script, run it
through strtotime, then insert the altered value into the xoops.
PHP has the strtotime() function, and I'd be surprised if Perl didn't
have it.
Chris
Eric Wagar wrote:
Looking at the structure of xoops.users shows
customers2
|
V
head office
Alternatively, if this is just for backup purposes I would write a
script that dumps the customers table at each shop, compress it and then
ftp it to head office every night.
Cheers,
chris
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED
I have just installed MySQL Administrator on FreeBSD 5.2.1. I am trying to use the Connect to MySQL Server Instance
dialog to establish a connection to a version: 4.0.22 MySQL server. I can establish a remote connection using:
mysql -h hostname -p -u username databasename
However, using MySQL
($s_Ind)) $aWHERE[] = VendorJobs.LocationState IN ($s_Ind)
if(isset($s_State)) $aWHERE[] = VendorJobs.LocationState IN ($s_State)
if(!empty($aWHERE)) $sql .= 'WHERE '.implode(' AND ',$aWHERE);
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
...). one is database related, the other is script related
(script = PHP).
i suggest you ask specific questions regarding MySQL databases to this
list and you ask specific questions to the PHP-General list (you can
sign up by going to www.php.net).
hth,
chris.
--
MySQL General Mailing List
For list
5-9 bytes only go toward the total row size because TEXT and BLOB types
don't get stored in the row itself, just a pointer to them. That pointer
takes up 5-9 bytes. At least, that's how I understand it.
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
on the master.
I'm sure someone else could explain it better.. or possibly correctly :)
Chris
-Original Message-
From: Arvind Gangal [mailto:[EMAIL PROTECTED]
Sent: 10 November 2004 10:28
To: 'Gleb Paharenko'; [EMAIL PROTECTED]
Subject: RE: Sequencial Replication
Hello,
I understand
to be the default)
then
update `Associate` set `Active` = 0 where isNull(Active);
2) modify your queries
select count(*) from Associate where Active!=1 OR isNull(Active);
select count(*) from Associate where Active=1;
Chris
-Original Message-
From: Scott Hamm [mailto:[EMAIL PROTECTED]
Sent: 10
query
you might have more luck if you post your php code to a php group
chris
-Original Message-
From: Yahoo Default User [mailto:[EMAIL PROTECTED]
Sent: 05 November 2004 08:52
To: [EMAIL PROTECTED]
Subject: PHP/MySQL Problem
Hi Guys,
I have a problem with MySQL in conjunction with PHP so
I also use tinyint(1) unsigned
and I provide a mysqlBooleanFormat() function in my application that will
return 1 or 0 for storing the value in the DB
-Original Message-
From: Michael J. Pawlowsky [mailto:[EMAIL PROTECTED]
Sent: 04 November 2004 20:44
To: [EMAIL PROTECTED]
Subject: Re:
}
F{1}
Heh, I'm not sure if anyone will understand that, but I think it's a lot
clearer in my head now.
If you want any more clarification, I'd be glad to, though it seems like
I'm on the right track now.
Chris
[EMAIL PROTECTED] wrote:
Maybe I am just being dense this morning but I am confused
Ok thanks a bunch, I'll take this information and see what I can come up
with.
Chris
[EMAIL PROTECTED] wrote:
Your system sounds more like BNF (Backus-Naur Form) expression evaluator
than a regular expression evaluator. Both are similar in that you can
specify sequences of things (letters
are my options at approaching this? I've thought about writing so
each child is a group, and every child is in a group (even if it's a
group of one). That would solve my problem, but it seems like there
could be a better solution.
Thanks,
Chris
--
MySQL General Mailing List
For list archives
probably has 700 records in it. what the heck kind of
data is being stored where it reaches the millions (or more)?
chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
as a phrase to fulltext:
select * from fullsearch where match (title,body) against ('018-E');
I'd prefer being able to escape the - with \, since using a phrase has
other disadvantages (like partial word matching goes out the window),
but you can't.
--
Chris
--
MySQL General Mailing List
into another table.
chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I know this might be a little silly, but can anyone give me a example on how
to get the date of the first day of a week and month?
--
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
JOIN because of personal preference, it can be done other way(s).
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this under MySQL 4.0.21?
I think MySQL does not support a default value of NOW() like you'd
expect it to. Yeah I know, it sucks. I don't know at what point this was
added, if it's been added at all. (My MySQL version is a bit old also.)
Chris.
--
MySQL General Mailing List
For list archives: http
query you are trying to use and we can go from
there.
however, something simple is the following:
SELECT *
FROM table
WHERE field LIKE '%string%';
hth,
chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
for your needs?)
hth,
chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
second to run, which is fine on its own, but
it has to be run for 35+ locations.
I *think* I've created all possible indexes to speed this up, but if anyone
could help it would be much appreciated.
cheers, chris
QUERY
--
/* The concat is required
three: business, home, and fax. in what case would
having a phone (number) table be beneficial?
I hope this helps.
yes thank you.
chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
|
+-+
Thank you for your time.
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
exactly what
you wanted, but they are close and convey the general gist of what you
need to do.
Chris
Dan Sashko wrote:
thank you, this does return the proper date field for the item_id,
however the rest of the fields of the records are still from the first
record in the table.
How would you make
||
++-+--+-+---
--++
i would appreciate not only table descriptions (like mine above)(if
you're willing) but comments on what i have so far as well.
thank you,
chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
) is to create a statement like the following:
SELECT name
FROM products
WHERE name LIKE '%cleaning%'
AND name LIKE '%computer%'
report back to the list if you find out anything else, or if anyone
would like to chime in and answer this.
chris.
--
MySQL General Mailing List
For list archives: http
Michele mailto:[EMAIL PROTECTED]
on Friday, October 08, 2004 3:23 PM said:
2) I'm looking for id_product that can contemporaneously satisfy more
than an id_value (NOT ONLY ONE!!)
contemporaneously? that's got be one of the best made up wor... wait
what? you mean it's a real word?
Michele mailto:[EMAIL PROTECTED]
on Friday, October 08, 2004 4:57 PM said:
Have I well understood the meaning of your answer ?
It was meant as a joke and not a serious response to your question. I
apologize for the confusion.
Chris.
--
MySQL General Mailing List
For list archives: http
i *could* say is that the hardware i'm using for this box is
not too shabby (not awesome either) and for this exact query it returns
586 records in 2.03 seconds. i have 733 products total in my database.
thank you,
chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
| NULL |NULL | NULL | 753 | where
used |
| pmas | ALL| NULL | NULL |NULL | NULL | 1410 |
|
+---++---+--+-+--+--+---
--+
4 rows in set (0.00 sec)
thanks,
chris.
--
MySQL General Mailing List
to 2.07. (i think i made a mistake in my original time of
2.03... maybe it was 2.23. i know for sure it was 2 seconds and
*something*.)
thanks,
chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
not sure you can do this just with mysql, I think your gunna need to select
the html from the db then send it to something like perl or php and use a
regex parser on it.
-Original Message-
From: Bob Ramsey [mailto:[EMAIL PROTECTED]
Sent: 03 October 2004 12:45
To: [EMAIL PROTECTED]
they enter from the web form hits the
database as entered, or raw, or lower cased.
Is there a way to have the text fixed before it hits
the database?
-chris
=
Chris Ripley
[EMAIL PROTECTED]
KOZE Radio
__
Do you Yahoo!?
Yahoo! Mail is new
slightly off topic, but you can sort of build apache with mysql support.
mod_auth_mysql allows you to authenticate users and groups against a DB
http://sourceforge.net/projects/modauthmysql/
chris
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]
Sent: 15 September 2004
GH wrote:
-- Forwarded message --
From: GH [EMAIL PROTECTED]
Date: Sun, 12 Sep 2004 02:49:02 -0400
Subject: Re: Best way to get Access DB structures into MySQL ??
To: Chris Martin [EMAIL PROTECTED]
Does this also allow for the importation of the data as well?
On Sat, 11 Sep 2004
[EMAIL PROTECTED] wrote:
What is the best way to take the structure of multiple tables in Access
and get them re-created in MySQL without doing that all by hand?
Is there a way to do the equivalent of a Show Create Table in Access, that
I could then use in MySQL ??
Chris Hood
Not sure whether this is applicable to your version of mysql, or to PHP.
I had the same problem using Macromedia's Coldfusion, and adding this:
useUnicode=truecharacterEncoding=UTF-8
to the db connection string solved the problem
chris
-Original Message-
From: MySQL [mailto:[EMAIL
found
two threads from the past year that mentions it briefly. My question is
this: Does any one have any more info on what the plan is?
Thanks,
Chris
**
The information contained in this communication is
confidential, is intended
On Sun, 22 Aug 2004 16:40:24 -0700, Mike Wexler [EMAIL PROTECTED] wrote:
Chris McKeever wrote:
On Sat, 21 Aug 2004 10:18:06 -0700, Info [EMAIL PROTECTED] wrote:
After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the
piggy bank and build a new linux mysql server
On Mon, 23 Aug 2004 00:25:36 -0500, Debbie Woods
[EMAIL PROTECTED] wrote:
I am building a search feature with Cold Fusion and need to have similar
string matches included in the search results. I have a search form field
called hsname. I am trying to use the SOUNDEX function in my query like
On Sat, 21 Aug 2004 10:18:06 -0700, Info [EMAIL PROTECTED] wrote:
After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the piggy
bank and build a new linux mysql server. Here's my problem: I have, at present,
two rather large databases. (A: 4Million records in one
If you base64 encode your binary, it will be valid inside the xml. As far
as I know this is the accepted way to transfer binary objects using xml.
chris
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: 13 August 2004 05:09
To: Keith Ivey; [EMAIL PROTECTED]
Subject
mysql
root 442 Aug 12 09:59
slim.errdrwxr-xr-x 2 mysql
mysql 4096 Aug 11 09:57
test
I had changed nothing in the server, apart
from the unexplained crash everything was normal
now i'm stuck
anyone seen this error before ?
Regards
Chris
BlackwellLead Web DeveloperUK City Directory LtdTelephone
was causing the problem :/
chris
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: 12 August 2004 10:26
To: [EMAIL PROTECTED]
Subject: Re: MySQL won't start... was runnnig fine
Chris Blackwell [EMAIL PROTECTED] wrote:
now when ever i try to start mysql i get
Nope, no idea why it crashed, and I don't know enough about redhat to bother
investigating.
It seemed to hang so it got a kick, when it came backup was bit screwy... so
far this has been only problem. It's only a dev box so I'll keep my fingers
crossed it's a freak occurrence :)
chris
I'm having trouble with character set changes on 4.0.18.
I have a database that contains text in multiple languages and I need to
be able to select the character set on the fly.
For some reason SET CHARACTER SET x always returns Unknown character
set: 'x'. The only exception to this is SET
a session,
but not after quitting and starting a new one.
Are these issues others have run across?
Please tell me I don't have to go back to holding
down the arrow key to edit statements!
Apologies if this has been addressed already...
-chris
--
MySQL General Mailing List
For list archives: http
On Tue, Jul 20, 2004 at 10:39:00AM +1000, Lachlan Mulcahy wrote:
Chris,
Have you checked your following server configurables:
sort_buffer_size:
- This is the size of the cache created by _each_ thread that requires
ORDER BY or GROUP BY in a query.
If you are doing a lot of large
this data
to avoid these horrific queries?
If I can supply any more relevant information I'll be only too pleased to.
Thanks for any hints in advance.
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
should be a 16-digit hexadecimal number
copy and paste the error into google and try following the first link or
click i'm feeling lucky.
chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
on Wednesday, July 07, 2004 11:08 AM said:
Have you tried this other way of making an inner join?
no i did not because i did know you could do a JOIN on an UPDATE. thanks
for your suggestions i will try them out.
chris.
--
MySQL General Mailing
basically the logic i
think i need.)
UPDATE products_categories AS pc, products AS p
SET pc.prod_sequential_id = p.id
WHERE pc.prod_id = p.id;
thanks for your help.
chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
as mysql , apache, and php go . Can You Help Me To
Find Where I Can Get This Information Please .
Yours.
Chris
-
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
Is it possible to use the mysqldump function from within a web application
on a Windows based server using PERL or ASP or do I have to be logged in to
the actual command line MySQL Client with Root Privileges?
Thanks in advance,
Chris
I'm trying to load ACD call data into a table for the first time. I've
saved my data file as a text file on my root directory (win xp c:\)
When I try to run:
LOAD DATA INFILE '/GRPO617'
INTO TABLE helpdeskgrouptotal;
I get the following error in mysql control center:
[Chris
Is there a user guide available anywhere? I can't seem to find anything
on mysql.com
($result);
for ($i = 0; $i $numofrows; $i++)
{
$row = mysql_fetch_array($result);
echo td$row[0]/td;
}
}
I just want to use the result from the first query as input to my update
query. Any ideas what I am doing wrong?
Sincerely,
Chris Dietzler
ATT Enhanced
I am trying to install the RPM and get a couple of errors saying the
libsqlclient.so.10 RPM is missing. I have tried to search for this but
cannot find the proper package for it. Any help would be appreciated!
Sincerely,
Chris Dietzler
ATT Enhanced Network Services
--
MySQL General Mailing
Cusimano
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
---
Chris McKeever
If you want to reply directly to me, please use cgmckeever--at--prupref.com
A href=http
going to be exporting this way
again and you just want to fix it, I would just open the csv file in a
text editor and do a search and replace.
--
Chris W
Bring Back the HP 15C
http://hp15c.org
Not getting the gifts you want? The Wish Zone can help.
http://thewishzone.com
--
MySQL General
You might do something like:
SELECT t1.* FROM t1 LEFT JOIN t2 ON(t1.field1=t2.field1 AND field2={fieldvalue}) WHERE
{all kinds of limits} AND t2.field1 IS NULL LIMIT 0,20;
the LEFT JOIN/WHERE idfield IS NULL will join the table and then lists
rows in table 1 that don't exist in table 2
Mark van
selects per second (with super-smack, an arbitrary benchmarking
tool); with 2.4 it was a few thousand lower.
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
?
Thanks,
Lou
---
Chris McKeever
If you want to reply directly to me, please use cgmckeever--at--prupref---dot---com
A href=http://www.prupref.com;www.prupref.com/A
Prudential Preferred Properties
A href=http://www.prupref.com;Chicago and Illinois
=EmailDatabase_k.Account='kvanoni' and
EmailDatabase_k.id=EmailMessage_k.id kvanoni.db
if I make it just a single clause, it then says that table doesnt exist etc...
as I said, I take out the where and it works...thanks
---
Chris McKeever
If you want to reply
On Thu, 3 Jun 2004 11:54 , McKeever Chris [EMAIL PROTECTED] sent:
MYSQL 4.0.13
I must be doing something wrong - I am trying to do a mysql dump and it keeps yelling
that tables dont exist whenever I put a where clause
in..
it runs fine when I leave the where clause off - any help here
On Thu, 03 Jun 2004 12:07 , gerald_clark [EMAIL PROTECTED] sent:
McKeever Chris wrote:
MYSQL 4.0.13
I must be doing something wrong - I am trying to do a mysql dump and it keeps
yelling that tables dont exist whenever I put a where clause
in..
it runs fine when I leave the where clause
On Thu, 03 Jun 2004 13:57 , Michael Stassen [EMAIL PROTECTED] sent:
McKeever Chris wrote:
MYSQL 4.0.13
I must be doing something wrong - I am trying to do a mysql dump and it
keeps yelling that tables dont exist whenever I put a where clause in..
it runs fine when I leave the where
,
Chris Dietzler
ATT Enhanced Network Services
858 812 4062
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the average count per day? We can ignore the fact
that it is possible that no records are added on a given day. I almost
for got this is on 4.0.18 so nested selects are not an option.
--
Chris W
Bring Back the HP 15C
http://hp15c.org
Not getting the gifts you want? The Wish Zone can help.
http
|
+--++
Can anyone help me figure out how to assign a new variable to the cst_SiteID
for each row?
Sincerely,
Chris Dietzler
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
7820-- Assests Associated with
SiteID 7820
+
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 02, 2004 11:59 AM
To: Chris Dietzler
Cc: Mysql (E-mail)
Subject: Re: Pulling a value from a filed in a result to use as another
variable
of stderr mailed to you? That would probably
identify the cause, but at an off the top of my head guess, mysqldump
isn't in the default path for the user you're running this as? Specify
the full path to it in the crontab?
--
Chris
--
MySQL General Mailing List
For list archives: http
I have SuSE 9.1 and can't find any GUI auto config type option to
start mysqld at boot up so I was wondering what was the best way to
configure MySQL to start at boot time
Chris W
Bring Back the HP 15C
http://hp15c.org:8080
Not getting the gifts you want? The Wish Zone can help.
http
and makes a new .MRG, and after the flush MySQL is inserting into the
next table without even realising.
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
change these). It only works in the Unix MySQL client.
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
Best Regards
Alejandro
On the same server just do this:
SELECT dbname.tablename.columnname,db2name.table2name.column2name FROM
dbname.tablename, db2name.table2name; (I think you get the idea)
As far as I know you can't select data across multiple servers.
Chris
--
MySQL General Mailing List
, how many rows are being returned for the query?
1 - the username is a unique key.
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
Chris Curnow
Director, 4Cast Pty Ltd
+613 9587 8727 mobile: 0413 514 893
mailto:[EMAIL PROTECTED]
http://www.4cast.com.au
http://www.chriscurnow.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
to the master database
several minutes later.
For database stuff, I can strongly recommend giving AMD's gear a solid
look-in. Their architectural differences really do make for excellent
database performance (Athlon XP or their 64 bit product line).
Best regards,
Chris
Mike
--
MySQL General Mailing List
What query are you using to search?
With the FullText indexes you have only two match options are possible:
MATCH(specs) AGAINST . . .
and
MATCH(manufacturer) AGAINST . . .
If you're trying to search both at the same time you need a FULLTEXT
index of (specs,manufacturer)
Chris
Robb Kerr wrote
any better?
Thanks for any comments,
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
record firm numbers, I'd have get FreeBSD back on
to get some firm results for that.
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
First of all check the *.err log in your data dir. It will likely give you
some clue as to what is happening.
-Original Message-
From: Laercio Xisto Braga Cavalcanti
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 19, 2004 3:08 PM
To: [EMAIL PROTECTED]
Subject: Installing Mysql binary
off him if you need them.
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
?
No, it required various code changes. A colleague of mine made the
changes, I can probably get them off him if you need them.
PLEASE do Chris...
I actually got it to compile after wrestling with it for awhile.
But I can't get it to work with a remote server that doesn't have
supersmack
I'm trying to run a stored query with the results sent to an excel file. Each time I
try I get an Outfile Disabled message. Any suggestions? I'm running Winxp.
msql source interests.sql c:\test.xls
= Outfile Disabled.
Thank you.
]
---
Chris McKeever
If you want to reply directly to me, please use cgmckeever--at--prupref---dot---com
http://www.prupref.com
Prudential Preferred Properties
Chicago and Illinois NorthShore Real Estate Experts
Prudential Preferred Properties www.prupref.com
Success Driven By Results
Results
32bit box with 4GB of memory. And sine MySQL doesn't do PAE,
it'll never see that extra memory.
Didn't InnoDB gain PAE support on some platforms a little while ago?
Best regards,
Chris
Jeremy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
that
MyISAM's strengths are simplicty and a lack of transaction related
overhead? Couple this with InnoDB's excellent performance and it looks
very unlikely to happen IMHO.
Best regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
kick in? It probably will,
won't it.. Maybe a FORCE INDEX?
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
?
Chris W
Bring Back the HP 15C
http://hp15c.org:8080
If you don't get the gifts you really want, maybe The Wish Zone can help.
http://thewishzone.com:8086
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I thouught I read somewhere a while back that MySQL was working on an
option to create a MySQL partition so as to avoide all OS filesystem
overhead to speed things up and I think to save a small bit of over
head. Is this true?
Chris W.
--
Bring Back the HP 15C
http://hp15c.org:8080
If you
critical
area, then you most likely won't care about this. Though, you may want
to just do a simple query through a table, on your worst case
environment; which from what you say may be up to about 70M records,and
get an idea how much time it would take.
Chris
--
MySQL General Mailing List
Your first problem is the order not having backticks you have to do
ORDER BY `order`, title or you'll get a sql error.
But the other thing you'll run into is that null evaluates to les than any
int, meaning the null rows will come before your numbered rows, however you
can't just switch to
Are you dropping then recreating the tables and data, or just doing a
diff between what's on the backup and what's in the zip file and
updating the difference?
I've been doing a drop on the tables and recreating them and it seems to
work ok.
-Original Message-
From:
[EMAIL PROTECTED]
it
won't run, why?
Chris W
http://thewishzone.com:8086
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
), the query returns BOTH rows.
Is there a way to get around returning the latter entry?
I'm not 100% sure but I remember reading about a binary compare option
in the documentation that I bet would do the trick. Take a look at that.
Chris W
http://thewishzone.com:8086/
--
MySQL General Mailing
?
Please send help!? Or at least play some Motley Crue..
Have a great day!
Chris Stevenson
Call Center Manager
The American Board of Family Practice
859-269-5626 ext. 299
/mysqldump.html
Chris W
http://thewishzone.com:8086
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
801 - 900 of 2034 matches
Mail list logo