On Tue, 16 Dec 2014, Hartmut Holzgraefe wrote:
On 16.12.2014 15:16, xiangdongzou wrote:
Can anyone tell me why 531808.11 has been changed to 531808.12 ?
typical decimal-binary-decimal conversion/rounding error.
never used DECIMAL nor intend to, but the issue is typical of precision
We always store as strings to avoid rounding issues and then convert for calcs
to whatever precision we need.
Pat...
Sent from my iPhone
On Dec 17, 2014, at 6:24 AM, Lucio Chiappetti lu...@lambrate.inaf.it wrote:
On Tue, 16 Dec 2014, Hartmut Holzgraefe wrote:
On 16.12.2014 15:16,
On 17 December 2014 14:21:40 CET, Patrick Sherrill patr...@michael-clarke.com
wrote:
We always store as strings to avoid rounding issues and then convert
for calcs to whatever precision we need.
Pat...
So you'll still be affected by rounding errors during conversion and
calculation,
two
On 12/12/2014 2:38 PM, Alexander Syvak wrote:
Hello!
How is actually a function done internally in MySQL after CREATE FUNCTION
statement?
Why can't there be a dynamic SQL inside a function?
Sorry for the delay.
The answer is embedded in this description of what is or is not allowed
Hi Frank,
On 12/17/2014 2:11 AM, xiangdongzou wrote:
HI all:
As we know,when we shutdown the database cleanly,the database can
do a checkpoint.So we don't need redo log againg.In mysql(innodb),we can
restart normaly.But oracle database also need redo log group(current), why?
While
in favour of
email include:
* Email is a push medium. I don't have to continually re-check a
website to see if there's any new messages, they simply arrive in my
list mailbox and I view them at my convenience.
* Individual emails can be forwarded and/or saved independently of
the others
On 16.12.2014 15:16, xiangdongzou wrote:
Can anyone tell me why 531808.11 has been changed to 531808.12 ?
typical decimal-binary-decimal conversion/rounding error.
If you want exact decimals you need to stick with the
DECIMAL type which doesn't have this problem, at the
cost of slower
On Fri, Dec 12, 2014 at 8:31 PM, Sayth Renshaw flebber.c...@gmail.com wrote:
And does that then lead you to use Fabric?
http://de.slideshare.net/mobile/nixnutz/mysql-57-fabric-high-availability-and-sharding
No, I've never used that. I just process the the data in python.
On Sat, 13 Dec 2014
True; and before that there was yahoo groups, and others. Those are not
fora, however, merely web interfaces to mailing lists / newsgroups.
as a lurker on this list, I jump in. It is curious that newsgroups are
mentioned only en passant, and NNTP is not mentioned at all.
Still vastly prefer
- Original Message -
From: yoku ts. yoku0...@gmail.com
Subject: Re: command is not allowed with this MySQL version
Christophe has already told,
The used MySQL version is 5.5.40 from Debian Wheezy package.
No, that's the new version. It'd be fun to know what the OLD version
- Original Message -
From: Sayth Renshaw flebber.c...@gmail.com
Subject: Xml data import
I have an xml data feed with xsd, it's complex in elements not size. Wray
are the best way to get data into mysql, do I have to hack with xquery?
That's going to depend on the complexity of
and
that is true
as a list of long running querys showed.
Is there a way to make it behave like the interactive version ?
Now it is a bit confusing for everyone.
re,
wh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Hi,
Le 12/12/2014 11:51, Johan De Meersman a écrit :
- Original Message -
From: yoku ts. yoku0...@gmail.com
Subject: Re: command is not allowed with this MySQL version
Christophe has already told,
The used MySQL version is 5.5.40 from Debian Wheezy package.
No, that's the new
of long running querys showed.
Is there a way to make it behave like the interactive version ?
Now it is a bit confusing for everyone.
re,
wh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Date: Thu, 11 Dec 2014 14:07:33 -0800
Subject: Re: How to retrieve next record?
From: mussa...@csz.com
To: larry.mart...@gmail.com
CC: mysql@lists.mysql.com
On Thu, December 11, 2014 13:43, Larry Martell wrote
, thanks.
BR, Hans.
Johan De Meersman schreef op 11-12-14 om 23:44:
- Original Message -
From: Wm Mussatto mussa...@csz.com
Subject: Re: How to retrieve next record?
Related what is the form of the prmary key. If its numeric something like
$sDBQuery1 = SELECT * FROM kentekenlogtest WHERE
2014/12/12 02:10 +0100, Christophe
When the app tries to do this, it raises an error :
'The used command is not allowed with this MySQL version'
The used MySQL version is 5.5.40 from Debian Wheezy package.
I found that some parameters or variables (local_infile for instance) can be
used to
So it is definitely achievable, I see other db's converting xml2json etc to
get it in.
Sends odd that xml had done great document qualities but as a data format
it seems rather hard to work with.
Sayth
On Fri, 12 Dec 2014 9:55 PM Johan De Meersman vegiv...@tuxera.be wrote:
- Original
On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw flebber.c...@gmail.com wrote:
So it is definitely achievable, I see other db's converting xml2json etc to
get it in.
I use this https://github.com/hay/xml2json
Sends odd that xml had done great document qualities but as a data format
it seems
And does that then lead you to use Fabric?
http://de.slideshare.net/mobile/nixnutz/mysql-57-fabric-high-availability-and-sharding
Sayth
On Sat, 13 Dec 2014 9:06 AM Larry Martell larry.mart...@gmail.com wrote:
On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw flebber.c...@gmail.com
wrote:
So
of a mailing
list: people can choose how to view the list according to their own
preference (some like it threaded, others prefer a flat view based
simply on message date). Other arguments in favour of email include:
* Email is a push medium. I don't have to continually re-check a website
to see
- Original Message -
From: Sándor Halász h...@tbbs.net
Subject: Re: forum vs email
Something more sophisticated than grouping messages by trimmed subject-lines?
maybe involving such header lines as were used in the old netnews (if e-mail
is
That's only a single level. Fora are more
DEAR guys:
I think Email is good for search and I can download to my moible
device.
2014-12-11
I AM AN ORACLE FANS!
Skype:Frank.oracle
Email:xiangdong...@gmail.com
Name:东东堂
发件人:Mark Goodge m...@good-stuff.co.uk
发送时间:2014-12-11 17:23
主题:Re: forum vs email
收件人:mysqlmysql
On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 triano...@gmail.com wrote:
Hi all,
It seems like a simple question, however I'm not able to find the
answer.
Let me explain. I have a DB with lots of columns, one is labeled as
'kenteken' and it is also the primary key in the DB. I poke into
On Thu, December 11, 2014 13:43, Larry Martell wrote:
On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 triano...@gmail.com wrote:
Hi all,
It seems like a simple question, however I'm not able to find the
answer.
Let me explain. I have a DB with lots of columns, one is labeled as
'kenteken'
Please reply to the list and not to me directly
On Thu, Dec 11, 2014 at 5:10 PM, Trianon 33 triano...@gmail.com wrote:
Larry Martell schreef op 11-12-14 om 23:04:
On Thu, Dec 11, 2014 at 4:58 PM, Trianon 33 triano...@gmail.com wrote:
Larry Martell schreef op 11-12-14 om 22:43:
On Thu, Dec
Trianon 33 schreef op 11-12-14 om 23:20:
Wm Mussatto schreef op 11-12-14 om 23:07:
On Thu, December 11, 2014 13:43, Larry Martell wrote:
On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 triano...@gmail.com
wrote:
Hi all,
It seems like a simple question, however I'm not able to find the
Date: Thu, 11 Dec 2014 14:07:33 -0800
Subject: Re: How to retrieve next record?
From: mussa...@csz.com
To: larry.mart...@gmail.com
CC: mysql@lists.mysql.com
On Thu, December 11, 2014 13
- Original Message -
From: Wm Mussatto mussa...@csz.com
Subject: Re: How to retrieve next record?
Related what is the form of the prmary key. If its numeric something like
$sDBQuery1 = SELECT * FROM kentekenlogtest WHERE kenteken
'$sActueelkenteken' limit 1
might work
- Original Message -
From: Christophe t...@stuxnet.org
Subject: command is not allowed with this MySQL version
'The used command is not allowed with this MySQL version'
Out of sheer morbid curiosity, what version were they running?
--
Unhappiness is discouraged and will be
Hi,
Christophe has already told,
The used MySQL version is 5.5.40 from Debian Wheezy package.
Maybe you missed *mysql command-line client's --local-infile option*
$ bin/mysql
mysql SELECT @@version;
++
| @@version |
++
| 5.5.40-log |
++
1 row in set
- Original Message -
From: Sándor Halász h...@tbbs.net
Subject: Re: forum vs email
I believ that one could both by e-mail and through a webbrowser comment on a
Google group.
True; and before that there was yahoo groups, and others. Those are not fora,
however, merely web interfaces
- Original Message -
From: Jigal van Hemert ji...@xs4all.nl
Subject: Re: forum vs email [was: Re: table-for-column]
On typo3.org there used to be mailing lists only in a distant past.
Later on newsgroups were set up which communicate with the mailing lists
(newsgroups
- Original Message -
From: Johan De Meersman vegiv...@tuxera.be
Sent: Wednesday, 10 December, 2014 09:02:45
Subject: Re: forum vs email [was: Re: table-for-column]
Hmm. That sounds interesting, I'll have a look. I don't suppose the software
is
available under a foss license? :-p
Hi,
On 10/12/2014 09:02, Johan De Meersman wrote:
- Original Message -
From: Jigal van Hemert ji...@xs4all.nl
Subject: Re: forum vs email [was: Re: table-for-column]
On typo3.org there used to be mailing lists only in a distant past.
Later on newsgroups were set up which communicate
Hi,
On 10/12/2014 10:09, Johan De Meersman wrote:
Hm. Typo3 is a CMS; I take it the integration you're speaking of is
specific to their support environment, and not part of the CMS?
Correct, TYPO3 is a CMS (also FOSS GPL2+) and the integration is indeed
not part of the CMS. See my other
as a list of long running querys showed.
Is there a way to make it behave like the interactive version ?
Now it is a bit confusing for everyone.
re,
wh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
- Original Message -
From: Sebastien FLAESCH s...@4js.com
Subject: Re: signal handling in mysql cli
Nobody concerned by this case?
Simple question: is it safe or not to do a KILL QUERY in a SIGINT signal
handler?
I don't see what the extra risk would be as opposed to doing so in any
2014/12/10 09:00 +0100, Johan De Meersman
One of the (for me, at least) defining features of a forum, is that the
subjects tend to be divided up into a tree structure, which has it's own
benefits
Something more sophisticated than grouping messages by trimmed subject-lines?
maybe
Am 10.12.2014 um 18:38 schrieb h...@tbbs.net:
2014/12/10 09:00 +0100, Johan De Meersman
One of the (for me, at least) defining features of a forum, is that the
subjects tend to be divided up into a tree structure, which has it's own
benefits
Something more sophisticated than
You can do that, but, perhaps the only chance to have it updating a row
based on a condition is developing a Stored Procedure or even having a
BEFORE Trigger associated with the main table. Those ways, you can test the
sent value and decide on what UPDATE you will execute afterwards. Consider
that
You can use your login inline with nested IF expressions:
insert into foo(id,comment)
values(17, IF(WORD like 'a%','a',IF(word like 'b%','b',null)));
On Tue, Dec 9, 2014 at 9:50 AM, wagnerbianchi.com m...@wagnerbianchi.com
wrote:
You can do that, but, perhaps the only chance to have
- Original Message -
From: Richard Reina gatorre...@gmail.com
Subject: Specking a small MySQL server
somewhat of an energy hog and is due to be replaced. I was considering
replacing it with a lap-top so as to conserve energy and because a laptop
has a built in battery backup.
- Original Message -
From: Sándor Halász h...@tbbs.net
Subject: Re: forum vs email
That is, this list, right? What does it lack (besides readers)?
This list interacts with the forums on mysql.com? Every thread here matches one
on there, and vice versa? (Honest question; I hardly ever
Hello Martin,
On 12/9/2014 9:25 AM, Martin Mueller wrote:
I'm trying to get my feet wet with 'if' and 'when' uses in mysql. it would
be very useful for update operations, but I can't get it right.
If I read the documentation correctly, it should be possible to say
something like
UPDATE X
if
On 2014-12-09 9:55 AM, Johan De Meersman wrote:
- Original Message -
From: Sándor Halász h...@tbbs.net
Subject: Re: forum vs email
That is, this list, right? What does it lack (besides readers)?
This list interacts with the forums on mysql.com?
Nope.
PB
-
Every thread here
2014/12/09 15:20 -0600, Peter Brawley
Nope.
And why not? Because no one bothered to implement it? Now I (for the first
time?) looked at forums.mysql.com and see more topics than on
lists.mysql.com. The former is just more with-it, I guess.
I believ that one could both by e-mail and through a
2014/12/09 14:25 +, Martin Mueller
I'm trying to get my feet wet with 'if' and 'when' uses in mysql. it would be
very useful for update operations, but I can't get it right.
If I read the documentation correctly, it should be possible to say
something like
UPDATE X
if WORD like 'a%' SET
On 12/9/2014 9:10 PM, h...@tbbs.net wrote:
2014/12/09 15:20 -0600, Peter Brawley
Nope.
And why not? Because no one bothered to implement it? Now I (for the first time?) looked at
forums.mysql.com and see more topics than on lists.mysql.com. The former is
just more with-it, I guess.
I
Hello Chris,
Can pls you share the below command output...
SHOW STATUS LIKE 'Threads%';
SELECT @@thread_cache_size, @@net_buffer_length, @@max_allowed_packet;
What about the limits.conf config on operating system level?
-- WB, MySQL Oracle ACE
Em 07/12/2014, às 20:03, Chris Knipe
In some past experiences, firewall can add a small overhead in connection
establishment. If you're using iptables, you can try disable it for a second,
test the connection establishment to check if the overhead is being added by
the firewall and enable that afterwards.
Let us know how's it
Am 08.12.2014 um 14:04 schrieb Wagner Bianchi:
In some past experiences, firewall can add a small overhead in connection
establishment. If you're using iptables, you can try disable it for a second,
test the connection establishment to check if the overhead is being added by
the firewall and
On Mon, Dec 8, 2014 at 3:02 PM, Wagner Bianchi
wagnerbianch...@gmail.com wrote:
Hello Chris,
Can pls you share the below command output...
SHOW STATUS LIKE 'Threads%';
SELECT @@thread_cache_size, @@net_buffer_length, @@max_allowed_packet;
mysql SHOW STATUS LIKE 'Threads%';
Am 08.12.2014 um 14:56 schrieb Chris Knipe:
They have been dealt with. mySQL has 4096 file descriptors available.
Through all of this, not one single error is logged to the errorlog
either.
limits.conf:
mysql soft nofile 4096
mysql hard nofile 4096
that won't work well depending on the
Chris, thanks for you prompt reply. Try to raise up some configuration
regarding /etc/security/limits.conf
mysql soft nofile 10240
mysql hard nofile 40960
mysql soft nproc 10240
mysql hard nproc 40960
root soft nofile 10240
root hard nofile 40960
root soft nproc 10240
root hard nproc 40960
Very good share Reindl.
--
*Wagner Bianchi, MySQL Database Specialist*
Mobile: +55.31.8654.9510
E-mail: m...@wagnerbianchi.com
Twitter: @wagnerbianchijr
2014-12-08 12:05 GMT-02:00 Reindl Harald h.rei...@thelounge.net:
Am 08.12.2014 um 14:56 schrieb Chris Knipe:
They have been dealt
FYI - just an example...
mysql SELECT VERSION();
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:203720459
Current database: NNTP
+-+
| VERSION() |
+-+
|
- Original Message -
From: Jan Steinman j...@ecoreality.org
Subject: Re: forum vs email [was: Re: table-for-column]
There actually seem to be a lot of these around. I'm on several that send me
email when there are new forum postings.
Yes, that bit is pretty standard functionality
2014/12/06 12:51 +0100, Johan De Meersman
I want:
* The entire post, and as little notification-type content as possible,
* headers and subjects so that mail clients that support threading will thread
everything from a single forum topic in a mail thread and vice versa,
* and, most
Am 06.12.2014 um 16:53 schrieb h...@tbbs.net:
2014/12/06 12:51 +0100, Johan De Meersman
I want:
* The entire post, and as little notification-type content as possible,
* headers and subjects so that mail clients that support threading will
thread everything from a single forum topic in a
Hi,
On 05/12/2014 20:54, Jan Steinman wrote:
From: Johan De Meersman vegiv...@tuxera.be
I've long wanted to - but never quite got around to - write a forum that
integrated a mailing list. Bar mail clients that don't handle list threads
well, it really doesn't seem such a difficult task.
I have been a resident of this list for a very long time. In the early
days, this was the only place to get reliable information about what was
then a relatively obscure database system. Now, local and online bookstores
have shelves full of books, many of them authored by list regulars. We have
Just to pitch in, on this rather weird discussion.
I've been on the MySQL pretty much from day one. I started
on mSQL and transferred to MySQL when Monty took that corner.
I'm probably not the only one, lurking in the shadows.
On Sat, December 6, 2014 17:33, Reindl Harald wrote:
Am 06.12.2014
- Original Message -
From: Shawn Green shawn.l.gr...@oracle.com
Subject: Re: table-for-column
My problem is a lack of time. I can monitor the mailing lists or the
forums but rarely both while still doing my regular job of handling the
official service requests.
I've long wanted
On 2014-12-04 9:56 PM, shawn l.green wrote:
On 12/1/2014 6:09 AM, Johan De Meersman wrote:
- Original Message -
From: peter brawley peter.braw...@earthlink.net
Subject: Re: table-for-column
I wonder if anyone knows why sites like Stack Overflow and those of
ours
I mentioned
From: Johan De Meersman vegiv...@tuxera.be
I've long wanted to - but never quite got around to - write a forum that
integrated a mailing list. Bar mail clients that don't handle list threads
well, it really doesn't seem such a difficult task.
There actually seem to be a lot of these
2014/12/04 22:56 -0500, shawn l.green
I guess this email-based peer-to-peer exchange is slowly disappearing into the
background like the old usenet newsgroups, eh?
And _I_ like using an off-line e-mail client, and not being bothered by going
through a webbrowser--but I suspect that others
On 12/1/2014 6:09 AM, Johan De Meersman wrote:
- Original Message -
From: peter brawley peter.braw...@earthlink.net
Subject: Re: table-for-column
I wonder if anyone knows why sites like Stack Overflow and those of ours
I mentioned are seeing more volume, while this list and all
this with stty -a what key is map to what signal.
NTL the question is: how can the user stop the query what was started with a
script ?
re,
wh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
select now(); select sleep (100) ; select now()
i looks like that but show full processlist; shows otherwise and that is true
as a list of long running querys showed.
Is there a way to make it behave like the interactive version ?
Now it is a bit confusing for everyone.
re,
wh
--
MySQL
- Original Message -
From: wharms wha...@bfs.de
Subject: signal handling in mysql cli
when i use CTRL-C to break a query that works fine in interactive mode.
but when i use the noninteractive mode
i looks like that but show full processlist; shows otherwise and that is
true
- Original Message -
From: peter brawley peter.braw...@earthlink.net
Subject: Re: table-for-column
I wonder if anyone knows why sites like Stack Overflow and those of ours
I mentioned are seeing more volume, while this list and all MySQL fora
are seeing much, much less.
The major
Hello Mimko,
Sorry for the late reply. I had a bunch of work to take care of before
vacation, then there was the vacation itself. :)
On 11/13/2014 2:34 PM, Mimiko wrote:
Hello. I have this table:
show create table cc_agents_tier_status_log:
CREATE TABLE cc_agents_tier_status_log (
id
thing in and of itself. Why is it that webdevs are so
condescending about tables?
Excellent question (though not for this list).
Re how our MySQL tips aggregator page was written: I think the only
relevant MySQL point may be that it's driven by an edge list model of a
hierarchy implemented
...@mrbrklyn.com wrote:
On 11/24/2014 10:00 AM, Johan De Meersman wrote:
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
Well, this mailing list is dead. This is a mailing list that used to
handle 70+ questions a day, or more.
Is that why you feel the need
2014/11/26 14:25 -0600, Peter Brawley
www.artfulsoftware.com/infotree/mysqltips.php,
And this page is an HTML hack, table for column ... generated by a (PHP?)
program?
*sigh*
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Not a unicode one that I know of, converting it to latin1 for the grouping
works for that particular use case, but I can't make any promises how it'd
work on your entire set which may hold any unicode character, a lot of
which cannot be converted to latin1:
mysql SET NAMES utf8;
Query OK, 0 rows
Thanks for that answer. It squares with my solution: have an additional
column that has the lower case values of the case sensitive unicode
setting.
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
On 11/25/14 6:48 AM, Rik r...@grib.nl wrote:
Not a unicode
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
Well, this mailing list is dead. This is a mailing list that used to
handle 70+ questions a day, or more.
Is that why you feel the need to troll on posts from two years ago?
If you think it's
On Sun, Nov 23, 2014 at 08:31:24PM +0100, Heck, Walter wrote:
I watched a keynote from Thomas Ulin at Percona Live London a few weeks
back, and the slides are quite interesting:
https://www.percona.com/live/london-2014/sites/default/files/slides/PerconaLondon14_keynote.pdf
Well, this
From: Walter Heck walterh...@olindata.com
Subject: Re: Which replication solution should I choose?
Hi Johan,
it'll be a good ol' war story of the transition of a large 130k QPS MMM
cluster
to PXC, so come visit for sure. Here's the link to the session:
http://www.percona.com/live/london
- Original Message -
From: Rodrigo Ferreira rodrigof_si...@yahoo.com
Subject: Multi-Master Asynchronous Replication
Hi,
Is that a way to make multi-master asynchronous replication with mysql ou
external lib?
I know galera cluster but it is synchronous.
The problem is a set of
Thanks for your response.
In this case, circular replication is not apropriate because there are about 10
to 15 nodes, and it is known that availability decreases on circular setup as
the number of nodes increases.
Another reason (related to availability) is that nodes are eventually
Sorry, I will check this = with recent MariaDB, a slave can have multiple
masters
On Monday, November 24, 2014 2:26 PM, Rodrigo Ferreira
rodrigof_si...@yahoo.com wrote:
Thanks for your response.
In this case, circular replication is not apropriate because there are about 10
to 15
On 11/24/2014 10:00 AM, Johan De Meersman wrote:
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
Well, this mailing list is dead. This is a mailing list that used to
handle 70+ questions a day, or more.
Is that why you feel the need
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
abandoned. What would you have done in those days when we handled so
much mail in this list that there was no time to answer trolls... the
real trolls?
We? You mean the two mails you sent back
, 2014 at 12:04 PM, Ruben Safir ru...@mrbrklyn.com wrote:
On 11/24/2014 10:00 AM, Johan De Meersman wrote:
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
Well, this mailing list is dead. This is a mailing list that used to
handle 70
On 11/24/2014 12:19 PM, Johan De Meersman wrote:
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
abandoned. What would you have done in those days when we handled so
much mail in this list that there was no time to answer trolls... the
real
On 11/24/2014 12:19 PM, Johan De Meersman wrote:
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
abandoned. What would you have done in those days when we handled so
much mail in this list that there was no time to answer trolls... the
real
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
where were you in 2000, youngerman?
Busy writing WAP backends powered out of MySQL and Oracle, if I remember
correctly :-) But, indeed, not on this list; and if you were here back then I
may have
De Meersman wrote:
- Original Message -
From: Ruben Safir ru...@mrbrklyn.com
Subject: Re: MySQL dying?
Well, this mailing list is dead. This is a mailing list that used to
handle 70+ questions a day, or more.
Is that why you feel the need to troll on posts from two years ago
I watched a keynote from Thomas Ulin at Percona Live London a few weeks
back, and the slides are quite interesting:
https://www.percona.com/live/london-2014/sites/default/files/slides/PerconaLondon14_keynote.pdf
There's a lot of haters (some with more valid reasons to hate, others with
little or
On Wed, Dec 05, 2012 at 12:41:09PM +0100, Johan De Meersman wrote:
- Original Message -
From: Anthony Pace anthony.p...@utoronto.ca
I have heard that due to Oracle taking over, the OS community is
shifting to other type of DB's .
I think the question has long been answered.
On Tue, 18 Nov 2014 13:09:25 +, Daniel Rios Couto wrote:
You could try MEDIUMTEXT (16mb) or LONGTEXT (4gb) for a very large
text...
On Tue Nov 18 2014 at 7:39:11 AM Reindl Harald h.rei...@thelounge.net
wrote:
Am 18.11.2014 um 10:48 schrieb thufir:
I'm trying to store a web page to
Am 18.11.2014 um 10:48 schrieb thufir:
I'm trying to store a web page to table pages (whether or not that's a
good idea for a separate thread, please). What would be a suitable type
for the field which stores the actual page source?
text = 64 KB including all spaces and meta chars
You could try MEDIUMTEXT (16mb) or LONGTEXT (4gb) for a very large text...
On Tue Nov 18 2014 at 7:39:11 AM Reindl Harald h.rei...@thelounge.net
wrote:
Am 18.11.2014 um 10:48 schrieb thufir:
I'm trying to store a web page to table pages (whether or not that's a
good idea for a separate
Hi,
This is an example:
ALTER TABLE cart ADD CONSTRAINT fk_cart_customers FOREIGN KEY (custid)
REFERENCES customers (custid)
ON DELETE CASCADE
ON UPDATE NO ACTION;
(take from the GUI tool Database Workbench, avoids having to know the syntax
;) )
With regards,
Martijn Tonies
Upscene
On 14-11-17 01:42 AM, thufir wrote:
Looking at the docs:
http://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html
how do I alter the child table, links, so that it has a foreign key with
the parent table, feeds?
The workbench GUI came up with:
ALTER TABLE
On 14-11-17 01:42 AM, thufir wrote:
Looking at the docs:
http://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html
how do I alter the child table, links, so that it has a foreign key with
the parent table, feeds?
The workbench GUI came up with:
ALTER TABLE
On Mon, 17 Nov 2014 10:59:15 +0100, Martijn Tonies (Upscene Productions)
wrote:
In general, an index is used for performance, while a constraint is
used for logical concepts, like uniqueness. Most often, the DBMS uses an
index to implement these logical concepts, but it's better to understand
701 - 800 of 101064 matches
Mail list logo