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
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
> sel
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;
resulti
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
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?
>
> Th
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 k
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 technic
* 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
--
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 va
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, co
>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 shoul
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 creat
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
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?
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
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:
h
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 do
> 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 t
Mark Maunder
> Cc: Jim Chivas; [EMAIL PROTECTED]
> 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 r
t: 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 to what datab
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
and tables?
Thanks
Ji
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 g
> 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.
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 it
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
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 some
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 m
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:
;[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 10:26 PM
Subject: RE: 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
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". I
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 i
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
[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:
> Nam
Hi Jason!
Give this a try for the required table you want to produce below...
SELECT Name, Income, Out, (Income - Out) AS Balance
FROM ;
Sam.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 26, 2001 1:45 PM
Subject: MySQL question
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
>
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
D
39 matches
Mail list logo
