On Saturday, July 19, 2014 02:56:24 PM Reindl Harald wrote:
> > ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> > that corresponds to your MariaDB server version for the right syntax to
> > use
> > near 'DISTINCT sum) THEN sum(cost) ELSE NULL END AS cost_sum
> > from p
| 5000 |
> | 5 | B| 7000 |
> | 6 | C| NULL |
> ++--+--+
> 6 rows in set (0.00 sec)
>
> I want it to give me data as
>
> name cost
> A 6700
> B 12000
> C NULL
>
> But my query is not working -
>
> Ma
.00 sec)
I want it to give me data as
name cost
A 6700
B 12000
C NULL
But my query is not working -
MariaDB [tutorial]> select name, CASE WHEN ISNULL(DISTINCT sum) THEN sum(cost)
ELSE NULL END AS cost_sum
-> from prices group by name;
ERROR 1064 (42000): Yo
Hi Matthew,
On 16/07/2013 21:21, Matthew Ward wrote:
I've noticed a weird issue in our chained replication environment where when
setting user-defined variables, the first time the variable is used in a
session the value is NULL, but all uses thereafter work correctly.
The first time I run
I've noticed a weird issue in our chained replication environment where when
setting user-defined variables, the first time the variable is used in a
session the value is NULL, but all uses thereafter work correctly.
The environment is such: we have a master (master1), which has a slave which is
est-dr alias, works:
ti-test-dr@hades: mysql -h intradb-test-dr -u tradeinfra -p intradb_test_dr
Welcome to the MySQL monitor. Commands end with ; or \g.
Anyone have any ideas as to why this one is not working? I've been
messing with this for 2 days. Nothing in the error log. I'
-test-dr alias, works:
>
> ti-test-dr@hades: mysql -h intradb-test-dr -u tradeinfra -p
> intradb_test_dr
> Welcome to the MySQL monitor. Commands end with ; or \g.
>
> Anyone have any ideas as to why this one is not working? I've been
> messing with this for 2 da
2012/12/03 19:10 +0530, amit
Problem
mysql> call mobile_series1('(99889988),(12334565)');
You are expecting MySQL to turn one string operand into twain number operands.
That does not happen, unless you use PREPARE, which, I suspect, is not part of
your homework.
--
MySQL Ge
On 2012-12-03 7:40 AM, amit wrote:
Hi Team,
I am not able to use multi value insert via argument in mysql stored
procedure, Please help where am I wrong. Thanks in Advance !
mysql> insert into input_data1 values(),(),(),();
Query OK, 4 rows affected (0.00 sec)
*Problem*
mysql
Hi Joerg,
On Mon, 2010-12-20 at 18:59 +0100, Joerg Bruehe wrote:
> Hi Noel, all!
>
>
> Noel Butler wrote:
> > On Thu, 2010-12-16 at 10:08 -0300, Alejandro Bednarik wrote:
> >> You are right. In previous version init script have a default value, now is
> >> empty.
> >>
> >> mysql 5.1..53 - b
Hi Noel, all!
Noel Butler wrote:
> On Thu, 2010-12-16 at 10:08 -0300, Alejandro Bednarik wrote:
>> You are right. In previous version init script have a default value, now is
>> empty.
>>
>> mysql 5.1..53 - basedir=/usr/local/mysql
>>
>> mysql-5.5.8 - basedir=.
>>
>
>
> /me ponders at wh
2/16/10, Yangontha Maung wrote:
>
> > From: Yangontha Maung
> > Subject: Autostart not working for me in 5.5.8 version
> > To: mysql@lists.mysql.com
> > Date: Thursday, December 16, 2010, 11:14 AM
> > Hi,
> >
> > Please help to set up the autostart of mys
/10, Yangontha Maung wrote:
> From: Yangontha Maung
> Subject: Autostart not working for me in 5.5.8 version
> To: mysql@lists.mysql.com
> Date: Thursday, December 16, 2010, 11:14 AM
> Hi,
>
> Please help to set up the autostart of mysql when the Linux
> server starts.
Hi,
Please help to set up the autostart of mysql when the Linux server starts. It
is not working for me after installing to version 5.5.8.
I have been using different versions of mysql for quite some time with
different servers, Fedora versions. All these are working for autostart. But
for
Thansk,
Will try to turn on log_warnings.
-Mon
From: Nitin Mehta
To: monloi perez ; Ananda Kumar
Cc: mysql mailing list
Sent: Sun, September 5, 2010 12:03:45 PM
Subject: Re: Logs not working
I believe that will not be logged unless you have enabled
From: monloi perez
To: Ananda Kumar
Cc: mysql mailing list
Sent: Sat, September 4, 2010 11:37:42 AM
Subject: Re: Logs not working
on the db server? meaning the mysqld log right? THere is really no data for
teh
current error. The last error they said was too much connections and
list
Sent: Thu, September 2, 2010 6:14:26 PM
Subject: Re: Logs not working
Did u check the logs on the db server, to see what the issue was.
regards
anandkl
On Thu, Sep 2, 2010 at 6:25 AM, monloi perez wrote:
All,
>
>I'm not sure if this is the right mailing list since the speci
On 9/2/2010 3:31 PM, Julien Lory wrote:
Hello,
I've done lot of researches and tests but can't find any answer. I need
to share one table between two db, those two db are in the same path (
/var/lib/mysql/db1 & db2 ). I created symbolic links for db2 pointing to
the table in db1.
When I que
r-5.0 5.0.51a-24+lenny4 MySQL
database server binaries
On 02/09/2010 16:18, Daevid Vincent wrote:
-Original Message-
From: Julien Lory [mailto:julien.l...@gmail.com]
Sent: Thursday, September 02, 2010 12:31 PM
To: mysql@lists.mysql.com
Subject: Symlink
> -Original Message-
> From: Julien Lory [mailto:julien.l...@gmail.com]
> Sent: Thursday, September 02, 2010 12:31 PM
> To: mysql@lists.mysql.com
> Subject: Symlinks not working when pointing to another table.
>
> Hello,
>
> I've done lot of researc
Hello,
I've done lot of researches and tests but can't find any answer. I need
to share one table between two db, those two db are in the same path (
/var/lib/mysql/db1 & db2 ). I created symbolic links for db2 pointing to
the table in db1.
When I query the table from db2 I get this error :
Did u check the logs on the db server, to see what the issue was.
regards
anandkl
On Thu, Sep 2, 2010 at 6:25 AM, monloi perez wrote:
> All,
>
> I'm not sure if this is the right mailing list since the specific mailing
> lists
> doesn't seem to meet my concern.
>
> For some reason mysql client
All,
I'm not sure if this is the right mailing list since the specific mailing lists
doesn't seem to meet my concern.
For some reason mysql client stops logging to mysqd.log. We had an issue on Aug
20. But when I checked the log, the latest was on Aug 2.
Any idea on how to resolve this or what
it is a special character or two
spaces?
Mike
-Ursprüngliche Nachricht-
Von: Ananda Kumar [mailto:anan...@gmail.com]
Bereitgestellt: Mittwoch, 13. Jänner 2010 15:07
Bereitgestellt in: gmane.comp.db.mysql.general
Unterhaltung: Show Tables not working
Betreff: Re: Show Tables not working
i
Tables not working
Betreff: Re: Show Tables not working
Then you possibly aren't using backticks, because I just tested them :-)
On Wed, Jan 13, 2010 at 3:36 PM, Intell! Soft
wrote:
> As I told, Backticks don't work.
> But it is valid to use spaces in DB's because, mySQL Admin
10 15:07
> Bereitgestellt in: gmane.comp.db.mysql.general
> Unterhaltung: Show Tables not working
> Betreff: Re: Show Tables not working
>
> i dont think "my design" is valid.
> There should not be any SPACE for a db name.
>
>
>
>
> On Wed, Jan 13, 2010 at 7:26
>
> > > -Ursprüngliche Nachricht-
> > > Von: Intell! Soft [mailto:intellis...@fachoptiker.net]
> > > Bereitgestellt: Freitag, 08. Jänner 2010 11:06
> > > Bereitgestellt in: gmane.comp.db.mysql.general
> > > Unterhaltung: Show Tables not work
Nachricht-
Von: Ananda Kumar [mailto:anan...@gmail.com]
Bereitgestellt: Mittwoch, 13. Jänner 2010 15:07
Bereitgestellt in: gmane.comp.db.mysql.general
Unterhaltung: Show Tables not working
Betreff: Re: Show Tables not working
i dont think "my design" is valid.
There should not be any
eas?
> >
> >
> >
> >
> > -Ursprüngliche Nachricht-
> > Von: Intell! Soft [mailto:intellis...@fachoptiker.net]
> > Bereitgestellt: Freitag, 08. Jänner 2010 11:06
> > Bereitgestellt in: gmane.comp.db.mysql.general
> > Unterhaltung: Show Tabl
t in: gmane.comp.db.mysql.general
> Unterhaltung: Show Tables not working
> Betreff: Show Tables not working
>
> Hey
>
> I try to use: Show Tables from My Design
> Where "My Design" is the name of the Database. - But it is not working
> Even not with: Show Tables f
Hey
Nobody any ideas?
-Ursprüngliche Nachricht-
Von: Intell! Soft [mailto:intellis...@fachoptiker.net]
Bereitgestellt: Freitag, 08. Jänner 2010 11:06
Bereitgestellt in: gmane.comp.db.mysql.general
Unterhaltung: Show Tables not working
Betreff: Show Tables not working
Hey
I try to
von Baron Schwartz
Gesendet: Montag, 14. Dezember 2009 22:57
An: Lukas C. C. Hempel
Cc: mysql@lists.mysql.com
Betreff: Re: InnoDB Corrupted databases (innodb_force_recovery not working)
Lukas,
If you can't get innodb_force_recovery to work, then you might have to try
to recover the data
Lukas,
If you can't get innodb_force_recovery to work, then you might have to
try to recover the data with these tools:
http://code.google.com/p/innodb-tools/
Regards
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/m
Hey there,
I have recently imported the database files from a crashed server and I am
currently trying to get the new server running with the old data.
However, after starting the MySQL Server, I only get the following error
message:
091214 20:51:46 mysqld started
InnoDB: The user has
On Mon, Oct 19, 2009 at 07:45:11PM -0400, Michael Dykman wrote:
> The type of password instability you are talking about is pretty much
> unheard of in MySQL..
Yeah, well, I can have a real black thumb for this sort of thing :-)
I'm sure I read about at least two different ways to add passwords.
Oct 2009 16:48:36 -0700
> From: listm...@websage.ca
> To: mysql@lists.mysql.com
> Subject: Re: Passwords not working
>
> On Mon, 19 Oct 2009 16:30:47 -0700
> John Oliver wrote:
>
> > I have a problem with MySQL passwords... I set them, write them
> > down
On Mon, 19 Oct 2009 16:30:47 -0700
John Oliver wrote:
> I have a problem with MySQL passwords... I set them, write them
> down... and they stop working. I have to go in and manually reset
> them.
>
> Right now, I have a database that, even after resetting the password,
> I still cannot access i
The type of password instability you are talking about is pretty much
unheard of in MySQL.. however, reverse DNS resolution is always
messing up depending on the network setup. From a console on your
database host, how easily can you resolve the hostnames that your
client is presenting? What is
I have a problem with MySQL passwords... I set them, write them down...
and they stop working. I have to go in and manually reset them.
Right now, I have a database that, even after resetting the password, I
still cannot access it.
/var/log/mysql.log doesn't give me any useful information. How
Exactly, you need as many rows as many combination user/host
we can also say that an account in MySQL is not the username BUT the
username AND host combination.
If you want to duplicate any account (also the root/localhost) do this:
mysql> show grants for 'root'@'localhost';
then have fun!
On Fri, May 15, 2009 at 3:57 PM, Claudio Nanni wrote:
> I don't know if you are now more ore less confused!
>
> Claudio
I would say less because you basically explained that I need to have
localhost & 127.0.0.1.
Now my problem is that no longer have this and would like to know what
I can do to re
It is important to understand deeply mysql client access control.
Basically you need only one root account from the localhost for
administration purposes.
Keep in mind that when you login specifying 'localhost' (either by the
-h flag or implicit) MySQL will use the mysql client socket interface
Can someone please explain why I have 3 entries for root or if this is
normal behavior for MySQL? I thought after a installation of MySQL,
you normally have 2:
1 - localhost
2 - host.domain.com
For some reason I had a 3rd entry:
3 - 127.0.0.1
I don't know if I did the right thing but I ran the
On Thu, May 14, 2009 at 7:01 PM, Douglas Nelson wrote:
> try running the command like this
>
> select * from user where user='root' \G
>
> Capital G is a must.
I did the following:
[r...@mysql ~]# /etc/init.d/mysqld stop
Stopping MySQL:[ OK ]
[r...@
On Thu, May 14, 2009 at 7:06 PM, Carlos Proal wrote:
>
> The machine mysql.unixslut.com is not the same than localhost, right ??,
> If you only need root access from localhost you can delete the first row
> (delete from user where user='root' and host='mysql.unixslut.com';)
Carlos,
Yes, my mach
Carlos Proal wrote:
>
> The machine mysql.unixslut.com is not the same than localhost, right ??,
> If you only need root access from localhost you can delete the first
> row (delete from user where user='root' and host='mysql.unixslut.com';)
>
>
> Carlos
>
>
> On 5/14/2009 5:55 PM, Carlos Williams
The machine mysql.unixslut.com is not the same than localhost, right ??,
If you only need root access from localhost you can delete the first row
(delete from user where user='root' and host='mysql.unixslut.com';)
Carlos
On 5/14/2009 5:55 PM, Carlos Williams wrote:
On Thu, May 14, 2009 at
try running the command like this
select * from user where user='root' \G
Capital G is a must.
thanks Doug
Carlos Williams wrote:
On Thu, May 14, 2009 at 6:44 PM, Carlos Proal wrote:
Check how many root rows do you have on the user table (select * from user
where user='root';), some ti
On Thu, May 14, 2009 at 6:44 PM, Carlos Proal wrote:
>
> Check how many root rows do you have on the user table (select * from user
> where user='root';), some times there are several rows with different grants
> and probably you are going through and invalid rule.
I checked and when I ran the co
Check how many root rows do you have on the user table (select * from
user where user='root';), some times there are several rows with
different grants and probably you are going through and invalid rule.
Carlos
On 5/14/2009 5:39 PM, Carlos Williams wrote:
On Thu, May 14, 2009 at 6:31 PM, C
On Thu, May 14, 2009 at 6:31 PM, Carlos Proal wrote:
>
> Hi Carlos
>
> Try this
>
> mysql> update user set password=password('letmein') where user='root';
>
>
> This way the password is saved encrypted, thats the way is compared when you
> try to log in.
Thanks for the reply! I followed both met
Hi Carlos
Try this
mysql> update user set password=password('letmein') where user='root';
This way the password is saved encrypted, thats the way is compared when
you try to log in.
Carlos
On 5/14/2009 5:28 PM, Carlos Williams wrote:
I noticed today that I strangely was unable to login
I noticed today that I strangely was unable to login to MySQL as root.
I just assumed I forgot the password and decided to reset my root
password:
1 - /etc/init.d/mysqld stop
2 - mysqld_safe --skip-grant-tables &
3 - mysql -u root
4 - mysql> use mysql;
mysql> mysql> update user set password='l
Hi,
I've tried several times now to get a local installation of MySQL
going on my iMac (w/ OS X ver. 10.5.6). I've carefully tried
everything I could comprehend to do per the mysql.com resource pages/
manual. I have also tried several procedures I discovered via Google
searches that see
/var/lib/mysql is the standard loation for the data_file_path, the
data directory. change it in my.cnf.
var/log is the default location for log files, also changeable in the
config file.
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.co
I am trying to install mysql in a non-standard directory - specifically
/app/mysql
Subsequently, I ran the following configure command:
./configure --prefix=/app/mysql --with-plugins=innobase,myisam
There were no problems with the compile, but mysql failed to start.
Furthermore, the following ou
ss denied for user 'testuser'@'myoldserver'
> (using
> |> password: YES)
> |>
> |>
> |>
> |>
> |>
> |>
> |>> On Sat, Oct 25, 2008 at 1:40 PM, Joe Auty <[EMAIL PROTECTED]> wrote:
> |>>
> |>> I'm als
;
>
>
>
>>
>> On Sat, Oct 25, 2008 at 1:40 PM, Joe Auty <[EMAIL PROTECTED]> wrote:
>>
>> I'm also having this strange problem just as stated here, anybody find a
>>> fix for this yet?
>>>
>>> Again, using wildcards (%) for the H
;
>
>
>
>>
>> On Sat, Oct 25, 2008 at 1:40 PM, Joe Auty <[EMAIL PROTECTED]> wrote:
>>
>> I'm also having this strange problem just as stated here, anybody find a
>>> fix for this yet?
>>>
>>> Again, using wildcards (%) for the H
ED]> wrote:
I'm also having this strange problem just as stated here, anybody find a
fix for this yet?
Again, using wildcards (%) for the Host don't work while the FQDN does from
the exact same remote machine, the exact same username, etc. There is
something about the wildcard ACL that
ame, etc. There is
> something about the wildcard ACL that is not working properly for this or
> any other user. I have proper forward and reverse DNS entries for this
> machine I'm connecting from.
>
> Any ideas why this might be and where I ought to look?
>
>
> Yes,
I'm also having this strange problem just as stated here, anybody find a
fix for this yet?
Again, using wildcards (%) for the Host don't work while the FQDN does
from the exact same remote machine, the exact same username, etc. There
is something about the wildcard ACL that is n
Aaron,
> why doesn't this work? the select works perfectly
Define "doesn't work"? What is the error message?
> create view cost_report as
> SELECT c_name, d_manuf as Manufacturer, d_model as Model, count(1) as
> "Number Enrolled",
> d_price as "Monthly Price", count(1)*d_price as "Cost"
> FROM `
why doesn't this work? the select works perfectly
create view cost_report as
SELECT c_name, d_manuf as Manufacturer, d_model as Model, count(1) as
"Number Enrolled",
d_price as "Monthly Price", count(1)*d_price as "Cost"
FROM `b_devices` A
left join b_device_types B
on A.d_id = B.d_id
left join
you not ADD Binary, you need to "remove" BINARY ... ;-)
Sorry, I misunderstood.
convert the string to latin1 or utf8 o.s.s.
"LOWER() (and UPPER()) are ineffective when applied to binary strings
(BINARY, VARBINARY, BLOB). To perform lettercase conversion, convert the
string to a non-binary s
> -Original Message-
> From: Jesse [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2008 1:40 PM
> To: Martijn Tonies; MySQL List
> Subject: Re: Function Still Not Working
>
> > Any difference in default collation?
>
> Not sure what that is. I'm
does it work outside the function?
Yes, If I run:
select CONCAT(UPPER(SUBSTRING('JESSE',1,1)),LOWER(SUBSTRING('JESSE',2)));
replacing cInput with 'JESSE', it returns "Jesse" as it should.
did you tried SUBSTRING(cInput, 2)?
Tried replacing SUBSTRING(cInput FROM 2) with SUBSTRING(cInput, 2)
Any difference in default collation?
Not sure what that is. I'm using a visual tool (EMS) to create my function,
and it doesn't offer that option. I could update it using the command
prompt, however. I may try that later.
--
MySQL General Mailing List
For list archives: http://lists.mys
I am curious about that, as well. It brings to mind a discussion that
happened on this list last week (I believe) about case
sensitive/insensitive use of LIKE. I believe the synopsis was that
tables are either created as case-insensitive, or the search needs to be
specified as case sensitive (with
> -Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2008 6:23 AM
> To: MySQL List
> Subject: Re: Function Still Not Working
>
> Hey,
>
> > Sorry for posting this again, but I got only one response last time,
&g
Jesse schrieb:
Sorry for posting this again, but I got only one response last time, and
I'm still having the problem. I spent HOURS the other day manually
going through the data and Properizing these things by hand. I don't
want to do that again if I can avoid it. If anyone has any clues on
Hey,
> Sorry for posting this again, but I got only one response last time, and
I'm
> still having the problem. I spent HOURS the other day manually going
> through the data and Properizing these things by hand. I don't want to do
> that again if I can avoid it. If anyone has any clues on this o
Sorry for posting this again, but I got only one response last time, and I'm
still having the problem. I spent HOURS the other day manually going
through the data and Properizing these things by hand. I don't want to do
that again if I can avoid it. If anyone has any clues on this one, I would
I have the following function on two servers:
CREATE FUNCTION `ProperCase`(cInput TEXT)
RETURNS text
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
Declare cReturn Text;
Set cReturn = CONCAT(UPPER(SUBSTRING(cInput,1,1)),LOWER(SUBSTRING(cInput
FROM 2)));
RET
Yes, I did "FLUSH PRIVILEGES" and I think I only have one username/host
entry for this user.
Adam
Erik Giberti wrote:
Did you "FLUSH PRIVILEGES"?
I'd also check that the username and passwords are the same for each
host entry, I've had problems if passwords were different for a shared
usern
Did you "FLUSH PRIVILEGES"?
I'd also check that the username and passwords are the same for each
host entry, I've had problems if passwords were different for a shared
username from different hosts.
On Apr 24, 2008, at 8:58 AM, Adam Gerson wrote:
I set up a user and entered % for the host.
I set up a user and entered % for the host. I am not able to connect.
However, if I change the host value to my FQDN it works fine. Shouldn't
the wildcard allow me to connect from any host?
Thanks,
Adam
--
Adam Gerson
Assistant Director of Technology
Apple Certified System Administrator (ACSA
On Dec 13, 2007 12:11 PM, Al <[EMAIL PROTECTED]> wrote:
> (Sorry if this is a duplicate post, email issues w/multiple accts)
>
> I have a MacBook Leopard OS 10.5.1 2 GB RAM. I've got a good amount of
> knowledge of computer systems, but haven't setup or worked with mySQL
> before. (usually use it p
(Sorry if this is a duplicate post, email issues w/multiple accts)
I have a MacBook Leopard OS 10.5.1 2 GB RAM. I've got a good amount of
knowledge of computer systems, but haven't setup or worked with mySQL
before. (usually use it preinstalled on my hosting service). I
downloaded the package and
Hi,
Daevid Vincent wrote:
Is there a way to know how many rows were used in a computation?
I tried this 'trick' but I still get 1, when I know that there are 3 rows
used...
SELECT SQL_CALC_FOUND_ROWS
MAX(DATE_ADD('2007-10-18 18:04:45', INTERVAL user_access_hours
HOUR)),
MAX(access_expire)
Is there a way to know how many rows were used in a computation?
I tried this 'trick' but I still get 1, when I know that there are 3 rows
used...
SELECT SQL_CALC_FOUND_ROWS
MAX(DATE_ADD('2007-10-18 18:04:45', INTERVAL user_access_hours
HOUR)),
MAX(access_expire)
FROM
e
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
We have general logging enabled on our mysql server via a my.cnf
setting. The log records an entry when the server restarts, but does not
record any queries. Is this a bug? or have I missed something.
In my.cnf
[mysqld]
log=query.log
Contents o
*From: VeeJay* <[EMAIL PROTECTED]> To: mysql@lists.mysql.com,
[EMAIL PROTECTED]
Date: Fri, Aug 10, 2007 at 8:19 AM
Hello there
I have a problem. When I try to select some names starting with extra
alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e.,
if I give a select command
in addition to the correct character-set also set the appropriate
collation sequence
suomi
VeeJay wrote:
Hello there
I have a problem. When I try to select some names starting with extra
alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e.,
if I give a select command like:
se
Hello there
I have a problem. When I try to select some names starting with extra
alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e.,
if I give a select command like:
select * from employees where fname LIKE 'Å%';
I get results starting with English alphabet 'A' but not with 'Å'
Using index for group-by: Not working?
Hi,
I have the following query:
SELECT c2, c3, c4, Count(DISTINCT c5)
FROM table1
WHERE c1 IN (1, 2, 3...)
GROUP BY c2, c3, c4
order by null
Yet I can only get it at best to show (under extra): Using where, using
filesort.
I have read up on:
e.
-Original Message-
From: Terry Mehlman [mailto:[EMAIL PROTECTED]
Sent: Sunday, 29 July 2007 1:18 PM
To: Andrew Armstrong
Subject: Re: Using index for group-by: Not working?
just a shot in the dark, but i would suggest two changes to your query.
1) put the count (distinct c5) first
Hi,
I have the following query:
SELECT c2, c3, c4, Count(DISTINCT c5)
FROM table1
WHERE c1 IN (1, 2, 3...)
GROUP BY c2, c3, c4
order by null
Yet I can only get it at best to show (under extra): Using where, using
filesort.
I have read up on:
http://dev.mysql.com/doc/refman/5.0/
[snip]
The stored procedure is in MySQL, but when called using ASP it fails to
return more than the first record.
Anyone?
[/snip]
You need a while loop. Does the SP work from the command line properly?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Would you care to send the source of that procedure plus tell us why
you believe it works when called by something other than C#?
On 5/30/07, Critters <[EMAIL PROTECTED]> wrote:
The stored procedure is in MySQL, but when called using ASP it fails to
return more than the first record.
Anyone?
--
The stored procedure is in MySQL, but when called using ASP it fails to
return more than the first record.
Anyone?
--
Dave
Michael Dykman wrote:
Surely, you don't have legacy stored procedure in ASP under MySQL?
are you sure this is the right list to be asking?
- michael
On 5/30/07, Critters
Surely, you don't have legacy stored procedure in ASP under MySQL?
are you sure this is the right list to be asking?
- michael
On 5/30/07, Critters <[EMAIL PROTECTED]> wrote:
Hi
How do you get multiple record sets from a stored procedure in legacy
ASP? It doesn't seem to work for us.
The quest
Hi
How do you get multiple record sets from a stored procedure in legacy
ASP? It doesn't seem to work for us.
The question is how to return multiple record sets from a single stored
procedure which myodbc doesn't seem to support?
set rs = connection.execute(strSQLsp)
If not rs.EOF then
respons
would you can post the table script?? create and insert...
because it should be work ...
Jason Pruim escreveu:
I have tried %jason%, %jason, & jason% all with the same result... Do
you need to have an index of the column? Currently I didn't
intentionally make one so I'm not sure if it's automat
I have tried %jason%, %jason, & jason% all with the same result... Do
you need to have an index of the column? Currently I didn't
intentionally make one so I'm not sure if it's automatic or not...
On May 25, 2007, at 1:26 PM, Mike Lockhart wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SH
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Have you tried using 'jason%' instead of '%jason%'? Also, do you have
an index on that column?
Jason Pruim wrote:
> Hi all,
>
> I'm new to the list so please excuse me if I make some newbie mistakes,
> I am having trouble figuring out why a select s
Hi all,
I'm new to the list so please excuse me if I make some newbie
mistakes, I am having trouble figuring out why a select statement
won't work, Here's the statement: "SELECT 'FName' FROM `current`
WHERE `FName` like '%jason%';".
if I run select 'FName' FROM current; then I get 6 rows
I knew it was an option somewhere... Perfect!
Thanks
JamesDR wrote:
> JamesDR wrote:
>> Scott Baker wrote:
>>> If I create the following table, and then try and insert the following
>>> data both inserts work. It looks like the second one works (it shouldn't
>>> because Last is NULL) because it a
JamesDR wrote:
> Scott Baker wrote:
>> If I create the following table, and then try and insert the following
>> data both inserts work. It looks like the second one works (it shouldn't
>> because Last is NULL) because it assumes Last = ''. Is there a way I can
>> make it NOT assume that? If Last i
Scott Baker escreveu:
If I create the following table, and then try and insert the following
data both inserts work. It looks like the second one works (it shouldn't
because Last is NULL) because it assumes Last = ''. Is there a way I can
make it NOT assume that? If Last is not specified it shoul
1 - 100 of 540 matches
Mail list logo
