for the column they go in. (Presumably, all the text columns will be
declared utf8 or utf8mb4.)
-Original Message-
From: Mark Phillips [mailto:m...@phillipsmarketing.biz]
Sent: Monday, September 24, 2012 4:28 PM
To: Mysql List
Subject: Need Help Converting Character Sets
I have a table
is, so that I get
something like this:
F_LEADS S_LEADS R_LEADS
44 122 32
Is this possible? If so can anyone help with syntax?
Thanks,
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
[mailto:gatorre...@gmail.com]
Sent: Thursday, September 13, 2012 9:51 AM
To: mysql@lists.mysql.com
Subject: query help
I have a table like this:
|ORDERS|
|ID| DATE | QNT | LEAD |
|342 | 8-12-12 | 32 | F|
|345 | 8-15-12 | 12 | S|
|349 | 8-16-12 | 9 | R|
I am
To: 'Richard Reina'; mysql@lists.mysql.com
Subject: RE: query help
I think this will get you there:
SELECT LEAD, COUNT(*) FROM ORDERS GROUP BY LEAD;
It'll give you something more like:
| LEAD | COUNT(*) |
| F | 44 |
| S | 122 |
| R | 32
But connect-timeout has nothing to do with termination of query. It is no.
of secs that mysqld server waits for a connect packet before responding
with Bad handshake, default value is 10 seconds.
Probably you should adjust net_read /write_ timeout.
But connect-timeout has nothing to do with termination of query. It is no.
of secs that mysqld server waits for a connect packet before responding
with Bad handshake, default value is 10 seconds.
Probably you should adjust net_read /write_ timeout.
- Original Message -
From: indrani gorti indrani.go...@gmail.com
Later I changed it to SET GLOBAL connect_timeout=60;
However, I still find that the query loses the connection to mysql
server after about 10 mins( 600.495 secs)
I see that the connect_time is 60 though.
If I recall
in advance for the help.
Regards,
Indrani Gorti
that the query loses the connection to mysql server
after about 10 mins( 600.495 secs)
I see that the connect_time is 60 though.
Can anyone please let me know whats wrong?
Thanks in advance for the help.
Regards,
Indrani Gorti
On Tue, Aug 21, 2012 at 8:26 PM, Larry Martell larry.mart...@gmail.com wrote:
On Tue, Aug 21, 2012 at 8:07 PM, h...@tbbs.net wrote:
2012/08/21 16:35 -0600, Larry Martell
I am trying to write a query that selects from both a correlated
subquery and a table in the main query, and I'm having a
On Thu, Aug 23, 2012 at 8:08 AM, Larry Martell larry.mart...@gmail.com wrote:
On Tue, Aug 21, 2012 at 8:26 PM, Larry Martell larry.mart...@gmail.com
wrote:
On Tue, Aug 21, 2012 at 8:07 PM, h...@tbbs.net wrote:
2012/08/21 16:35 -0600, Larry Martell
I am trying to write a query that selects
à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
Date: Tue, 21 Aug 2012 20:26:51 -0600
Subject: Re: help with correlated subquery
From: larry.mart...@gmail.com
To: h...@tbbs.net
CC: mysql@lists.mysql.com
On Tue, Aug 21, 2012 at 8:07 PM, h
...@gmail.com]
Sent: Tuesday, August 21, 2012 7:27 PM
To: h...@tbbs.net
Cc: mysql@lists.mysql.com
Subject: Re: help with correlated subquery
On Tue, Aug 21, 2012 at 8:07 PM, h...@tbbs.net wrote:
2012/08/21 16:35 -0600, Larry Martell
I am trying to write a query that selects from both a correlated
Hello Martin,
On 8/22/2012 8:30 AM, Martin Gainty wrote:
assign realistic alias names
OuterJoin should be called OuterJoin
InnerJoin should be called InnerJoin
Almost! MySQL does not have a simple OUTER JOIN command (some RDBMSes
call this a FULL OUTER JOIN). What we do have is the option
I am trying to write a query that selects from both a correlated
subquery and a table in the main query, and I'm having a lot of
trouble getting the proper row count. I'm sure this is very simple,
and I'm just missing it. I'll try and present a simple example. For
this example, there are 27 rows,
[mailto:larry.mart...@gmail.com]
Sent: Tuesday, August 21, 2012 3:35 PM
To: mysql mailing list
Subject: help with correlated subquery
I am trying to write a query that selects from both a correlated
subquery and a table in the main query, and I'm having a lot of trouble
getting the proper row count
)
on data_cst.target_name_id = x.t and ep = x.e
group by target_name_id, ep;
Returns the same result set.
-Original Message-
From: Larry Martell [mailto:larry.mart...@gmail.com]
Sent: Tuesday, August 21, 2012 3:35 PM
To: mysql mailing list
Subject: help with correlated subquery
I am trying
by target_name_id, ep,
wafer_id in the inner query, and then I need to group by
target_name_id, ep in the outer one. I only want to count the number
of target_name_id, ep groups.
Date: Tue, 21 Aug 2012 16:35:23 -0600
Subject: help with correlated subquery
From: larry.mart...@gmail.com
To: mysql
2012/08/21 16:35 -0600, Larry Martell
I am trying to write a query that selects from both a correlated
subquery and a table in the main query, and I'm having a lot of
trouble getting the proper row count. I'm sure this is very simple,
and I'm just missing it. I'll try and present a simple
On Tue, Aug 21, 2012 at 8:07 PM, h...@tbbs.net wrote:
2012/08/21 16:35 -0600, Larry Martell
I am trying to write a query that selects from both a correlated
subquery and a table in the main query, and I'm having a lot of
trouble getting the proper row count. I'm sure this is very simple,
2012/07/31 15:02 -0700, Haluk Karamete
So, in a case like this
shop.orders.32442
shop.orders.82000
shop.orders.34442
It would be the record whose source_recid is shop.orders.82000. Why? Cause
82000 happens to be the largest integer.
Now, if they are always 5-digit-long integers, try ending
: MySQL
Subject: Re: query help
On Tue, Jul 31, 2012 at 7:02 PM, Haluk Karamete
halukkaram...@gmail.com wrote:
I've got a text field called source_recid. It stores half string half
number like strings in it.
Example
shop.orders.32442
the syntax is DATABASENAME.TABLENAME.RECID
My
Hi,
Use LIMIT 1 to limit the number of output to single record.
Regards,
Vikas Shukla
On Wed, Aug 1, 2012 at 3:56 AM, Paul Halliday paul.halli...@gmail.comwrote:
On Tue, Jul 31, 2012 at 7:02 PM, Haluk Karamete halukkaram...@gmail.com
wrote:
I've got a text field called source_recid. It
I've got a text field called source_recid. It stores half string half
number like strings in it.
Example
shop.orders.32442
the syntax is DATABASENAME.TABLENAME.RECID
My goal is to scan this col and find out the biggest RECID ( the
integer) in it.
So, in a case like this
shop.orders.32442
On Tue, Jul 31, 2012 at 7:02 PM, Haluk Karamete halukkaram...@gmail.com wrote:
I've got a text field called source_recid. It stores half string half
number like strings in it.
Example
shop.orders.32442
the syntax is DATABASENAME.TABLENAME.RECID
My goal is to scan this col and find out
: Query take too long time - please help!
On 10.07.2012 13:16, Darek Maciera wrote:
2012/7/10 Ananda Kumar anan...@gmail.com:
can u show the explain plan for your query
Thanks, for reply!
Sure:
mysql EXPLAIN SELECT * FROM books WHERE
mysql LOWER(ksd)=LOWER('4204661375
.
But this SELECT take too long time:
mysql SELECT * FROM books WHERE ksd ='A309CC47B7';
1 row in set (2.59 sec)
Table is in InnoDB engine. I added to my.cnf: innodb_buffer_pool_size = 512MB
Any suggestions? Help, please..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
added to my.cnf: innodb_buffer_pool_size =
512MB
Any suggestions? Help, please..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
2012/7/10 Ananda Kumar anan...@gmail.com:
can u show the explain plan for your query
Thanks, for reply!
Sure:
mysql EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375');
you are using a function-LOWER, which will not make use of the unique key
index on ksd.
Mysql does not support function based index, hence your query is doing a
FULL TABLE scan and taking more time.
On Tue, Jul 10, 2012 at 4:46 PM, Darek Maciera darekmaci...@gmail.comwrote:
2012/7/10 Ananda
On 10.07.2012 13:16, Darek Maciera wrote:
2012/7/10 Ananda Kumar anan...@gmail.com:
can u show the explain plan for your query
Thanks, for reply!
Sure:
mysql EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375');
That's definitely not the query you showed the first time
On 6/22/2012 12:18 AM, Anupam Karmarkar wrote:
Thanks Rick for your reply,
Here i am asking about logic to perpare query or whole query itself.
A set-based approach to doing the basic task is to convert your set of
start/stop times into duration values. The timediff() function mentioned
June 2012 10:52 PM
Subject: RE: Need Query Help
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff
and SEC_TO_TIME()/3600
-Original Message-
From: Anupam Karmarkar [mailto:sb_akarmar...@yahoo.com]
Sent: Wednesday, June 20, 2012 2:39 AM
To: mysql
Hi All,
I need query help for following table struture, where we need to calculate
login duration of that employee for give period.
Example table
EmployeeID LoginTime LogoutTIme
101 2012-05-01 10:00:00 2012-05-01 12:30:00
102 2012
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff
and SEC_TO_TIME()/3600
-Original Message-
From: Anupam Karmarkar [mailto:sb_akarmar...@yahoo.com]
Sent: Wednesday, June 20, 2012 2:39 AM
To: mysql@lists.mysql.com
Subject: Need Query Help
Hi All
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
...@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 to be good for reporting requirement
On Wed, Jun 13, 2012 at 11:52 PM, Rick James rja...@yahoo
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
: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 are running
On Thu, Jun 14, 2012 at 3:03 PM, Manivannan S.
manivanna...@spanservices.com wrote
SHOW CREATE TABLE
SHOW TABLE STATUS
EXPLAIN SELECT ... \G
-Original Message-
From: Ananda Kumar [mailto:anan...@gmail.com]
Sent: Thursday, June 14, 2012 4:04 AM
To: Manivannan S.
Cc: mysql@lists.mysql.com
Subject: Re: NoSQL help
As seen below,
Full table scan is happening
@lists.mysql.com
Subject: RE: NoSQL help
I tried with myisam engine also. But it also taking more time to
generate the report. In my database I am having 8 innodb tables and at
the same time I am joining 4 tables to get the report.
I am maintaining 60days records because the user will try to generate
Hi all,
I am using MySQL 5.1, in this I am inserting 5GB of data for
two days into my database. I am trying to generate a report by processing these
data which are available in my database. Our clients are planning to keep the
records for 60 days then that will cross 150GB of
- Original Message -
From: Manivannan S. manivanna...@spanservices.com
Hi all,
[lots of data]
[slow reports]
[wooo NoSQL magic]
Not that I want to discourage you, but my standard first question is why do
you think NoSQL (let alone any specific product) is the right solution?
At 07:27 AM 6/13/2012, Manivannan S. wrote:
Hi all,
I am using MySQL 5.1, in this I am inserting 5GB of
data for two days into my database. I am trying to generate a
report by processing these data which are available in my database.
Our clients are planning to keep the
[mailto:vegiv...@tuxera.be]
Sent: Wednesday, June 13, 2012 6:20 AM
To: Manivannan S.
Cc: mysql@lists.mysql.com
Subject: Re: NoSQL help
- Original Message -
From: Manivannan S. manivanna...@spanservices.com
Hi all,
[lots of data]
[slow reports]
[wooo NoSQL magic]
Not that I want
help
- Original Message -
From: Manivannan S. manivanna...@spanservices.com
Hi all,
[lots of data]
[slow reports]
[wooo NoSQL magic]
Not that I want to discourage you, but my standard first question is
why do you think NoSQL (let alone any specific product
)?
-Original Message-
From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com]
Sent: Wednesday, May 23, 2012 7:10 PM
To: mysql@lists.mysql.com
Subject: Re: Need help for performance tuning with Mysql
Rick
Thank you for the reply.
1. There are only a few things worth tuning
, etc.
-Original Message-
From: Anupam Karmarkar [mailto:sb_akarmar...@yahoo.com]
Sent: Thursday, May 24, 2012 3:39 AM
To: Nigel Wood
Cc: mysql@lists.mysql.com
Subject: Re: Architectural Help
Dear Nigel,
Thank for reply..
See my comments below
--Anupam
Caution!! If any one of them dies and cannot be recovered, you will have a
mess to fix.
From: Prabhat Kumar [mailto:aim.prab...@gmail.com]
Sent: Wednesday, May 30, 2012 1:43 PM
To: Rick James
Cc: Anupam Karmarkar; Nigel Wood; mysql@lists.mysql.com
Subject: Re: Architectural Help
Hi Anupam
I have been working with a query but need to add a few more
conditions. I was a to do a query that contains a few more selects but
want to know if there is a more efficient way to get results I need:
This query is to find NEW or FORMER CLIENT within a moving window
(Date Range) of time.
2012/05/28 08:03 -0700, Don Wieland
Any assistance would be appreciated. Thanks!
Maybe something like this:
SELECT usie.client_id, first_name, last_name, COUNT(anie.client_id)
FROM
(SELECT client_id, first_name, last_name, time_start
FROM tl_appt
JOIN tl_rooms USING(room_id)
JOIN tl_clients
Alex
Thank you for the advice.
Probably, we will put index (key) on both columns.
Thanks,
Yu
Alex Schaft さんは書きました:
On 2012/05/24 07:37, Alex Schaft wrote:
You are selecting a record based on the value of data_id and
thold_enabled, but don't have an index on either? Add an index for both.
If
to
seperate process and make MySQL work in multiple process.
It would be a great help if people in this forum can give
us an adivice for the tuning.
Best Regards,
Yu Watanabe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hi All,
I need architectural help for our requirement,
We have nearly 50 data centre through out different cities from these data
center application connect to central database server currently, there are
conectivity and nework flcutions issues for different data center, so we comeup
is the central database server just ONE server, to which all your 50 data
center app connects
On Thu, May 24, 2012 at 2:47 PM, Anupam Karmarkar
sb_akarmar...@yahoo.comwrote:
Hi All,
I need architectural help for our requirement,
We have nearly 50 data centre through out different cities
Subject: Architectural Help
Hi All,
I need architectural help for our requirement,
We have nearly 50 data centre through out different cities from these data
center application connect to central database server currently, there are
conectivity and nework flcutions issues for different data center
Dear Nigel,
Thank for reply..
See my comments below
--Anupam
From: Nigel Wood nw...@plus.net
To: Anupam Karmarkar sb_akarmar...@yahoo.com; mysql@lists.mysql.com
mysql@lists.mysql.com
Sent: Thursday, 24 May 2012 3:35 PM
Subject: RE: Architectural Help
NULL
Did you really mean to have 3 values (on, off, NULL)?
-Original Message-
From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com]
Sent: Wednesday, May 23, 2012 7:10 PM
To: mysql@lists.mysql.com
Subject: Re: Need help for performance tuning with Mysql
Rick
Thank you
3:39 AM
To: Nigel Wood
Cc: mysql@lists.mysql.com
Subject: Re: Architectural Help
Dear Nigel,
Thank for reply..
See my comments below
--Anupam
From: Nigel Wood nw...@plus.net
To: Anupam Karmarkar sb_akarmar...@yahoo.com; mysql
in multiple process.
It would be a great help if people in this forum can give
us an adivice for the tuning.
Best Regards,
Yu Watanabe
__
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi,
How much ever tuning you do at my.cnf will not help much, if you do not
tune your sql's.
Your first priority should be tune sql's, which will give you good
performance even with decent memory allocations and other settings
regards
anandkl
On Wed, May 23, 2012 at 3:45 PM, Andrew Moore eroomy
100% CPU -- A slow query. Tuning will not help. Period.
1. There are only a few things worth tuning -- see
http://mysql.rjweb.org/doc.php/memory (they don't include the ones you tried)
2. Instead INDEXes and schema design must be studied. Please provide:
SHOW CREATE TABLE
SHOW TABLE SIZE
/shm)
Thanks,
Yu
Rick James さんは書きました:
100% CPU -- A slow query. Tuning will not help. Period.
1. There are only a few things worth tuning -- see
http://mysql.rjweb.org/doc.php/memory (they don't include the ones you tried)
2. Instead INDEXes and schema design must be studied. Please provide
On 2012/05/24 04:10, Yu Watanabe wrote:
2. Instead INDEXes and schema design must be studied. Please provide:
SHOW CREATE TABLE
| thold_data | CREATE TABLE `thold_data` (
`id` int(11) NOT NULL auto_increment,
`rra_id` int(11) NOT NULL default '0',
`data_id` int(11) NOT NULL
On 2012/05/24 07:37, Alex Schaft wrote:
You are selecting a record based on the value of data_id and
thold_enabled, but don't have an index on either? Add an index for both.
If data_id is unique, then you would only need an index on that.
Alex
On second thought, an index on thold_enabled
.
It would be a great help if people in this forum can give
us an adivice for the tuning.
Best Regards,
Yu Watanabe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
process.
It would be a great help if people in this forum can give
us an adivice for the tuning.
Best Regards,
Yu Watanabe
__
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
MySQL work in multiple process.
It would be a great help if people in this forum can give
us an adivice for the tuning.
Best Regards,
Yu Watanabe
__
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
CPU user 25%
sys 5%
io 3%
I assume that MySQL can work more but currently not.
I am considersing to off load 1 high load database to
seperate process and make MySQL work in multiple process.
It would be a great help if people in this forum can give
us an adivice
MySQL work in multiple process.
It would be a great help if people in this forum can give
us an adivice for the tuning.
Best Regards,
Yu Watanabe
__
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
25%
sys 5%
io 3%
I assume that MySQL can work more but currently not.
I am considersing to off load 1 high load database to
seperate process and make MySQL work in multiple process.
It would be a great help if people in this forum can give
us an adivice for the tuning
Hi.
On Friday 18 May 2012 18:21:07 Daevid Vincent wrote:
Actually, I may have figured it out. Is there a better way to do this?
I don't see why you need the dvds table when the dvd_id is in the scene table:
SELECT a.dvd_id
FROM scenes_list a, moviefiles b
WHERE a.scene_id = b.scene_id
AND
...@wastedtimes.net]
Sent: Saturday, May 19, 2012 3:34 PM
To: mysql@lists.mysql.com
Subject: Re: SQL query help. Retrieve all DVDs that have at least one scene
of a certain encoding format
Hi.
On Friday 18 May 2012 18:21:07 Daevid Vincent wrote:
Actually, I may have figured it out. Is there a better
I would work from the inside out. What you're doing is grouping scenes
by DVD and throwing away the ones that have no scenes. If you start
with DVDs and do a subquery for each row, you'll process DVDs without
scenes and then filter them out. If you start with a subquery that's
grouped by DVD ID,
I have a table of DVDs, another of scenes and a last one of encoding
formats/files...
I want to find in one query all the dvd_id that have 0 scene_id that's
encoded in format_id = 13.
In other words all DVDs that are format_id = 13 despite not having a direct
link.
CREATE TABLE `dvds` (
-Original Message-
Sent: Friday, May 18, 2012 5:34 PM
I have a table of DVDs, another of scenes and a last one of encoding
formats/files...
I want to find in one query all the dvd_id that have 0 scene_id that's
encoded in format_id = 13.
In other words all DVDs that are
Hi folks,
I am trying to compile a query that does statistics on appointments
based on specific criteria. Here is my starting query:
SELECT
u.user_id,
c.client_id,
c.first_name,
c.last_name,
a.time_start AS stime,
FROM_UNIXTIME(a.time_start,'%Y-%m-%d') AS formatted
| 40 |
| AZ| Phoenix |1428509 | 51 |
| CA| Los Angeles |3877129 |447 |
...
-Original Message-
From: Don Wieland [mailto:d...@pointmade.net]
Sent: Thursday, May 17, 2012 7:37 AM
To: mysql@lists.mysql.com
Subject: Query help,,,
Hi folks,
I am trying
On 2012-05-17 9:37 AM, Don Wieland wrote:
Hi folks,
I am trying to compile a query that does statistics on appointments
based on specific criteria. Here is my starting query:
SELECT
u.user_id,
c.client_id,
c.first_name,
c.last_name,
a.time_start AS stime,
Dear Friends,
I m new on this list, and I m trying to learn more about mysql.
After perform a lot of searchs in the Internet, I have no answer to my
question and would like to ask your help.
I wanna a perform a query that depends of the result from another (query)
table inside the same
)
AND messageID NOT LIKE = ‘XX’
On 04/22/2012 09:30 PM, Rafael Ribeiro wrote:
Dear Friends,
I m new on this list, and I m trying to learn more about mysql.
After perform a lot of searchs in the Internet, I have no answer to my
question and would like to ask your help.
I wanna
Hello!
I am trying to do something, but I can't seem to figure out how...
My query is as follows:
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'
Try this
SELECT `user_id`, `login_ip`,
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`, `login_ip`
HAVING COUNT(`id`) 2
ORDER BY COUNT(`id`) DESC
LIMIT 0, 15;
On Mar 19, 2012, at 12:06 PM, Steven
-Original Message-
From: Mihail Manolov [mailto:mihail.mano...@liquidation.com]
Sent: March 19, 2012 12:44 PM
To: Steven Staples
Cc: mysql@lists.mysql.com
Subject: Re: Group_Concat help...
Try this
SELECT `user_id`, `login_ip`,
COUNT(`id`) AS 'connections'
FROM `mysql_test
; 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`)
Hi Victor,
To answer your question about saving the table.
This URL http://dev.mysql.com/doc/refman/5.6/en/myisam-repair.html - *Stage
3: Difficult repair* directly addresses your concerns.
You also may want to look into different option of REPAIR TABLE command
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
Appreciate a little guidance here:
Background: I have an invoicing system. Invoices are generated and
(invoice and Invoice Items) and Payments are generated (Payments and
Payment Items). Payment items are amount of the Payment Total
allocated to payoff open invoices. So I may have 3 open
Little help...
In my mySQL query editor, I am trying to return a value of 0 when
there is no related rows from this query:
(select if(count(ip.payment_amount) IS NOT NULL,
count(ip.payment_amount) , 0) FROM tl_trans_pmt_items ip WHERE
t.transaction_id = ip.inv_id GROUP BY ip.inv_id
http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_ifnull
On Wed, Feb 29, 2012 at 13:15, Don Wieland d...@pointmade.net wrote:
Little help...
In my mySQL query editor, I am trying to return a value of 0 when there is
no related rows from this query:
(select
On 2/29/2012 1:15 PM, Don Wieland wrote:
Little help...
In my mySQL query editor, I am trying to return a value of 0 when
there is no related rows from this query:
(select if(count(ip.payment_amount) IS NOT NULL,
count(ip.payment_amount) , 0) FROM tl_trans_pmt_items ip WHERE
t.transaction_id
To: mysql@lists.mysql.com
Sent: Monday, 16 January, 2012 12:37:07 PM
Subject: help! mysqld cannot start!
I have download the
Linux - Generic 2.6 (x86, 32-bit), Compressed TAR Archive
binary edition
and I installed it all followed the INSTALL_BINARY
but at last step I start
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
InnoDB: Starting shutdown...
120116 19:15:30 InnoDB: Shutdown completed; log sequence number 1595675
120116 19:15:30 [Note]
120116 19:15:30 mysqld_safe mysqld from pid file /var/lib/mysql/Pig.pid
ended
every step I followed the INSTALL_BINARY file
why it still can't start?
who can help
Am 30.11.2011 03:13, schrieb Karen Abgarian:
The concept is not difficult to explain. Most people do not expect a gas
tank
to shrink once the gas is consumed...right?
yes, but the hard-disk is the gas tank and the data are the gas
and yes, normally everybody would expect after deleting
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
Am 30.11.2011 07:02, schrieb Hal?sz S?ndor:
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
of df -h was correct. However,
when I try to restart mysql it outputs the following errors in the error
log; it is in the attached file.
Thanks for anyone that could help.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
29 12:51
Am 29.11.2011 14:08, schrieb Luis Pugoy:
Hello. I have the following problem.
I was importing a large database to mysql using mysqldump. Unfortunately this
filled up the whole disk, and
mysqldump exited with an error that the table it is currently writing to is
full. Checking df -h it
201 - 300 of 7035 matches
Mail list logo
