Martijn Tonies wrote:
This sounds great. Could you please post some of your timber products
here to the list? Many of us are really looking for a break from this
boring MySQL stuff. Thanks, and our kind regards to you too.
Unless they offer a new table-type that allows us to store real
Paul McCullagh wrote:
?!:( A license to SPAM:
On Sep 12, 2006, at 4:57 AM, Agrapin S.A. - Timber Industry and Trading
wrote:
This message is in full compliance with U.S. Federal requirements for
commercial email under bill S.1618 Title lll, Section 301, Paragraph
(a)(2)(C) passed by the
Jerry Schwartz wrote:
An employee of a financial institution realized a similar vulnerability in
their systems. It was common to calculate batch totals, which were cross
checked to make sure that no transactions went astray, but he realized that
so long as the batch totals came out right you
Bruno Rodrigues Silva wrote:
Dear all.
The MySQL Manual inform that Decimal Data Type is used
for represent exact-number, but like Float Point Data
Type, Decimal use rounding case the fractional part is
not sufficient. Therefore, what the difference?
Hi Bruno,
FLOAT rounds as floating point
Jerry Schwartz wrote:
The difference is that, for example, .01 can be represented exactly
in decimal; but float types are binary, so .01 cannot be represented
exactly. This can lead to all kinds of trouble when doing arithmetic,
the errors accumulate.
Yes! but that can also lead to some other
How do you expect to split a dollar 3 ways?
Sorry, I should have added more smiles, it was supposed to be a joke about
the dollars... ;)
But still, I could win a lot of money by distributing people's money to
their three kids and getting 1 cent out of every operation. :D
It is not the math
Peter Lauri wrote:
Yes, and this shows that you can not do it will MySQL purely :) But a
scripting language like php can do it for you with a recursive function as
the best option.
IMHO, the best option would do it with a procedure as you don't get out
of the database and don't have any
Renald Buter wrote:
Odd, eh? But what's worse, the JOIN between this column and other
columns *also* uses this truncated values and the result is bogus.
I wouldn't say odd, as you didn't specified any order I wouldn't rely on
the order of the output. Try ordering things for what you want and
Jeremiah Foster wrote:
Hello all,
We are using an NOW() function in our database and occasionally it
produces odd results. There are entries where it states: -00-00
00:00:00 instead of the current time. Is this a bug, or are we using the
function incorrectly?
MySQL version info:
mysql Ver
Chris Knipe wrote:
After patiently injecting at about 400 queries per seconds, a couple of
hours later, I had about 5 million records in a table. Not a single one
of them experienced the above
It's one every 5 million and 1 entries... try again ;)
Also, maybe (very improbable) it can be
Nicholas Vettese wrote:
I have been having problems with my email, and I wanted to test to this
list.
Will let you know when I receive it...
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Chris Knipe wrote:
Doh.. Wrong email ;)
INSERT INTO a VALUES (NOW()) ?
Sorry, it was not for you, I wanted Jeremiah's query... replied the
wrong mail... my fault! ;)
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Chris wrote:
The most common next search becomes the did you mean.
Yes, that might work well, but I wouldn't use it out of the box. I would
send a report to a human first to use that information instead of doing
it automatically.
Imagine someone searching for cous (instead of cows) and
Rhino wrote:
What do you mean by mols - molar weights?
yup... i mean, probably... ;)
And why would anyone search for anything to do with chemicals based on
smilies? How would :-) or symbols like that help? Or is this some
other sense of the word smilies than the customary Internet one?
OK, I appear to be getting somewhere with the FULL TEXT search. Does
anyone have any good resources about producing search engine type results
? for example if some enters a search phrase like londn how would I
suggest the word london ?
Hi Neil,
That's a completely different thing, but
Neil Tompkins wrote:
I have a number of different database fields.
Does anyone have any recommendations about how I can
perform a search engine type search including the text fields.
Full-Text Search:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
cheers,
--renato
--
MySQL
[EMAIL PROTECTED] wrote:
How do I check two tables is it? Username and userpass are submitted through a
from and are unique
$sql = SELECT username, userpass FROM mytable, mytable2 WHERE username = '$username' AND
userpass = '$userpass';
This way you'll have an ambiguous error as username
balaraju mandala wrote:
In my application there is a situation is arising, where i need to take
some
data to MySql from a table which is in Oracle database (i am planning to
maintain that data in MySQL also). And from MySQL my application will use
it. This whole thing should be happen
thanks for your response.
I'm already working on the php part but just wondered how bad is to
have backslash in front of quotes.
It's bad in the sense that you will have to predict every single event
(character) from the input and act accordingly. The API writers had
predicted them all and
Abdullah Ibn Hamad Al-Marri wrote:
Invalid SQL:
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location,
styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation,
useragent, bypass, profileupdate)
[EMAIL PROTECTED] wrote:
hi to all.
battling this problem on several forums and mailing lists, I got confused:
when store string that contains quotations (ie afan's php shop) in mysql
does it have to be stored with backslashes (afan\'s \php\ shop) or just
the way it is? my login's telling me
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN.
Yeah, known problem...
We have an offsite backup that needs to be in
the replication (2-way to make switching back and forth easy) chain.
Why do you need a backup site to write
Ed Pauley II wrote:
This is another geographical location with automatic failover if there
is a problem, network, hardware etc. with the primary location. When the
problem is corrected, or corrects itself the traffic is automatically
sent back to the primary location. Without 2-way replication
On Monday 11 April 2005 16:00, mysql helppp wrote:
Error - Duplicate key '444642', -1
(The syntax of the error message is not exact)
probably index error, run myisamchk on the table, or repair table inside
MySQL command line. Should fix without loose any data.
--rengolin
--
MySQL General
On Friday 08 April 2005 06:14, Richard Miller wrote:
I didn't know the CSV table-type existed -- sounds really cool!
As I understand it, it will save table data in a flat CSV file, but if
I already have a CSV file, can I trick MySQL into thinking it's a
table? That wasn't clear from the
On Wednesday 06 April 2005 20:05, jon wrote:
Normal recovery seems to grab 490 rows... but, originally there were
some 22 million rows in there.
Seems your data file was corruped too not only the indexes. and probably broke
when updating the 491st registry... try use myisamchk -e
-e,
You could use the CSV table type:
http://dev.mysql.com/doc/mysql/en/csv-storage-engine.html
Or use the LOAD DATA INFILE to import all data:
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
--rengolin
--- Richard Miller [EMAIL PROTECTED] wrote:
I have a dozen, very large CSV files that I would
Hi Jalil,
I had the same problem more than once. I solved it
with a (not-so) simple perl script but the idea is
very simple: swap the machines!
scenario #1: master and slave running
- master is used for writes, slave for reads,
replication goes well. you have a DNS entry for
MASTERDB.domain
On Wednesday 30 March 2005 10:49, Brent Baisley wrote:
Wow, you are asking a lot, especially since an inexpensive UPS could be
had for less than $50. You don't need one to keep the system up for a
long time, just long enough for writes to finish. A few minutes should
be plenty.
Yeah, remember
On Tuesday 29 March 2005 11:26, Shamim Shaik wrote:
Can I run load data from master on myisam tables where my table size is
approx 30G?
- stop slave
- on master do:
- lock tables
- tar cpf - /var/lib/mysql/tbl | ssh -C slave tar xpf - -C /var/lib/mysql/tbl
- start slave
- on master again:
-
On Tuesday 29 March 2005 11:44, Shamim Shaik wrote:
I cannot stop or lock tables on the master webapps write data to it
constantly.
I am copying over the binlogs and applying them to the slave.
It is taking a long time so I just want to know if load data or copying
tables over would bring
On Tuesday 29 March 2005 20:51, Scott Klarenbach wrote:
Is there a way to represent infinity in mysql?
I could make infinity default to 100,000,000 or some other number I
know will never be reached, but it seems less elegant a solution...
probably not the best but you could have two fields:
Hi,
is there any built in high availability issue on mysql today? Or even plans to
do it?
I mean, I made my own HA perl script running on both master and slave
replication servers to set up a HA but it could be a plugin of mysql,
couldn't?
In fact i want to rewrite it in C or Java but i
33 matches
Mail list logo