Hmmm, using distinct email in a query where you want
to count email won't work.
select mail, count(mail) as mailcnt from guest
where voted='yes'
group by mail
order by mailcnt;
should do the trick.
On Tue, April 3, 2007 12:51, Me2resh Lists wrote:
hi
i need help regarding a sql query in my
Hi,
dog
fooID int
size int
id int
dog
fooIDsizeid
1 2 1
2 5 2
1 5 3
if i do a query
select * from dog where fooID='1';
i get
1,2,1
1,5,3
Try,
select * from dog where fooID=1 group by fooID;
- which retrieves the first instance;
SELECT * FROM Dog GROUP BY FooId HAVING FooId = 1;
This should also work.
On 1/5/07, ViSolve DB Team [EMAIL PROTECTED] wrote:
Hi,
dog
fooID int
size int
id int
dog
fooIDsizeid
1 2 1
2 5 2
1 5 3
if i do a query
select * from dog
In the last episode (Jan 03), bruce said:
i've asked something similar before.. but it appears something is going
wrong... so, back to basics...
i have the following test tbl.
dog
fooID int
size int
id int
dog
fooIDsizeid
1 2 1
2 5 2
On Wed, Aug 04, 2004 at 02:46:50PM -0500, rdo mail list address wrote:
Is the MySQL Reference Manual, by Widenius and Axmark (the one to which
there is a link on the Documentation page of the mysql website, for sale by
Barnes and Noble) the same reference manual that you can download?
The
PAUL MENARD [EMAIL PROTECTED] wrote:
I'm having an intermittent problem with a MySQL server that I have running on a
Windows 2000 Advance server systems. This issue occurs every few days depending on
the load of the system.
Here are the details.
MySQL version 3.23.42-nt (I know I
* David M. Gonzalez Salinas
Does anybody knoy what is equivalent stmt in MySQL?
select * from table1 where col1 in (select col1 from table2)
This is called a subselect, and it is explained in the manual:
URL: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
--
Roger
David,
Tuesday, October 08, 2002, 2:01:46 AM, you wrote:
DMGS Does anybody knoy what is equivalent stmt in MySQL? select * from table1
DMGS where col1 in (select col1 from table2)
You can re-write without subselects:
http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
--
For
From my experince this is not possible.
Is there any reason why you can not simply do two inserts following each
other?
INSERT INTO table1(column1) SELECT column1a FROM table2 WHERE [something]
INSERT INTO table1(column2) VALUES(valueFromMemory)
(as if you didnt know that already) =D
There
At 17:16 -0700 9/10/02, Mark S Lowe wrote:
I have to do an insert and need to nest a select inside. I have tons
of documentation on a very simple version of this, however my
requirements are one step beyond that. Here is what I'd like to do
in MySQL:
insert into
table1
(column1, column2)
The optimization is understandable but I'm not sure how much it would
affect it if you did the select outside the insert statment vs inside.
Either way you are selecting the same thing but I dont know which way is
better.
Well just playing around with it for a bit I think I found something.
The
That is a difference in the behavior of
isam and myisam tables.
jason wesley upton wrote:
EXPLANATION:
here's the pertinent piece of my sql create statement:
ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID));
i have used this create statement numerous times without this problem. in the
On Thu, 27 Jun 2002, jason wesley upton wrote:
Date: Thu, 27 Jun 2002 14:05:34 -0500
From: jason wesley upton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MySQL Question involving AUTO INCREMENT and PRIMARY IDs. - sql
EXPLANATION:
here's the pertinent piece of my sql create
Hi Lucia..
1- The answers might/will be depent on what type of installation you are
planning to do. Will you compile source code, or install binaries, or ,
since you said you would be installing on Linux, will you install from RPMs?
2 - Yes , you need to do the installation as root .
3 - There
Hi.
Sorry, but I beg to differ. I think it is not a good idea to recommend
to others to run the MySQL server as root. The manual explicitly
recommends otherwise.
On Mon, Apr 29, 2002 at 10:15:31PM -0600, [EMAIL PROTECTED] wrote:
Questions:
- Do I use root account to install the software?
Questions:
- Do I use root account to install the software?
Yes to compile the source or do an RPM as seen below.
See http://www.mysql.com/doc/L/i/Linux-RPM.html
- What account do I use to create Innodb?
Same - I am guessing here but I do all installs as root then give the needed
permissions to
Hi!
Unfortunately, I get too many e-mails to handle help requests
which are sent directly to me.
If you have purchased MySQL support, you may write to
[EMAIL PROTECTED], and will get an answer quickly. If you
would like to purchase support, please see the Support
section of our web site:
Hi.
On Tue, Nov 20, 2001 at 02:23:31PM +0100, [EMAIL PROTECTED] wrote:
Hei
I asked this question sometime ago but I did not get any answer :-(
I think the problem is that people are not sure what you are referring
to (includes me).
and I can not find any explanation of this in the
I don't know how to remove users other than directly removing them from
mysql.user table
This may be very obvious but being a new mysql admin user how do I do what
you say above, to delete the user from the user table. There doesn't
appear to be any examples of this in the docs.
Jim Chivas wrote:
Greetings:
I saw a reply you sent to a mysql user about setting up new users to
mysql. I am hoping you can clarify some questions for me.
I referenced the url you gave out at the mysql.com/documentation/. It
was suppose to show how to setup users but does not give
: mysql question
On Fri, 2 Nov 2001, Mark Maunder wrote:
Jim Chivas wrote:
snip..
I checked this site and it appears to match other docs I have. There are
still no examples of removing users just revoking grants.
What commands would tell me what users have what rights to what databases
]
Subject: Re: mysql question
On Fri, 2 Nov 2001, Mark Maunder wrote:
Jim Chivas wrote:
snip..
I checked this site and it appears to match other docs I have. There are
still no examples of removing users just revoking grants.
What commands would tell me what users have what rights
This may be very obvious but being a new mysql admin user how do I do what
you say above, to delete the user from the user table. There doesn't
appear to be any examples of this in the docs.
You have a database named mysql. In there, there is a table named
user. It's just a normal table,
I am using phpMyAdmin which is MySQL database to create database. My OS
is
windows 2000.
For example, I have a table City. It generates for me 3 files: City.frm,
City.MYD, City.MYI
My question is how I can connect to this table to do query, insert.by
using Java or Visual basic.
For
I thought about that after I sent it. First I will start with what my OS
is. I am running Redhat 7.1. Kernel version 2.2.16-22(I believe). I used
the i386 release. I did a rebuild of the src.rpm. then installed the rpm. I
tried to set the root password as it told me but it said something like
Have a look at what the error logs say. If that doesn't help, post the
command used and error messages/logs (if relevant) to the list.
- Original Message -
From: MIKE TURNER [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 2:05
Subject: MySQL question
I
may need to double quote the % sign.
trav
On Thu, 5 Jul 2001, Chris M wrote:
I've got a question.
In the otherwise-excellent Paul DuBois book, on page 427 or so it talks
about how you can do this:
GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY dirt;
So I tried something
At 9:20 PM -0600 7/5/01, Chris M wrote:
I've got a question.
In the otherwise-excellent Paul DuBois book, on page 427 or so it talks
about how you can do this:
GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY dirt;
So I tried something similar:
mysql GRANT SELECT ON *.* TO mysql@%
mysql -u username -p
enter your password
use yourdatabase;
create table mytablename(...
(see the manual for proper syntax on creating tables)
- Original Message -
From: Terrell Johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 12:28 PM
: MySQL question
hi--
firstly, I am relatively new to mysql.
I am having a problem getting text I enter into a perl script (for reasons
of parsing and sending to my mysql database) to consistently get entered
into the database.
the perl script takes a mail message and makes the body
hi--
firstly, I am relatively new to mysql.
I am having a problem getting text I enter into a perl script (for reasons
of parsing and sending to my mysql database) to consistently get entered
into the database.
the perl script takes a mail message and makes the body of the message
$body. It
We pay for support here.
In the last two years, I have only needed tor resort to it once, because
the mailing list is very effective.
When I needed to resort to my support contract, it was a real problem
that the list would not have been able to solve. The problem was
resolved
within 24 hours.
I don't know how you define 'minimal' but approximately 100+ emails per day from the
user list and a response time from 5 minutes to 24 hours should be adequate for the
average "small-time real estate company" as you call it. Coming to "What will you guys
answer and not answer", I guess there
select Name,Income,Out,(Income-Out) as Balance from tblname
On Mon, 26 Feb
2001 [EMAIL PROTECTED] wrote:
Dear all,
Sorry to ask question again, or maybe i am just a beginner.
I wanna ask:
If there are 2 records
Name Income Out
Data1 1000 700
Data2
Hi Jason!
Give this a try for the required table you want to produce below...
SELECT Name, Income, Out, (Income - Out) AS Balance
FROM tablename;
Sam.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 26, 2001 1:45 PM
Subject: MySQL
[EMAIL PROTECTED] a crit :
Dear all,
Sorry to ask question again, or maybe i am just a beginner.
I wanna ask:
If there are 2 records
Name Income Out
Data1 1000 700
Data2970500
If i want to have the output:
Name
His balance is a running balance...
Joseph, you will have to keep the running balance in some thing
that you write to get the query.. you can't do a running sum
in SQL directly. You can only use the examples people provided
to get the net per line.
Joseph Bueno wrote:
[EMAIL PROTECTED] a
On Sun, Feb 18, 2001 at 08:24:47PM -0500, J Colleary wrote:
Does MYSQL support the CREATE PROCEDURES command, or have stored
procedures? If so, how do I access them?
Nope.
This is documented in the manual.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
38 matches
Mail list logo