Re: mysql query for current date accounting returns NULL

2016-03-26 Thread shawn l.green
On 3/26/2016 4:36 PM, shawn l.green wrote: On 3/25/2016 6:39 AM, JAHANZAIB SYED wrote: I have Freeradius 2.x with MySQL 5.5 in Ubuntu. I want to query user quota for current date. I am using following code SELECT (SUM(acctinputoctets)+SUM(acctoutputoctets)) AS Total FROM radacct where

Re: mysql query for current date accounting returns NULL

2016-03-26 Thread shawn l.green
On 3/25/2016 6:39 AM, JAHANZAIB SYED wrote: I have Freeradius 2.x with MySQL 5.5 in Ubuntu. I want to query user quota for current date. I am using following code SELECT (SUM(acctinputoctets)+SUM(acctoutputoctets)) AS Total FROM radacct where (acctstarttime between

Re: mysql query for current date accounting returns NULL

2016-03-25 Thread Hal.sz S.ndor
2016/03/25 06:39 ... JAHANZAIB SYED: I want to query user quota for current date. I am using following code SELECT SUM(acctinputoctets)+SUM(acctoutputoctets) AS Total FROM radacct where (acctstarttime between DATE_FORMAT(NOW(),'%Y-%m-%d') AND NOW() AND acctstoptime between DATE_FORMAT(NOW()

mysql query for current date accounting returns NULL

2016-03-25 Thread JAHANZAIB SYED
I have Freeradius 2.x with MySQL 5.5 in Ubuntu. I want to query user quota for current date. I am using following code SELECT (SUM(acctinputoctets)+SUM(acctoutputoctets)) AS Total FROM radacct where (acctstarttime between DATE_FORMAT(NOW(),'%Y-%m-%d') AND NOW() AND acctstoptime between

Re: Decode Json in MySQL query

2014-03-21 Thread Sukhjinder K. Narula
Many Thanks for the kind replies. I have decoded in my code but just wondering in case I missed any solution to decode via query. On Thu, Mar 20, 2014 at 3:05 PM, Michael Dykman mdyk...@gmail.com wrote: Short answer, no. There is nothing in MySQL to facilitate this. In general, storing

Re: Decode Json in MySQL query

2014-03-21 Thread Andrew Moore
May also be of interest; http://www.slideshare.net/blueskarlsson/using-json-with-mariadb-and-mysql On Fri, Mar 21, 2014 at 12:27 PM, Sukhjinder K. Narula narula...@gmail.comwrote: Many Thanks for the kind replies. I have decoded in my code but just wondering in case I missed any solution

Decode Json in MySQL query

2014-03-20 Thread Sukhjinder K. Narula
Hello, I would like to know if there is a way to decode the json string stored in one of the fields as text without using triggers or stored procedures. What I want to do is is within the query, I would like to get one row per element within the json string. For example: the json string is as

Re: Decode Json in MySQL query

2014-03-20 Thread Karr Abgarian
Hi, you probably want to perform this conversion on your client. There are JSON parser libraries available for Java, PHP and the like. Cheers, Karr On Mar 20, 2014, at 11:35 AM, Sukhjinder K. Narula narula...@gmail.com wrote: Hello, I would like to know if there is a way to decode the

Re: Decode Json in MySQL query

2014-03-20 Thread Kishore Vaishnav
Hi, http://blog.ulf-wendel.de/2013/mysql-5-7-sql-functions-for-json-udf/ This is not the exact solution for you query, but might help you better if you add the libraries. *thanks,* *-- *Kishore Kumar Vaishnav On Thu, Mar 20, 2014 at 11:35 AM, Sukhjinder K. Narula narula...@gmail.comwrote:

Re: Decode Json in MySQL query

2014-03-20 Thread Michael Dykman
Short answer, no. There is nothing in MySQL to facilitate this. In general, storing structured data as a blob (JSON, CSV, XML-fragment, etc..) is an anti-pattern in a relational environment. There are NoSQL solutions that provide the facility: Mongo comes to mind; there are some others, I am

mySQL Query support/assistance...

2014-02-11 Thread Don Wieland
Hi gang, I am looking for someone that I can pay a few hours to work with me on coming up with a few needed QUERIES for a large mysql database. The queries will span across tables, so I great knowledge of JOINS will most likely be necessary. We will work using SKYPE and GoToMeeting. Please

mySQL Query and Report Builder

2012-04-30 Thread Don Wieland
Hello, I have a client who needs the ability to do statistical reporting on their mySQL db data. Is there an app that provides an easy UI that will allow my client to build a line item query, specify fields to be include in the result of the query, and then design the way the data will

Re: mySQL Query and Report Builder

2012-04-30 Thread Carsten Pedersen
On 30.04.2012 18:53, Don Wieland wrote: Hello, I have a client who needs the ability to do statistical reporting on their mySQL db data. Is there an app that provides an easy UI that will allow my client to build a line item query, specify fields to be include in the result of the query, and

Re: mySQL Query and Report Builder

2012-04-30 Thread Nuno Tavares
Hi Don, Have a look at Jasper Reports: http://jasperforge.org/ -NT Em 30-04-2012 17:53, Don Wieland escreveu: Hello, I have a client who needs the ability to do statistical reporting on their mySQL db data. Is there an app that provides an easy UI that will allow my client to build a line

running a mysql query inside a loop of another without a sync error

2011-01-19 Thread Delan Azabani
Hi all, I'm using MySQL with C in a CGI application. I hope this is the right list to ask for help. If I have this simplified code: MYSQL_RES *res; MYSQL_ROW row; mysql_query(mysql, some select query); res = mysql_use_result(mysql); while (row = mysql_fetch_row(res)) { MYSQL_RES *res2;

Re: running a mysql query inside a loop of another without a sync error

2011-01-19 Thread Shawn Green (MySQL)
Hello Delan, On 1/19/2011 21:54, Delan Azabani wrote: Hi all, I'm using MySQL with C in a CGI application. I hope this is the right list to ask for help. If I have this simplified code: MYSQL_RES *res; MYSQL_ROW row; mysql_query(mysql, some select query); res = mysql_use_result(mysql); while

Re: running a mysql query inside a loop of another without a sync error

2011-01-19 Thread Michael Dykman
From 1 feet, what you are attempting to do looks like it would be very easily accomplished with a join, leaving you with 1 result set to process. I realize that isn't the question, but it might be a solution. - michael dykman On Wed, Jan 19, 2011 at 9:54 PM, Delan Azabani de...@azabani.com

Re: [PHP] mySQL query assistance...

2010-11-29 Thread Daniel P. Brown
On Mon, Nov 29, 2010 at 14:35, Don Wieland d...@dwdataconcepts.com wrote: Hi all, Is there a list/form to get some help on compiling mySQL queries? I am executing them via PHP, but do not want to ask for help here if it is no the appropriate forum. Thanks ;-) Yes. For MySQL queries,

Re: [PHP] mySQL query assistance...

2010-11-29 Thread Wagner Bianchi
This is the general list. If your problem is with MySQL and queries, let us know. Best regards. -- WB 2010/11/29 Daniel P. Brown daniel.br...@parasane.net On Mon, Nov 29, 2010 at 14:35, Don Wieland d...@dwdataconcepts.com wrote: Hi all, Is there a list/form to get some help on

About mysql query time-out

2010-06-18 Thread guyson
Hello,everyone,here is my question: Q1--- in this function (mysql_options() ),the desc of MYSQL_OPT_READ_TIMEOUT in the Reference Manual 5.0 is as follows:The timeout in seconds for attempts to read from the serverMy question is how should I understand this word read,does it means access

mysql query takes too much time to run

2010-01-13 Thread F.A.I.Z.A.L
hi can anybody help me to check this query is written in good way select ATX_Status.Server as `Server`, ATX_Status.Load as `Load`,ATX_Status.System as `System`, atx.ATX_Status.Timestamp as `TimeStamp`, `Coverage`, atx.ATX_Summary.Testware as `View`, `Traffic`, ATX_Status.Status as `Status`,

Re: mysql query takes too much time to run

2010-01-13 Thread Claudio Nanni
Sac, this is like saying I have a pain, what can it be? Attach more info if you hope in some help, at least the explain plan. Cheers Claudio 2010/1/13 F.A.I.Z.A.L sac.fai...@gmail.com hi can anybody help me to check this query is written in good way select ATX_Status.Server as `Server`,

Re: mysql query takes too much time to run

2010-01-13 Thread mos
At 07:00 AM 1/13/2010, F.A.I.Z.A.L wrote: where ( ATX_Status.Status like '%running%' or ATX_Status.Status like '%queued%' or ATX_Status.Status like '%migrating%' or ATX_Status.Status like '%loading%' or ATX_Status.Status like '%configuring%' or ATX_Status.Status like '%activating%' ) It looks

VFP to MySQL Query Optimization

2009-10-20 Thread Matt Neimeyer
I feel like there should be a better way to do this... So I'm hoping someone will be able to advise. We have contacts that belong to organizations. We also have a document tracker. Holding over from VFP you can have up to six organization ids on the document and up to six contact ids. Right now

MySQL query working directly but not through .NET connection

2009-07-25 Thread John Meyer
Here's the query: INSERT INTO USERS(USER_ID,USER_NAME,USER_SCREENNAME,USER_DESCRIPTION,USER_FOLLOWERS,USER_IMAGE,USER_FRIENDS,USER_LOCATION,USER_CREATEDAT) VALUES('31264066','Justin Wienkers','BabyVegaz','I’m your secondhand news/yeah. That and an (aspiring) screenwriter, trained journalist,

Re: Help with mysql query, multiple list

2009-05-10 Thread Scott Haneda
What about sub selects. As I see it you only care about the highest and lowest order of results in each list. Sorry, in am on a mobile so I can nit make a test case, and this will be pseudo SQL. Select * from table where start = (select foo) and ( select foo) ... Also look at the between

Re: Help with mysql query, multiple list

2009-05-09 Thread Simon J Mudd
abhishek@gmail.com (Abhishek Pratap) writes: I am kind of stuck with this query , cant expand my thinking. May this is a limitation. Here it is I have a database with many cols two of which are start and end position for an event. Now I have a list of event time stamps, I want to

Help with mysql query, multiple list

2009-05-08 Thread Abhishek Pratap
Hi All I am kind of stuck with this query , cant expand my thinking. May this is a limitation. Here it is I have a database with many cols two of which are start and end position for an event. Now I have a list of event time stamps, I want to find all the info once the current event time

Re: Help with mysql query, multiple list

2009-05-08 Thread Abhishek Pratap
aah okie I think I was trying to get too clever. Guess that won't work ... Thanks, -Abhi On Fri, May 8, 2009 at 12:34 PM, Barney Boisvert bboisv...@gmail.comwrote: You'll have to iterate over your two lists of timestamps and build a set of ORed conditional pairs: sql = select ... from ...

Re: Help with mysql query, multiple list

2009-05-08 Thread Jim Lyons
why not something like below. Assume you have 3 pairs of start/end timestamps and you want to find everything within those 3 time periods: select * from table_name where start = start1 and end = end1 union select * from table_name where start = start2 and end = end2 union select * from

Re: Help with mysql query, multiple list

2009-05-08 Thread Abhishek Pratap
Hi Jim Unfortunately I have thousands of such points. So explicit statement calling will be very expensive both computationally and in terms of writing.. Thanks, -Abhi On Fri, May 8, 2009 at 12:37 PM, Jim Lyons jlyons4...@gmail.com wrote: why not something like below. Assume you have 3 pairs

Re: Help with mysql query, multiple list

2009-05-08 Thread Kyong Kim
Abhi, I might not be understanding the problem but could you use the max and min timestamp values and use something like SELECT * FROM TABLE WHERE start BETWEEN max AND min AND end BETWEEN max AND min or SELECT * FROM TABLE WHERE START IN (1,2,3,4,5) AND END IN(1,2,3,4,5) I might be

Re: Help with mysql query, multiple list

2009-05-08 Thread Jim Lyons
then either build the statement by way of a program like a perl script or select all records with a start time after the min start time of all in your list and an end time less than the max end time in your list then filter them further either in a program or a store procedure. On Fri, May 8,

Re: How to disable some of the mysql query?

2008-11-29 Thread Chandru
Hi wayne, If you dont want any query with select * from table by mistake then you can start the mysql by using the command --safe-updates or --i-am-a-dummy this does not allow queries to be executed if they dont have any where clause. Regards, Chandru www.mafiree.com On Fri, Nov 28, 2008 at

Re: How to disable some of the mysql query?

2008-11-28 Thread Steve Edberg
At 1:07 AM +0800 11/29/08, Wayne wrote: for example,one user has the 'select' right on talbe 'test'(innodb,million records),however,he sometimes execute query like 'select * from test'.That will slow down the whole database. Is there a way to disable some queries for some users? Or,mysql's

Fw: mysql query, min, max with where conditions

2008-06-10 Thread William Newton
(IF(date100, q, -1)) as min_q, from a left join b left join c group by a.p - Original Message From: CRISTEA, Adrian [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, June 9, 2008 9:33:37 AM Subject: mysql query, min, max with where conditions Hello there, What is the corect syntax

mysql query, min, max with where conditions

2008-06-09 Thread CRISTEA, Adrian
Hello there, What is the corect syntax for selecting something like: select a, b, (min(q) where date100), (max(q) where date100) from a left join b left join c group by a.p i need min() max() values each of them with other WHERE clause. How can I do that? Adrian. -- MySQL General Mailing

Re: mysql query, min, max with where conditions

2008-06-09 Thread Sebastian Mendel
CRISTEA, Adrian schrieb: Hello there, What is the corect syntax for selecting something like: select a, b, (min(q) where date100), (max(q) where date100) from a left join b left join c group by a.p i need min() max() values each of them with other WHERE clause. How can I do that? sub

Help with MySQL Query (2 Outer joins)

2008-01-23 Thread Raghuveer Rawat
Hi, I need some urgent for sql query.. It will be great if someone could help me.. I have ARTICLE, FAVORITE_ARTICLES, RATING Tables apart from other table USER, CHANNEL, CATEGORY etc ARTICLE table stores a user's article, FAVORITE_ARTICLES will store a user's favorite articles, and rating

Bash script array from MySQL query - HELP Please!!!

2007-05-22 Thread Ben Benson
I'm having problems getting a monitoring script to run. I've put the troublesome bit in a separate script just to test, and it goes like this: declare -a HNdeclares the array HN HN=(`echo SELECT url FROM hosts | mysql --user=netmon --password=n3tm0n --skip-column-names

Re: Bash script array from MySQL query - HELP Please!!!

2007-05-22 Thread BJ Swope
I would look at the 15th URL to see if there are specials in there that are breaking the hash somehow. On 5/22/07, Ben Benson [EMAIL PROTECTED] wrote: I'm having problems getting a monitoring script to run. I've put the troublesome bit in a separate script just to test, and it goes like

mysql query question (images,tags)

2006-11-09 Thread Jens Kleikamp
hi to all, I have a simple question/szenario. Here are my tables: 1. image (id, name) 2. tag (id, name) 3. images_tags (image_id, tag_id) At the moment I have the following working query, it selects all images which have *at least one of the tag ids* (25,30) assigned. SELECT DISTINCT

Re: mysql query question (images,tags)

2006-11-09 Thread Jens Kleikamp
Jens Kleikamp schrieb: hi to all, I have a simple question/szenario. Here are my tables: 1. image (id, name) 2. tag (id, name) 3. images_tags (image_id, tag_id) At the moment I have the following working query, it selects all images which have *at least one of the tag ids* (25,30) assigned.

mysqlcc / mysql query browser

2006-08-18 Thread Pooly
Hi, MysqlCC not being in developement anymore and not working properly with a server 5.0, we are trying to use MySQL Query browser, but there are few things which are less than efficient compared to mysqlCC. - you can't execute several queries ! The query tab executes them one by one

Re: mysqlcc / mysql query browser

2006-08-18 Thread Steve Musumeche
in developement anymore and not working properly with a server 5.0, we are trying to use MySQL Query browser, but there are few things which are less than efficient compared to mysqlCC. - you can't execute several queries ! The query tab executes them one by one, and if you use a script tab, you

MYSQL Query Browser 1.1.20 problem

2006-06-10 Thread Nenad Bosanac
Hi all I have problem in MYSQL query browser tool. I make a two tables ,one have primary key, and in second table i put reference to first table. I make all this in Query browser and set foreign key of second table to on delete no action. I apply changes but next time when i want to edit second

Find invalid email formats using MySQL query.

2006-05-20 Thread Yesmin Patwary
Dear All, My contact table has email field which contains many invalid email addresses. I find them using following php function. Is there a way to do that check in MySQL query? function emailValidate ($str) { $reg = ^([a-zA-Z0-9._-]+)@([a-zA-Z0-9-])+(\.[a-zA-Z0-9

Re: Find invalid email formats using MySQL query.

2006-05-20 Thread Keith Roberts
From: Yesmin Patwary [EMAIL PROTECTED] Subject: Find invalid email formats using MySQL query. Dear All, My contact table has email field which contains many invalid email addresses. I find them using following php function. Is there a way to do that check in MySQL query

Re: Find invalid email formats using MySQL query.

2006-05-20 Thread Peter Brawley
Yesmin Patwary wrote: Dear All, My contact table has email field which contains many invalid email addresses. I find them using following php function. Is there a way to do that check in MySQL query? function emailValidate ($str) { $reg = "^([a-zA-Z0-9._-]+)@([a-zA

RE: Find invalid email formats using MySQL query.

2006-05-20 Thread fbsd
adding it is the normal way this is done. -Original Message- From: Yesmin Patwary [mailto:[EMAIL PROTECTED] Sent: Saturday, May 20, 2006 10:48 AM To: mysql@lists.mysql.com Subject: Find invalid email formats using MySQL query. Dear All, My contact table has email field which contains many

RE: Find invalid email formats using MySQL query.

2006-05-20 Thread Keith Roberts
, 20 May 2006, fbsd wrote: To: Yesmin Patwary [EMAIL PROTECTED], mysql@lists.mysql.com From: fbsd [EMAIL PROTECTED] Subject: RE: Find invalid email formats using MySQL query. You need to use a stronger edit to check email addresses. This is what I use. Note the dns mx domain name check

RE: Find invalid email formats using MySQL query.

2006-05-20 Thread Chris Sansom
At 22:10 +0100 20/5/06, Keith Roberts wrote: Probably the most efficient place to do this sort of field checking would be using javascript in the browser. That would stop the bad addresses even being sent down the line to the server in the first place. Sure, but if you're being conscientious

Error 1714. The older version of Mysql Query Browser1.1 cannot be removed.

2006-05-05 Thread romyd misc
Hi All, I submitted this query in Mysql Query Browser forum last month and haven't got any help to fix this, so here I'm submitting this again. I tried to install mysql query browser 1.1.20 and previous i had version 1.1.6, but every time i try installing i keep getting the following error

mysql query browser- editing resultsets

2006-04-24 Thread ross
max(price) FROM products); c.. this table must contain a Primary Key column, although not necessarily in the query. If the query does not contain the primary key, it will be automatically added before the MySQL Query Browser sends the query to the MySQL server, but will display only

RE: mysql query browser- editing resultsets

2006-04-24 Thread J.R. Bullington
. J.R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, April 24, 2006 11:14 AM To: mysql@lists.mysql.com Subject: mysql query browser- editing resultsets Can someone explain to me how to edit this...I click on the cells and nothing From the manual

Re: mysql query browser- editing resultsets

2006-04-24 Thread ross
The edit button is 'greyed out' Ross - Original Message - From: J.R. Bullington [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, April 24, 2006 4:20 PM Subject: RE: mysql query browser- editing resultsets There is an EDIT button on the bottom of the Query Browser. You have

RE: mysql query browser- editing resultsets

2006-04-24 Thread J.R. Bullington
it, post your SQL query and your CREATE TABLE statement so that we (the list) can test this out for you. J.R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, April 24, 2006 11:42 AM To: J.R. Bullington; mysql@lists.mysql.com Subject: Re: mysql query

RE: mysql query browser- editing resultsets

2006-04-24 Thread Tim Lucia
@lists.mysql.com Subject: Re: mysql query browser- editing resultsets The edit button is 'greyed out' Ross - Original Message - From: J.R. Bullington [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, April 24, 2006 4:20 PM Subject: RE: mysql query browser- editing resultsets

Re: mysql query browser- editing resultsets

2006-04-24 Thread ross
I think the most likely case is the table is read-only. How do I change this? Ross - Original Message - From: J.R. Bullington [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, April 24, 2006 4:46 PM Subject: RE: mysql query browser- editing resultsets

exporting a mysql database via mysql query browser

2006-04-24 Thread ross
I am a phpmyadmin user and have never really used mysql query browser before. I have a database sitting on my localhost and I want to export the whole thing via mysql query browser to the host. What is the easiest way to do it? Ross

Re: exporting a mysql database via mysql query browser

2006-04-24 Thread 2wsxdr5
[EMAIL PROTECTED] wrote: I am a phpmyadmin user and have never really used mysql query browser before. I have a database sitting on my localhost and I want to export the whole thing via mysql query browser to the host. What is the easiest way to do it? Ross Use the MySQL admin tool

Re: mysql query and version problem .... Help!

2006-03-22 Thread Gregory Machin
, Mark [EMAIL PROTECTED] wrote: -Original Message- From: Gregory Machin [mailto:[EMAIL PROTECTED] Sent: 21 March 2006 11:28 To: mysql@lists.mysql.com Subject: mysql query and version problem Help! Hi. I have just found out that my hosting provider is using mysql 4

Re: mysql query and version problem .... Help!

2006-03-22 Thread Gabriel PREDA
You don't need to drop a TEMPORARY table... it is dropped at connection-close ! You don't need to wory about different names for TEMPORARY tables... Manual says: A TEMPORARY table is visible only to the current connection, and is dropped automatically when the connection is closed. This means

Re: mysql query and version problem .... Help!

2006-03-22 Thread Peter Brawley
created, and vanishes when the connection closes. PB - Gregory Machin wrote: On 3/21/06, Addison, Mark [EMAIL PROTECTED] wrote: -Original Message- From: Gregory Machin [mailto:[EMAIL PROTECTED] Sent: 21 March 2006 11:28 To: mysql@lists.mysql.com Subject: mysql query and version

mysql query and version problem .... Help!

2006-03-21 Thread Gregory Machin
Hi. I have just found out that my hosting provider is using mysql 4 and I'm using mysql 5 the one query I need wont work and is a key feature in the application .. here is the query i'm using SELECT dealer_id, auto_id, bid_amount FROM bids b1 WHERE bid_amount=(SELECT MAX(b2.bid_amount) FROM bids

RE: mysql query and version problem .... Help!

2006-03-21 Thread Addison, Mark
-Original Message- From: Gregory Machin [mailto:[EMAIL PROTECTED] Sent: 21 March 2006 11:28 To: mysql@lists.mysql.com Subject: mysql query and version problem Help! Hi. I have just found out that my hosting provider is using mysql 4 and I'm using mysql 5 the one query I

Re: mysql query and version problem .... Help!

2006-03-21 Thread Gregory Machin
On 3/21/06, Addison, Mark [EMAIL PROTECTED] wrote: -Original Message- From: Gregory Machin [mailto:[EMAIL PROTECTED] Sent: 21 March 2006 11:28 To: mysql@lists.mysql.com Subject: mysql query and version problem Help! Hi. I have just found out that my hosting provider

MySQL Query Browser 1.1.20 problem

2006-03-15 Thread Mojtaba Faridzad
Hi, I installed this version of browser but it's not working properly. For example, I don't see the command window on the top of the browser to type my command. Do you have the same problem? Also I noticed that when I go to mysql.mysql.com to download the commercial version of MySQL, I am

stucked, unkillable mysql query

2006-03-06 Thread Gabor Debreczeni-Kis
hello i have a strange problem. freebsd 6.0 amd64, dual xeon mysql 5.0.18 huge conf, myisam and heap tables. around 1000 query/sec, without any problem in the last 2 week. the problem is: the stuff is running perfectly with a load of 0.8-1.0 it was correct, but 20 hours before something

Re: MySQL query gifted book !!!

2006-02-27 Thread Gabriel PREDA
If you want to find out the content of the CD you should buy the book ! I'm sure it's illegal to make a copy of the CD available online... and also to have a copy without having the book ! With the respect of the content let me tell you that it contains the book itself in PDF and some PDFs with

MySQL query

2006-02-26 Thread Anago Chima
Please does anybody knows the content of the CD that comes with MySQL 5 Certification Study Guide and how relevant it's to passing the exams? Can someone out there provide me with a link to his copy for download? __ Do You Yahoo!? Tired of spam?

mysql query browser

2006-02-13 Thread douglass_davis
I was just running some queries to get an approximate time that they will run, and i saw this in the bottom left corner: 6 rows fetched in 0.0167s (0.4119s) What do the two numbers mean, and why are they so different? I couldn't find this in the help documentation. thanks. --

mysql-query-browser install RPM

2006-02-01 Thread hawat . thufir
Must the RPM be manually downloaded, or can the query browser be installed from yum? I've tried search 'mysql-query-browser' and no result--perhaps I need to add a repository? [EMAIL PROTECTED] ~]$ mysql-query-browser bash: mysql-query-browser: command not found [EMAIL PROTECTED] ~]$ ll

Re: mysql-query-browser install RPM

2006-02-01 Thread Dan Trainor
[EMAIL PROTECTED] wrote: Must the RPM be manually downloaded, or can the query browser be installed from yum? I've tried search 'mysql-query-browser' and no result--perhaps I need to add a repository? [EMAIL PROTECTED] ~]$ mysql-query-browser bash: mysql-query-browser: command not found

Mysql Query Optimization?

2006-01-13 Thread Scott Baker
I have a query that's taking about 0.3 seconds to run and it should be faster I think. I've read all about query optimization and forcing indexes and I'm not entirely sure what I'm having this problem. Google finds all kinds of basic information like using indexes, and not doing math on the query

Re: Mysql Query Optimization?

2006-01-13 Thread Gleb Paharenko
Hello. Please, provide the output of EXPLAIN for your queries. The performance should improved if you make e.CustID and c.CustID the same type (one of them is unsigned). Have you run ANALYZE TABLE on your tables? Scott Baker wrote: I have a query that's taking about 0.3 seconds to run and it

Re: Mysql Query Optimization?

2006-01-13 Thread Scott Baker
It looks like I spoke too soon. That field fix sped up the straight join, but not the more complex query I had, it's still 0.3 seconds. SELECT EmailID, EmailUsername, d.DomainName, e.CustID FROM EmailAddr e, Domain d, CustInfo c WHERE e.CustID = c.CustID AND e.DomainID = d.DomainID AND

Re: Mysql Query Optimization?

2006-01-13 Thread Scott Baker
Ops, forgot to reply to this list Gleb: +---+---+---+-+-+--+--+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra |

MySQL query question

2005-12-24 Thread Josh Mellicker
I have several tables, all with many-to-many joining tables. users users_teams teams teams_projects projects --- So, with a projects.id = 1, I want to get all the usernames of people on teams assigned to that project. SELECT DISTINCT username FROM users, users_teams, teams,

Fw: MySQL query question

2005-12-24 Thread Rhino
Oops, I meant to copy the mailing list on this reply. Rhino - Original Message - From: Rhino [EMAIL PROTECTED] To: Josh Mellicker [EMAIL PROTECTED] Sent: Saturday, December 24, 2005 9:24 AM Subject: Re: MySQL query question - Original Message - From: Josh Mellicker [EMAIL

Re: MySQL query question

2005-12-24 Thread Hank
since I'm not sure how users would ever be directly associated with teams - I would have expected to find players to be associated with teams - so forgive me if this doesn't resemble very much what you're doing: Think corporate projects, not sports. Here's my take on the original query.. you

Re: MySQL query question

2005-12-24 Thread Peter Brawley
Josh, I have several tables, all with many-to-many joining tables. users users_teams teams teams_projects projects Once again explicit join syntax clarifies matters: SELECT DISTINCT username FROM users INNER JOIN users_teams ON (users.id = users_teams.user_id) INNER JOIN teams ON

Re: ~mysql query log~

2005-12-14 Thread abdulazeem
Hi Gleb, Thanks a lot. On Mon, 2005-12-12 at 23:44, Gleb Paharenko wrote: Hello. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/log-file-maintenance.html abdulazeem wrote: Hi, Iam running a mysql server version 5.0.15. My mysql query log is occupying nearly 21 GB

Re: ~mysql query log~

2005-12-12 Thread Gleb Paharenko
Hello. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/log-file-maintenance.html abdulazeem wrote: Hi, Iam running a mysql server version 5.0.15. My mysql query log is occupying nearly 21 GB of disk space. how do i truncate the same ? Thanks in advance, Abdul

~mysql query log~

2005-12-11 Thread abdulazeem
Hi, Iam running a mysql server version 5.0.15. My mysql query log is occupying nearly 21 GB of disk space. how do i truncate the same ? Thanks in advance, Abdul. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: MySql Query Browser 1.1.15 BUG????

2005-10-07 Thread Gleb Paharenko
version, including the bugfix, yourself. More information about accessing the source trees is available at http://www.mysql.com/doc/en/Installing_source_tree.html http://bugs.mysql.com/bug.php?id=13521 Angelo Luis wrote: I download MySql Query Browser 1.1.15 and he is leaving me nervous

MySql Query Browser 1.1.15 BUG????

2005-10-06 Thread Angelo Luis
I download MySql Query Browser 1.1.15 and he is leaving me nervous... This is the problem: 1. I have 2 tabsheet result set. 2. I the first i make a query , like select * from table1. 3. In the second i am in the middle of a query, like select * from table1 where id = (What's is the id ??? Fuck

RE: MySQL Query Browser

2005-09-30 Thread SGreen
Rob Agar [EMAIL PROTECTED] wrote on 09/29/2005 08:27:37 PM: hi Scott How do I run more than 1 queries in MySQL Query Browser? The only way I've found is to put the queries in a .sql file and load it via File Open Script. It doesn't accept multiple typed in queries, even

RE: MySQL Query Browser

2005-09-30 Thread Sujay Koduri
I am not saying MysQL Query Browser is anyway bad or inferior, but as for my experience sqlyog is very good. There is a free version which you can use for executing SQL queries, ofcourse you will be stripped of some advanced features. You can run multiple queries at once using shift+F5. I

Re: MySQL Query Browser

2005-09-30 Thread Pooly
2005/9/30, Sujay Koduri [EMAIL PROTECTED]: I am not saying MysQL Query Browser is anyway bad or inferior, but as for my experience sqlyog is very good. There is a free version which you can use for executing SQL queries, ofcourse you will be stripped of some advanced features. You can run

Re: MySQL Query Browser

2005-09-30 Thread Ed Reed
[EMAIL PROTECTED] : I am not saying MysQL Query Browser is anyway bad or inferior, but as for my experience sqlyog is very good. There is a free version which you can use for executing SQL queries, ofcourse you will be stripped of some advanced features. You can run multiple queries at once

MySQL Query Browser

2005-09-29 Thread Scott Hamm
How do I run more than 1 queries in MySQL Query Browser? -- Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html

RE: MySQL Query Browser

2005-09-29 Thread Rob Agar
hi Scott How do I run more than 1 queries in MySQL Query Browser? The only way I've found is to put the queries in a .sql file and load it via File Open Script. It doesn't accept multiple typed in queries, even if they are separated by semicolons. hth Rob -- MySQL General Mailing List

MySQL Query Browser Inline help

2005-08-08 Thread Scott Hamm
Where can I put in my suggestion (I'm sure others suggested the same) for MySQL Query Browser? Scott -- Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html

Re: MySQL Query Browser Inline help

2005-08-08 Thread Gleb Paharenko
Hello. Probably you want to make a feature request at: http://bugs.mysql.com Where can I put in my suggestion (I'm sure others suggested the same) for MySQL Query Browser? Scott Hamm [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com

Re: MySQL Query Browser Inline help

2005-08-08 Thread SGreen
Scott Hamm [EMAIL PROTECTED] wrote on 08/08/2005 08:11:18 AM: Where can I put in my suggestion (I'm sure others suggested the same) for MySQL Query Browser? Scott ROFLMAO -- you really DON'T check the website before asking the group do you (or read the manual, or check the archives

Re: MySQL Query Browser Inline help

2005-08-08 Thread Scott Hamm
On 8/8/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Scott Hamm [EMAIL PROTECTED] wrote on 08/08/2005 08:11:18 AM: Where can I put in my suggestion (I'm sure others suggested the same) for MySQL Query Browser? Scott ROFLMAO -- you really DON'T check the website before

Re: MySQL Query Browser Inline help

2005-08-08 Thread SGreen
Scott Hamm [EMAIL PROTECTED] wrote on 08/08/2005 11:24:22 AM: On 8/8/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Scott Hamm [EMAIL PROTECTED] wrote on 08/08/2005 08:11:18 AM: Where can I put in my suggestion (I'm sure others suggested the same) for MySQL Query Browser

Re: MySQL Query Browser Inline help

2005-08-08 Thread Scott Hamm
:11:18 AM: Where can I put in my suggestion (I'm sure others suggested the same) for MySQL Query Browser? Scott ROFLMAO -- you really DON'T check the website before asking the group do you (or read the manual, or check the archives, or )? I won't give you

Mysql Query Browser Administrator under Solaris 10

2005-06-09 Thread Kontogiannis Theophanis
smime.p7m Description: S/MIME encrypted message

  1   2   3   >