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 (acc
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 DATE_FORMAT(NOW(),'%Y-%m-
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() ,
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 ite
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 the
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 l
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
> hi
>
> can anybody help me to check this query is written in good way
>
> select ATX_Status.Server as `Server`, ATX_Status.Load
CRISTEA, Adrian schrieb:
Hello there,
What is the corect syntax for selecting something like:
select
a,
b,
(min(q) where date<100),
(max(q) where date>100)
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 sele
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.
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:
Sent: Monday, April 24, 2006 4:46 PM
Subject: RE: mysql query browser- editing resultsets
Then, as the documenta
@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:
Sent: Monday, April 24, 2006 4:20 PM
Subject: RE: mysql query browser- editing resultsets
it 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
The edit button is 'greyed out'
Ross
- Original Message -
From: "J.R. Bullington" <[EMAIL PROTECTED]>
To:
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.
There is an EDIT button on the bottom of the Query Browser. You have to
"activate" the edit feature by clicking on this. You will see that it
remains highlighted.
To edit your cells, double click on them. When finished, hit APPLY CHANGES
at the bottom. If you do not apply them, they will not commi
Gregory
>I thought about that but I'm worried about the users getting the rite data
>if multiple users make the same requests at the same time ... i supose the
>easiest would be to name the temp tables after the user making the request
>??
A temp table is visible only in the thread where it's be
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 mean
It's working ok ..
But I have one problem ..
I'm getting the following error "Table 'max_bids3' already exists";
but I get the following ...
mysql> DROP TABLE max_bids3;
ERROR 1051 (42S02): Unknown table 'max_bids3'
What do I do to fix this, and how can I see the temp tables ?
On 3/21/06, Addis
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
> -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 o
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 ex
[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
[
Ops, forgot to reply to this list
Gleb:
+---+---+---+-+-+--+--+-+
| table | type | possible_keys | key | key_len | ref |
rows | Extra |
+---+---+---+-+-+--+--+--
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
(EmailUsern
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 s
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
>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.. y
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
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,
> Ab
Hello.
Thank you for your bug report. See:
http://bugs.mysql.com/bug.php?id=13521
This issue has been committed to our source repository of that product
and will be incorporated into the next release.
If necessary, you can access the source repository and build the latest
available ve
ctly
edit your dataset (and not do the annoying : "edit"+ do your stuff +
"apply changes" of MysqlQuery Browser )
> sujay
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 30, 2005 7:14 PM
> To: Rob Aga
annoying : "edit"+ do your stuff +
"apply changes" of MysqlQuery Browser )
> sujay
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 30, 2005 7:14 PM
> To: Rob Agar
> Cc: 'Mysql '
> Subjec
suggest you to try
this out once.
sujay
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, September 30, 2005 7:14 PM
To: Rob Agar
Cc: 'Mysql '
Subject: RE: MySQL Query Browser
"Rob Agar" <[EMAIL PROTECTED]> wrote on 09/29/200
"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 if
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
Shawn,
Apology accepted. :) No hard feeling.
Scott
On 8/8/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
>
> 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]> wro
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 Brows
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 che
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 archi
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
Hello.
In my opinion, your status variables are not so bad-looking. About a
half of your queries are taken from the cache and the
Key_reads/Key_read_requests
ratio is less than 1%. Check that the system doesn't start swapping
with high value of Query Cache size. If you run lots of queries w
Hello.
>libtiff.so.3: cannot open shared object file: No such file or
>directory
I think, you should get the version of library which mysql-query-browser
wants.
Billy Pilgrim <[EMAIL PROTECTED]> wrote:
> Hello, I am trying to run mysql query browser on debian, but...
>
> # ./mysql-
YOu could try the free version of SQLyog. It works on
my Win98.
www.webyog.com
Karam
--- Chris <[EMAIL PROTECTED]> wrote:
> Hassan Shaikh wrote:
>
> > The MySQL Query Browser online documentation
> clearly mentions that it
> > runs on 32-bit Windows operating systems,
> including Windows 95, 9
Hassan Shaikh wrote:
The MySQL Query Browser online documentation clearly mentions that it
runs on 32-bit Windows operating systems, including Windows 95, 98 and
Me. However, while installing it on WinME, I get the following error:
"The Operating System is not adequate for running MySQL Query Br
Hello.
I don't think that a lot of people can answer on your question.
Windows ME is rarely found to be an OS for MySQL users.
You may report a bug at bugs.mysql.com.
Hassan Shaikh <[EMAIL PROTECTED]> wrote:
> The MySQL Query Browser online documentation clearly mentions that it
> runs on 32-
Spenser wrote:
I just tried installing it on my RedHat Linux 8 laptop and it complained
about libXcursor.so. This is the message:
error while loading shared libraries: libXcursor.so.1: cannot open
shared object file: No such file or directory
I downloaded the full tar ball version. I'm using the
I just tried installing it on my RedHat Linux 8 laptop and it complained
about libXcursor.so. This is the message:
error while loading shared libraries: libXcursor.so.1: cannot open
shared object file: No such file or directory
I downloaded the full tar ball version. I'm using the Gnome 2 deskt
[EMAIL PROTECTED] wrote:
Dear list.
I´m trying to work with Mysql-Query Browser Application. So, I
installed it following the manual instructions but when I try to run
it cannot be launched.
Into the ./mysql-query-browser/bin directory I type
mysql-query-browser and I receive this error messag
Haitao Jiang <[EMAIL PROTECTED]> wrote:
> We want to test our MYSQL (4.1.4g) server's query performance, and I
> just wondering if there is a tool that enable us sending a list of
> queries over HTTP or JDBC repeatedly and gather/display the
> statistics?
Honetsly, it's almost always better to wr
Hi Haitao.
I'm in the process of developing one of these for the company I work for.
Feel Free to drop me a line and we'll see how we can get it going for you.
Regards
Ian
Haitao Jiang wrote:
Hi,
We want to test our MYSQL (4.1.4g) server's query performance, and I
just wondering if there is a tool
"Jens Bierkandt" <[EMAIL PROTECTED]> wrote:
> you might want to try this:
> DBDesigner from FabForce.
This seems to be what I'm looking for. Thank you!
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
4 12:12 AM
To: Egor Egorov
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL query designer for *nix?
Hi,
you might want to try this:
DBDesigner from FabForce.
http://www.fabforce.net/dbdesigner4/
Regards,
Jens
Egor Egorov wrote:
> Hello.
>
> I'm looking for a schema designer / relatio
Hi,
you might want to try this:
DBDesigner from FabForce.
http://www.fabforce.net/dbdesigner4/
Regards,
Jens
Egor Egorov wrote:
Hello.
I'm looking for a schema designer / relations editor which
is GUI, supports MySQL and runs on *nix, either commercial
or freeware.
Can you suggest me something?
Thomas Nyman wrote:
Hi
I found an instruction on the net concerning "Date Arithmetic" and which
seems to be exactly what I need to hel me get going..however there seems
to be either a mistake on my behalf or on the writers behalf.
Can anyone say whats wrong with this query
$query2="UPDATE KK_
Thomas Nyman wrote:
I found an instruction on the net concerning "Date Arithmetic" and which
seems to be exactly what I need to hel me get going..however there seems
to be either a mistake on my behalf or on the writers behalf.
Can anyone say whats wrong with this query
$query2="UPDATE KK_Fatal
toni baker wrote:
How can change the syntax of the query below to a
"LIKE" criteria query?
SELECT ORGANIZATION_ID, ORGANIZATION_NAME,
MATCH (ORGANIZATION_NAME) AGAINST ("houston") AS score FROM ORGANIZATION
WHERE MATCH (ORGANIZATION_NAME) AGAINST ("houston")
ORDER BY score DESC, ORGANIZATION
Chris,
You're almost there!
select * from temp where col2 like concat('%',col1, '%');
Andy
> -Original Message-
> From: Chris A. Mattingly [mailto:[EMAIL PROTECTED]
> Sent: 07 November 2003 17:01
> To: [EMAIL PROTECTED]
> Subject: MySQL query question
>
>
> I've searched around on the li
I think the most difficult ( if not impossible with just using mysql
query) is the part where you apply your logic as to the "most relevant"
keyword.
You need to be able to have a mechanism of telling the query which
keyword is the most relevant, ie, human logic says, the one that matches
the searc
Not sure I understand what you need?
Can you create a dummy output table of what you would like your result
to look like?
At first glance, from reading your question, it sounds like you simply
want this:
select * from ppc_keywords where keywords like "%job%" [group by
keywords] order by bid;
whe
.
-Original Message-
From: Jef S [mailto:[EMAIL PROTECTED]
Sent: July 16, 2003 12:50 PM
To: [EMAIL PROTECTED]
Subject: RE: MySQL query problems
Have you checked the query in an editor to see if they are working? Just
substitute known values in the place of the variables you are using
Have you checked the query in an editor to see if they are working?
Just substitute known values in the place of the variables you are
using.
Jef
> -Original Message-
> From: C. Reeve [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 16, 2003 10:16 AM
> To: [EMAIL PROTECTED]
> Subject: M
How large is the status table? I would recommend trying to reduce the
inital recordset of your largest table with a subquery and then joining
the subquery to the other tables. Could you please show me the full query
with the table
sizes?
Jake Johnson
[EMAIL PROTECTED]
http://www.plutoid.com
On
On 03-Jun-2003 Asif Iqbal wrote:
>
> something like this
>
> ++-+---++++---
> +---+-+
>| id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner
>| Subject | InitialPriority |
> ++--
> Did not work
I wonder ...
> prompt > echo "select * from Tickets limit 1;" | mysql mydb > res
> prompt > cat res
>
> id EffectiveId Queue TypeIssueStatement Resolution
> Owner Subject InitialPriority FinalPriority PriorityStatus
> TimeWorked TimeLeftTol
QL Manager, etc, I think this might be your
best bet.
-Original Message-
From: Keith Stevenson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 11:14 AM
To: 'Asif Iqbal'; Paul DuBois
Cc: [EMAIL PROTECTED]
Subject: RE: mysql query output get wrapped
Asif,
If I underst
Are you using the -S switch to less? Note that it's a capital S, not lower
case. Does the output get properly sent through the less pager (i.e do you have
to page through the results that get selected)? Check the manpage for less on
your machine and find out what the truncate lines option is,
I am on solaris 2.8 sparc. You less works fine if I use \G switch. But I
want (as you explained) list of column names in one line in first row and
the results are thereafter in single rows instead of getting wrapped.
Like I said wish I remebered the swithc for that
On Tue, 3 Jun 2003, Chris Tuck
What platform are you on? If you're on windows you probably won't have less
installed, in which case you'll need to either (a) install it or (b) use a
different pager (not sure what you'll have with windows, you'd have to
independently research it). I'm assuming that what you want is to have t
That works with \G switch , but without the \G switch Istill get it
wrapped
wish I can remeber the switch
On Tue, 3 Jun 2003, Chris Tucker wrote:
> The pager option can be used to accomplish this (if you don't mind having things
> running through, e.g., less). When I need to do this I just do:
The pager option can be used to accomplish this (if you don't mind having things
running through, e.g., less). When I need to do this I just do:
mysql> \P less -S
mysql>
You'll get unwrapped output (the -S option to less tells it to truncate rather
than wrap over-long lines).
You can use anyt
ow if mysql has similar features. I didn't find them in the manual.
Barry
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 12:10 PM
To: Thomas Spahni
Cc: [EMAIL PROTECTED]
Subject: Re: mysql query output get wrapped
Did not work
prompt &
this Helps
Kind Regards
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 4:57 PM
To: Paul DuBois
Cc: [EMAIL PROTECTED]
Subject: Re: mysql query output get wrapped
something like this
At 11:57 -0400 6/3/03, Asif Iqbal wrote:
something like this
++-+---++++---+---+-+
| id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner
| Subject | InitialPriority |
++---
TECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, June 03, 2003 10:57 AM
> Subject: Re: mysql query output get wrapped
>
>
> >
> > something like this
> >
> >
> ++-+---++++---+-
&g
Did not work
prompt > echo "select * from Tickets limit 1;" | mysql mydb > res
prompt > cat res
id EffectiveId Queue TypeIssueStatement Resolution
Owner Subject InitialPriority FinalPriority PriorityStatus
TimeWorked TimeLeftToldStarts Started Due
write.
*
- Original Message -
From: "Asif Iqbal" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 03, 2003 10:57 AM
Subject: Re: mysql query output
Asif,
try this:
prompt> echo "select * from Tickets limit 1;" | mysql mydb > result.file
You get everything in ONE line.
Cheers,
Thomas
On Tue, 3 Jun 2003, Asif Iqbal wrote:
>
> mysql> select * from Tickets limit 1;
> ++-+---++++---+
something like this
++-+---++++---+---+-+
| id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner
| Subject | InitialPriority |
++-+---+++---
At 11:39 -0400 6/3/03, Asif Iqbal wrote:
I want the columns unwrapped to make it easy to read. Sorry if I confused
you earlier
I still don't know what you mean. What would this output *look like*?
Please show an example.
On Tue, 3 Jun 2003, Paul DuBois wrote:
At 11:27 -0400 6/3/03, Asif Iqbal
mysql> select * from Tickets limit 1 \g
++-+---++++---+---+-+---+--+--++--+-++-+-+--+-
I want the columns unwrapped to make it easy to read. Sorry if I confused
you earlier
On Tue, 3 Jun 2003, Paul DuBois wrote:
> At 11:27 -0400 6/3/03, Asif Iqbal wrote:
> >mysql> select * from Tickets limit 1;
> >++-+---++++---+
Try -E option or put "\g" in end of your sql statement like below
Mysql -u -p -E -e "show innodb status"
OR
Mysql -u -p -e "show innodb status \g"
I am not sure it is little "g" or capital "G". Try both way.
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Tuesda
At 11:27 -0400 6/3/03, Asif Iqbal wrote:
mysql> select * from Tickets limit 1;
++-+---++++---+---+-+---+--+--++--+-++-+
At 2:40 -0800 12/28/02, Arun Kumar wrote:
But if I have varchar fields won't the size of the
record vary based on the actual contents in the
varchar fields.
Arun
Of course. My answer remains the same. Perhaps I should
add that what all this means is that you must perform
the calculations on a
On Saturday 28 December 2002 12:40, Arun Kumar wrote:
> But if I have varchar fields won't the size of the
> record vary based on the actual contents in the
> varchar fields.
Use LENGTH() function:
http://www.mysql.com/doc/en/String_functions.html
and plus one byte.
--
For technical
But if I have varchar fields won't the size of the
record vary based on the actual contents in the
varchar fields.
Arun
--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 18:38 -0800 12/27/02, Arun Kumar wrote:
> >Dear All,
> > I have a table 'X', I want to display the record
> > in this table 'X
At 18:38 -0800 12/27/02, Arun Kumar wrote:
Dear All,
I have a table 'X', I want to display the record
in this table 'X' which has occupied the maximum
number of bytes, i.e i want a query/queries to
display the record with maximum size. I would also
like to print the
record size as well.
Any
In the last episode (Nov 21), ck nuke said:
> I have a problem about : mysql query
> I need help for this.
> Sever: mysql Version: 4.0.4-bata
> SELECT p.pid, p.dateline, t.tid, t.replies FROM cdb_threads t,
> cdb_posts p WHERE p.tid=t.tid AND t.fid='24' ORDER BY p.dateline DESC LIMIT
> 0,1
Hi Jed,
Though this works,when I tried to insert an inner query in that,it is
giving an error in syntax.Can u please help me in thi matter?I gave the
query as follows:
select TO_DAYS(CURDATE()) - TO_DAYS(select dates from userregistration
where userid like 'abhilas');
Abhilas
Hello, Abhilash,
If you just want the number of days between two dates, you don't need
FROM_DAYS. FROM_DAYS gives you a date. This should be all you need:
Select TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30');
HTH,
Jed
On the threshold of genius, [EMAIL PROTECTED] wrote:
> Hi,
> My intention is
* Wilbert Enserink
> I have to tables A and B.
> They boyh have a column with the same name.
>
> Now, I wrote this MySQL statement performing a left join.
> This results in a data set with rows consisting of 2 columns of the same
> name, in which the date is stored when the record was last alter
>Does anybody know if there is a function to retrieve the next unique ID
>number for a record to be made in the future?
I believe you can reliably allocate sequence numbers from a "sequence
table" (a table used only to dole out sequence numbers) like this:
create table sequence ( seq int not nul
W.,
Monday, July 01, 2002, 5:29:41 PM, you wrote:
WE> Does anybody know if there is a function to retrieve the next unique ID
WE> number for a record to be made in the future?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by En
On Monday 01 July 2002 10:29, W. Enserink wrote:
> Hi all,
You would just do something like
SELECT max(idcolumn)+1 as nextvalue FROM tablename
where idcolumn is the name of the column and tablename is the name of your
table, but remember that you may need to serialize this, since probably the
Try this query:
SELECT
yourcolumn+1
FROM yourtable
ORDER BY id desc
LIMIT 1;
greetings,
richard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
[snip]
So if the end result is to have the records selected appended to the
Customer_Equipment table, I have to make a temporary table based on the
characteristics of the Customer_Equipment table... then insert from that
temporary table. Correct?
[/snip]
BINGO! Goofy rules can be frustrating
Greetings Jay:
RE: mySQL query help please
I love rules that don't make sense ;-)
So if the end result is to have the records selected appended to the
Customer_Equipment table, I have to make a temporary table based on the
characteristics of the Customer_Equipment table... then insert
[snip]
INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID,
Configuration, Equipment_Type, Group_ID, Location, Rack_Location,
Network_Status_Name, Creator_ID, Primary_IP_Address FROM
Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) =
Customer.User_ID;
The select statement wor
OOPS sorry
I found the answer by myself
It was just the % symbol that was misplaced
:))
-Message d'origine-
De : Alexandre Zglav [mailto:[EMAIL PROTECTED]]
Envoyé : dimanche, 23. juin 2002 23:09
À : [EMAIL PROTECTED]
Objet : RE: MySQL Query using ASP
-Message d'origi
-Message d'origine-
De : Alexandre Zglav [mailto:[EMAIL PROTECTED]]
Envoyé : dimanche, 23. juin 2002 23:07
À : [EMAIL PROTECTED]
Objet : MySQL Query using ASP
Hi all !
once again thanks for the help you provide me by being so active on this
mailing list :)
I have a litle problem query
Hi Chris,
On Fri, 2002-06-14 at 02:08, Chris Kay wrote:
>
> I have a rather longer query which I would like to get all records past todays date.
>Here is my query
>
> $ttwo = date("YmdGi");
>
>'detail_start_date_y,detail_start_date_m,detail_start_date_d,detail_start_time_h,detail_start_
1 - 100 of 117 matches
Mail list logo
