the dump file?
Regards
Manivannan S
DISCLAIMER: This email message and all attachments are confidential and may
contain information that is Privileged, Confidential or exempt from disclosure
under applicable law. If you are not the intended recipient, you are notified
that any dissemination
2014/11/02 13:19 +0100, Zbigniew
So you guys (Jan and hsv) suggest, that switching from DATE to more
numeric data type may not be necessary, but using ENUM instead of
VARCHAR can be real performance gain, right?
But are you able to estimate, what boost can i notice? 5% - or 50%,
or maybe even
wow it really helped me a lot. I really thank Shawn,Dale Jesper for there
inputs
On Wed, Aug 21, 2013 at 7:13 PM, shawn green shawn.l.gr...@oracle.comwrote:
Hello Naga,
On 8/21/2013 6:45 AM, Nagaraj S wrote:
Hello,
Can anyone share the features/comparison from MySQL version 3.23 to 5.x
Hello,
Can anyone share the features/comparison from MySQL version 3.23 to 5.x in
single document? I can get from Google, however I have to navigate
different pages/sites, if it is in single document that will be useful to
see the overview of mysql features
-Naga
some MySQL sites and other blogs, I have seen that VIEWS
will never improve the performance. But here I see some improvements with a
view.
I would like to know how VIEW is improving the performance.
Regards
Manivannan S
DISCLAIMER: This email message and all attachments are confidential
on how smooth you want it.
* 9=10-1
* @a := 0 should be changed to some reasonable starting value, else the graph
will be artificially low to start with.
Hunh, MySQL: to use the optimizer s order for an initial value never would have
occurred to me.
The important thing in using decaying average (I
2012/07/07 12:10 -0600, Albert Padley
I have a log file that captures data from various sensors every minute that
we use to draws graphs on our website.
The table looks like this:
CREATE TABLE `log` (
`id` int(14) NOT NULL auto_increment,
`VarName` varchar(255) NOT NULL,
`TimeString`
to install MySQL
glibc23 package.
I want to know why MySQL glibc23 package is not able to install with SELinux
enabled??
Thanks in advance.
Regards,
Manivannan S
DISCLAIMER: This email message and all attachments are confidential and may
contain information that is privileged
Here is something queer:
select ifnull(email, round(1 * rand(), 1)) as ux, count(*) from nam group
by ux;
ERROR 1062 (23000): Duplicate entry '2514.0' for key 'group_key'
I have a name-list, with e-mail address or not. I wanted to fill the NULL
e-mail addresses with something random, and,
2012/07/05 21:01 +0200, Claudio Nanni
you might have hit: http://bugs.mysql.com/bug.php?id=58081
Indeed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
2012/06/13 10:06 -0500, mos
You may want to look into Handler. I've used it often when I needed to traverse
very large MyISAM tables. Handler requires no physical sorting of the table
because it traverses the table using an index. It also ignores any locks on the
table (which you may or may
DISTINCT makes a pass over the temp table to dedup.
The help example shows a UNION s each SELECT separatly round-bracketed,
(SELECT ruid1, ruid2, overlap FROM l4_link WHERE ruid1=xxx)
UNION
(SELECT ruid1, ruid2, overlap FROM l4_link WHERE ruid2=xxx)
ORDER BY overlap DESC
2012/06/21 17:06 -0500, Gael Martinez
I'm getting that done today thru a large static trigger script and I would
like something more dynamic...
For that it is needful to look up the table in INFORMATION_SCHEMA.COLUMNS, and,
yes, you can look up the field names--but then what will you do with
in terms of second, minute, hourly, weekly and Monthly
report also.
From: Ananda Kumar [mailto:anan...@gmail.com]
Sent: Thursday, June 14, 2012 12:32 AM
To: Rick James
Cc: Johan De Meersman; Manivannan S.; mysql@lists.mysql.com
Subject: Re: NoSQL help
Did you try with myisam tables.
They are supposed
plan for 1.5 milion records..
From: Ananda Kumar [mailto:anan...@gmail.com]mailto:[mailto:anan...@gmail.com]
Sent: Thursday, June 14, 2012 3:33 PM
To: Manivannan S.
Cc: mysql@lists.mysql.commailto:mysql@lists.mysql.com
Subject: Re: NoSQL help
can u share the sql, explain plan, indexes etc,
show
. this is my execution plan for 1.5 million
records
From: Ananda Kumar [mailto:anan...@gmail.com]
Sent: Thursday, June 14, 2012 3:33 PM
To: Manivannan S.
Cc: mysql@lists.mysql.com
Subject: Re: NoSQL help
can u share the sql, explain plan, indexes etc,
show full processlist out put when the sql's
.
I have seen the concept of NoSQL and I am planning to implement
this NoSQL concept into my database.
Does anyone have any idea in NoSQL especially MongoDB
technology and how to use this ?
Thanks in advance.
Regards,
Manivannan S
DISCLAIMER: This email
the server but data
still exist in the ibdata1 data file.
How to reduce the ibdata1 file size in both LINUX and WINDOWS machine.
Do you have any idea how to solve this problem. Thanks for any feedback.
Thanks
Manivannan S
DISCLAIMER: This email message and all attachments are confidential
-expression handling --and MySQL s
regular-expression handling yields only 'yes' or 'no'-- , but, of course, if
one wishes to verify that it is right, that is another matter. Are there any
rules for that, or is the best recourse to get a file of good outbound codes
from the post office
In the command show binary logs one may indifferently write binary or
master, and it is so for some other commands associated with this
function--but for the command show master status there is no such variant.
Why? Is it considered obsolescent?
--
MySQL General Mailing List
For list
2012/04/11 17:51 -0500, Peter Brawley
select b.peopleID, concat('(',p.fname,,')'), b.stateID, concat('(',s.state,')')
from bridge b
join people p on b.peopleID=p.peopleID
join state s on b.stateID=s.stateID;
Since the names are the same in the tables, it works to use USING, too, and
you
; 2012/04/12 11:56 -0700, Haluk Karamete
My initial goal was to write a very convenient php function that display a
table view based on arguments that are super simple to write - without
requiring the developer to type-in ( or know ) the ins and outs of joins,
natural joins etc.
Something
___5___florida__
What's the most straightforward way to achieve the following view with one
SQL statement?
peopleID__stateID_
1_(joe)___1__(california)_
2_(bob)___4__(texas)__
3_(charlie)___5__(florida)
Look at Stephen Tu s original
that MySQL works better if inner joining explicitly is stated, not
implicitly as you have it.
What are your keys, indices? Going by that which I have read heard, you want
every field named after this query s 'where' an index, if not key--and, of
course, your every field named '...key' is a key
service on LINUX
Am 05.04.2012 12:27, schrieb Manivannan S.:
Hi,
In 64-bit Linux(Centos/Red Hat) machine when I am
trying to start the MySQL service by using service mysql start command
, I am getting the following error
I have installed
MySQL-client-5.1.52-1.glibc23
-client-5.1.52-1.glibc23.x86_64.rpm
MySQL-server-5.1.52-1.glibc23.x86_64.rpm
In my Linux machine.
Does anyone know how to solve this issue in MySQL?
Thanks
Manivannan S
DISCLAIMER: This email message and all attachments are confidential and may
contain information that is privileged
:39, schrieb Manivannan S.:
Hi,
If I execute service myqsld start its saying
mysqld: unrecognized service
DISCLAIMER: This email message and all attachments are confidential and may
contain information that is privileged, confidential or exempt from disclosure
2012/04/04 19:56 +0200, joe j
/*STEP 2. from the dos prompt?*/
for x in UK ZA IN CN;
do mysql -ujoe -p -e INSERT INTO `table_new`
SELECT var1, var2`, (case when (country='${x}') then 1 else 0 end) AS citizen
,'${x}' AS ctry
FROM `'${x}'_table`
LEFT JOIN
WORLD
USING(YEAR);
For some reasons
-
From: lists-mysql [mailto:replies-lists-b3z1-my...@listmail.innovate.net]
Sent: Thursday, April 05, 2012 5:28 PM
To: Manivannan S.
Subject: RE: Error in starting MySQL service on LINUX
Original Message
Date: Thursday, April 05, 2012 11:04:48 AM +
From
2012/04/05 02:15 -0700, sam
I have data file written in SQL Server Compact.I need to Convert it to MySQL.
Does anyone know how to do that?
If it stores in CSV files, you can use that for the data, although to make
MySQL read it, you hav to fiddle with it. The SQL, for tables procedures, you
,UK,12121
100,UK,12121
100,UK,12121
However in my SELECT statement if I use SELECT DISTINCT (field_name), I
only get back one record.
It is in JOIN s nature to multiply output, but unless you show your whole
query, noöne can comment on it. As for DISTINCT, its purpose is as you saw, to
eliminate
2012/04/03 22:27 +0200, joe j
So what I am trying to get is a script that runs through a list of
country names (US, UK, NL, etc) and create tables for each one of them
as above. Is this feasible in MySql?
There are PROCEDUREs, and there is PREPARE. Look them up.
--
MySQL General Mailing List
On Wed, Mar 28, 2012 at 2:56 PM, Rich Jones r...@gun.io wrote:
Hey folks!
This gig just popped up on our system, thought it could be some easy money
for anybody out there who knows Ruby/Rails and how to optimize queries!
http://gun.io/contracts/67/improve-site-speed-for-startup
Normally I
2012/03/27 12:33 +0200, Johan De Meersman
MySQL does have a proper CSV engine; and it's mystifying why it isnt'
accessible in any other way. I say engine, and you can take that literally:
just like you have MyISAM and InnoDB engines, CSV is also an engine that is
applicable to tables.
Yes, I
2012/03/27 11:20 -0700, Todd Lyons
This seems backwards from what I expected:
mysql select convert(0xE29C94 using latin1), convert(0xE29C94 using utf8) \G
*** 1. row ***
convert(0xE29C94 using latin1): â
convert(0xE29C94 using utf8): ?
1 row
2012/03/27 00:22 +0200, Walter Tross
it looks like it's as simple as this:
insert into mytable (mycolumn) values (0xE29C94), (0xE29C98)
In some contexts it might be necessary to force the character set like this,
though:
convert(0xE29C94 using utf8)
Yes! and with this I can use it for a
; 2012/03/25 23:26 +0200, Walter Tross
I guess what you mean is Unicode characters U+2714 'HEAVY CHECK MARK' and
U+2718 'HEAVY BALLOT X'
(http://www.fileformat.info/info/unicode/char/2714/index.htm and
http://www.fileformat.info/info/unicode/char/2718/index.htm).
Unicode has several encodings,
; 2012/03/19 12:06 -0400, Steven Staples
SELECT `user_id`, GROUP_CONCAT(DISTINCT `login_ip`) AS 'login_ips',
COUNT(`id`) AS 'connections'
FROM `mysql_test`
WHERE `login_datetime` BETWEEN '2012-03-19 00:00:00' AND '2012-03-19
23:59:59'
GROUP BY `user_id`
HAVING COUNT(`id`) 2
ORDER BY COUNT(`id`)
2012/03/16 13:30 -0400, Simon Wilkinson
My query for this is as follows: select * from table where table.date1 -
table.date2 between 28425600 and 29030400;
I would not count on that subtraction s yielding a meaningful number: the types
are not Unix timestamps. I would use TIMESTAMPDIFF
2012/03/08 16:11 -0500, Hank
I have a varchar field in the database, and I want to remove all text
between WordA and WordB, including WordA and WordB, leaving all text
before WordA and after WordB intact.
Possible with just SQL? I know I can write a PHP program to do it,
but it's not that
2012/03/01 19:56 -0800, Don Wieland
I do not get the same results. Am I missing something? Hopefully
something simple ;-)
O, you are. You do not want GROUP_CONCAT in the subquery. It gives you the
comma-separated string whereto you referred, which, as far as the IN goes, is
only one string
2012/02/29 11:43 -0500, Ed Patterson
The select concat() works from the command line
I can manually add the file name but would like to automate the process
Lastly, if it makes a difference, I don't use any graphical tools for DB stuff.
Look up the command!
; 2012/02/29 15:29 -0600, Johnny Withers
Sounds like you need to LEFT JOIN:
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHONE AND CALLS.DATE = 02/28/12
WHERE CUSTOMERS.DATE = 02/28/12
But that would only get customers created on 2/28 AND having a call on 2/28
OR not call
2012/02/05 21:56 -0800, Peter Brawley
On 2/5/2012 9:21 PM, Michael Dykman wrote:
You are right. It seems to have fallen into disuse since I used it last.
AFAIK it has never been used.
One use occurred to me, and I was thinking of this, to set date_format in the
configuration file, and pass
2012/02/06 11:33 -0400, Paul Halliday
Is it possible to wrap a DELETE statement in an ON DUPLICATE KEY UPDATE?
Something like: ON DUPLICATE KEY UPDATE host=b1 (DELETE FROM
another_table WHERE host=b1) ?
No; see http://dev.mysql.com/doc/refman/5.5/en/insert.html
Such things are done in
from -MM-DD to MM/DD/YYY
That is MySQL s string format, and that is what you get. That said, there is a
function DATE_FORMAT (look it up) that lets one change its look. Its format
argument is quite ugly.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
; 2012/01/31 10:52 +0100, Johan De Meersman
Not *entirely* accurate: MySQL does include a CSV engine that you can use in
the same way you would use InnoDB or any other engine.
If you create a table a with engine=CSV and then go look at the data
dictionary, you'll find the files a.frm and a.CSV
2012/01/30 15:06 +0800, James
I am involved in a project to migrate our entire database from Microsoft
SQL to MySQL.
I would appreciate the help if anyone could share what tools will you
recommend of converting SQL database to MySQL.
If it is SQL server, maybe dumping in character form (CSV)
20120126 10:34 AM +0200, a bv
Database contains
tables (structures?) which gets montly data , and these tables are
named as
name1_name2_ yearmonth . I only want to have the whole database system
for last 2 years, and automaticly clean the data which became more
than 2 years old , so i need a
This is a decent approximation to matching one word in an email-address,
separated by dots, and, of course, the commercial multiplication sign @
[!#-'*+/-9=?A-Z^-~-]+
but I want to add the Latin1 graphics to it. Is this best done by concatenation,
'[-!#-''*+/-9=?A-Z^-~' || x'A0' || '-' ||
; 20111219 03:42 PM -0800, Jim McNeely
Not if you are using innoDB tables. For these, you use INSERT and UPDATE
triggers.
Jim McNeely
On Dec 19, 2011, at 11:58 AM, Halász Sándor wrote:
2011/12/19 11:30 -0800, Jim McNeely
In the MySQL documentation, we find this tantalizing statement:
It
2012/01/16 19:57 -0800, Haluk Karamete
MSSQL can be configured to work in either mode. Isn't such a thing for mySQL?
For most of the time, I would not care about case-sensitivity. So I
won't mind configuring the entire mysql operation to be case
insensitive once and for all?
In MySQL some
2012/01/16 19:37 +0800, mantianyu
but at last step I start the service by run
sudo bin/mysqld_safe --user=mysql
I got following error message
cifer@Pig:/usr/local/mysql$ 120116 19:15:28 mysqld_safe Logging to
'/var/log/mysql/error.log'.
Your means of starting does not show where the
; 2012/01/03 11:52 -0500, Govinda
...which strikes me as odd (again, showing how new I am to driving from the
CL), because I do NOT see any entry like this:
/usr/local/mysql/bin/mysqldump
Is mysql a symbolic link?
..which I just (earlier this morning) changed to this:
export
2012/01/02 15:47 +0530, Adarsh Sharma
ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE
line 31 of what? Likly it would be helpful to show it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
2011/12/29 19:35 +0100, Reindl Harald
for the hadnful things on my linux-machines where such non-default
locations are existing i usually set symlinks unter /usr/local/bin/
to the binarys, so they are seperated and from the user point
of view in the PATh and all wroks fine
The weakness of PATH:
2011/12/27 18:13 +, Mark Haney
So, what the heck is going on here? I'm at the end of my wits.
I suspect that you have to make the block delimiter something other than
semicolon, and set the block in a routine or trigger.
Semicolon terminates SQL routine statements, after PL1. If the
2011/12/19 11:30 -0800, Jim McNeely
In the MySQL documentation, we find this tantalizing statement:
It is possible that in the case of a duplicate-key error, a storage engine may
perform the REPLACE as an update rather than a delete plus insert, but the
semantics are the same. There are no
2011/12/19 13:55 -0800, Jim McNeely
Anyway, I just thought I would share. BTW I experimented, and innoDB does
updates and fires off update triggers for REPLACE statements, but MyISAM does
delete/inserts.
Thank you. Which version?
Well, then the documentation is wrong: it is indeed visible
2011/12/16 16:00 -0800, Jim McNeely
I have a set of tables that get populated and changed a lot from lots of
REPLACE statements. Now, I need an ON UPDATE trigger, but of course the trigger
never gets triggered because REPLACES are all deletes and inserts.
The trigger is going to populate
2011/12/13 16:10 -0500, Shawn Green (MySQL)
Many of you are missing the big picture. This flag (along with most of the
others you can use to describe a stored procedure) are meant to indicate to the
replication system whether it needs to log the CALL to this procedure and in
which format.
I saw that in some complex query of mine where I expected date I saw
varchar(29). The relevant part is that the first argument to ADDDATE is the
LEAST of two DATEs.
Unhappilie, all the type changes are clearly documented--the most annoying is
LEAST :
In all other cases, the arguments are
What happens if your Perl script generates (UTF8) SQL output instead of sending
the Perl Module it? Does it look right?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
2011/12/09 20:37 -0500, Singer X.J. Wang
When the procedure is executed, each query in the procedure is obviously run
through the query optimizer. But the flags are symbolic only for humans.
Obviously? As I wrote, someone said that the optimizer does _not_ look into
procedures.
Symbolic is
; 2011/12/08 10:21 -0500, Singer X.J. Wang
But again one of the flags are binding in any way. There's nothing preventing
me from declaring my procedure
* READS SQL DATA indicates that the routine contains statements that read
data (for example,
2011/12/05 14:26 -0500, Singer X.J. Wang
Note that all the flags are non binding.. YMMV...
Yes, but what does it _mean_?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
'%patron%' is in the gross linear, and
also, say, LOCATE('patron', ) in a setting where only 0 or not 0 is tested for.
If all your LIKE-searches look like this one, a string to be matched from a
value by putting it between '%'s, maybe by using LOCATE you can save
time--unless the MySQL developers were
A procedure MODIFIES SQL DATA if all the modifying involves a temporary table,
or only READS SQL DATA?
Does it matter whether the temporary table is meant to outlast the
procedure-call?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
As for FLOOR in an ON-clause, surely the general-builtin-function overhead
completely overwhelms the operation s cost. Maybe index on Dewey would help.
(Which Dewey? with computer under math, c, or with computer under 000? Where
can one get a 1000-element list for computer?)
--
MySQL General Mailing
2011/11/29 23:19 +0100, Reindl Harald
MY only luck is that i recognized this years ago after PLAYING
with innodb and so i started with innodb_file_per_table=1 from
the begin with the first production database
And are then the table-files in the directories with frm, or in the
directory
The following always is the outcome of the command show create trigger:
mysql show create trigger memberchange;
ERROR 1602 (HY000): Corrupted TRG file for table `membership`.`address`
mysqld x86 5.5.8 under Vista
The trigger works, there is no problem with show triggers, and this error
appears
; 2011/11/22 12:44 -0800, Sean Sidelko
We just moved a large amount of data off one of our db servers to another one
(75gb of data). One thing I've noticed is that over the last couple days the
free innodb space has been decreasing by over 2.5 gb a day while we've only
been adding 400 mb of
; 2011/11/20 20:27 +, Tompkins Neil
Does anyone know why Chinese characters are not displaying correctly in a
replicated database on a slave machine ? I'm just getting square boxes.
What displays them? it sounds to me as if the display lacks something, not so
much MySQL.
--
MySQL
2011/11/14 18:01 +, Rob Tanner
So what are those files and can I delete all but the most recent?
And if you look up replication, as others already have said, you will find that
the command reset master will do just that--if, as Harald hinted, you really
_want_ replication, or at least
2011/11/14 18:01 +, Rob Tanner
So what are those files and can I delete all but the most recent?
And if you look up replication, as others already have said, you will find that
the command purge binary logs to 'mysql-bin.' will do just that--if, as
Harald hinted, you really _want_
there is the constraint that field domain_id refers
to table virtual_domains s field id . Therefore, to delete a record from
virtual_domains it is needful first to delete from domain_admins the record
with domain_id equal to id . After that it will let one delete the record
from virtual_domains
I was using this query and getting queer results:
SELECT MemberID, Surname, Houshold, Houmuch, CASE WHEN Houmuch
(SELECT sharePrice FROM Stock) THEN ADDDATE(ereStart, (Houmuch * (SELECT hwyl
FROM Stock)) / (SELECT regularPayment FROM Stock)) ELSE TIMESTAMPADD(YEAR, 2,
CURDATE()) END
; 2011/10/20 10:21 -0400, Shawn Green (MySQL)
On 10/19/2011 17:50, wrote:
I made this query a view, called MEMBERP, no problem:
...snip...
Only GivenName is derived from GROUP_CONCAT and is also a lesser field for
ordering by. Why is that a problem?
Perhaps it is the USING clause that is
2011/10/24 16:31 -0700, Daevid Vincent
WHERE cs.customer_id = 7
GROUP BY customer_id
Well, the latter line is now redundant.
How will you make the '7' into a parameter?
--
MySQL General Mailing List
For list archives:
by userID
)
Well done--but
Although, it seems, it is everyone s experience that the desired order is the
order that MySQL yields, all guarantee of that is explicitly deny'd (look up
'GROUP BY'). It is better to be safe and to use MIN:
select * from table1 where messageID NOT IN (
select MIN
; 2011/10/19 17:00 +0200, Dotan Cohen
mysql select * from beers b outer join colours c on (b.colour = c.ID);
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'outer join colours c on (b.colour
I made this query a view, called MEMBERP, no problem:
SELECT MemberID, ereStart, DateModified, MembershipExpires, MemberSince,
Category, Boardster, GROUP_CONCAT(DISTINCT Salutation ORDER BY Rank) AS
Salutation, GROUP_CONCAT(DISTINCT GivenName ORDER BY Rank) AS GivenName,
GROUP_CONCAT(DISTINCT
2011/10/14 11:12 -0700, AndrewMcHorney
I just downloaded the MySql server software. I am now looking for software that
is gui based and will allow me to easily define a database, create tables and
to do updates of records within the tables. It would be fantastic if the
software had report
Generally when one has this problem one joins this query with something from
which one can get the whole list, something like this:
SELECT identifier, IFNULL(c, 0) AS Good,
(query with COUNT) AS P RIGHT JOIN table-of-identifiers ON P.identifier =
table-of-identifiers.identifier
The c is
it (like an ordinary user s doing bare su in
Unix) I make Vista crash with the blue-screen message process or task critical
to system operation has been terminated or exited.
The start is needed, also the administrator authority and the user that
ordinarily lacks it.
Of course
2011/10/10 09:19 -0400, Brandon Phelps
If this column(s) is/are a character type now, then you would need to have the
values in quotes.
Note that because of implicit conversion if they had numberic values no error
would be reported, but maybe the equality would not be exact.
--
MySQL
Does the optimizer look into function called from query?
In my queries the expression (SELECT hwyl FROM Stock) / (SELECT regularPayment
FROM Stock), where Stock is a one-record table, often is repeated. The
optimizer sees that, and makes the ratio a constant, and I can afford to be
clear. If
2011/10/02 15:01 +0200, Jigal van Hemert
You are not using NULL as the original concept of it was. NULL means that the
value is undefined or unknown.
That is quite true, especially in a table. But, almost from the beginning, NULL
was overloaded:
set @m = (select sins from emailinglist where
2011/09/30 20:08 -0700, Jan Steinman
Okay, I've reviewed the online man page for date and time functions, and I've
played with several likely candidates, and I am still having trouble
subtracting two arbitrary Datetimes to get something that is useful. A simple
subtraction yields the least
equality. If I
write
IF A = B THEN
then if one is NULL and the other not, and the code is such that never are both
NULL, well, for my purpose they are not equal: so good. But if I write
IF A B THEN
often I want it NULL-safe, for if one is NULL and the other not, I want that
true--and MySQL s
Which of these statements for picking one of the rarest Boardsters do best
like?
SELECT Boardster
FROM (SELECT count(*) as N
FROM memberaddress GROUP BY Boardster order by N limit 1) aS P join
(SELECT count(*) AS N, boardster
FROM memberaddress GROUP BY Boardster) as Q USING (N)
2011/09/27 05:32 -0700, supr_star
Here's a simple query: select name,status,min(dt), max(dt),count(*) from
mytable group by name I need an efficient way to get this data, along with the
status of the row with the max(dt). 'status' is not in the group by, so I get
apparently random statuses.
2011/09/23 12:56 +0200, Johan De Meersman
What it says, is If you are going to run many operations. You are updating
many rows, but you are only doing ONE operation: a single update statement.
For what it's worth, the downloading HTML help claims this only for MyISAM
tables, because between
are now often used to get
workers and patrons to pay for that which formerly the company paid: forms,
instruction books, With online banking the bank pays fewer tellers. The
company s only bizness is to sell something, and after the sale vanish if may
be.
--
MySQL General Mailing List
2011/09/03 03:40 +0800, Dennis
But it seems that there is no select ... into LOCAL file statement. Any
suggestion is appreciated.
Indeed: you can use only standard output.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
takes less time than table (you have not shown your table code) only
because of the problem s size. If you had thousands of numbers the string at
first would be only slower, but with enough it would not work at all, because
you would reach MySQL s string-size limit.
A benchmark of repeatedly
with the connection.
I wrote an edit-distance function, and two procedures, that use temporary table
for array. The procedures s outcome was in the temporary tables. In routines
there are table-use restrictions, more in functions than procedures, and I so
wrote my function because of them.
--
MySQL
2011/08/26 13:58 -0700, javad bakhshi
Thanks guys for the help. but my problem seems to stand unsolved.
Right, no arrays. Nothing is left but table. I used a temporary table, but note
that MySQL also does not let table be returned, or passed in. The table-name
will be *sigh* global.
--
2011/08/18 18:30 +0300, Marius Feraru
Thanks for your time reading my message, but I don't understand what
is the result context that you are talking about. Could you please
elaborate?
Well, if an expression is an argument to, say, CONCAT, the expression s
result is character string
2011/08/24 02:05 -0700, javad bakhshi
Hi, I would like to create a function in Mysql that returns an Array of
Numbers. I am trying to run a big amount of stream of data on Mysql and I can't
afford the time to store the data into a table and retrieve it later.
Are there any arrays at all in
1 - 100 of 677 matches
Mail list logo