art...@gmail.com]
> Sent: Tuesday, September 24, 2013 1:44 PM
> To: shawn green
> Cc: mysql mailing list
> Subject: Re: Problem with having
>
> On Tue, Sep 24, 2013 at 9:05 AM, shawn green
> wrote:
>
> > Hello Larry,
> >
> >
> > On 9/23/2013 6:22 PM,
; -Original Message-
> From: Larry Martell [mailto:larry.mart...@gmail.com]
> Sent: Tuesday, September 24, 2013 1:44 PM
> To: shawn green
> Cc: mysql mailing list
> Subject: Re: Problem with having
>
> On Tue, Sep 24, 2013 at 9:05 AM, shawn green
> wrote:
>
> &
On Tue, Sep 24, 2013 at 9:05 AM, shawn green wrote:
> Hello Larry,
>
>
> On 9/23/2013 6:22 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 3:15 PM, shawn green **
>> wrote:
>>
>> Hi Larry,
>>>
>>>
>>> On 9/23/2013 3:58 PM, Larry Martell wrote:
>>>
>>> On Mon, Sep 23, 2013 at 1:51 PM, Sukhj
Hello Larry,
On 9/23/2013 6:22 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 3:15 PM, shawn green wrote:
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
wrote:
Hi,
In your second query, you seem to have MIN(date_time), but
On Mon, Sep 23, 2013 at 2:17 PM, Sukhjinder K. Narula
wrote:
> Hi,
>
> I see that. So the query seems to be picking the first entry out of the
> after grouping by a field and displaying it. And it seems to make sense
> since Having clause seems incomplete. I believe we need to complete the
> condi
On Mon, Sep 23, 2013 at 3:15 PM, shawn green wrote:
> Hi Larry,
>
>
> On 9/23/2013 3:58 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
>> wrote:
>>
>> Hi,
>>>
>>> In your second query, you seem to have MIN(date_time), but you are
>>> talking about maximum. So
select recipe_id,max(maxdatetime) from data_csmeta group by recipe_id
having recipe_id=19166;
On Mon, Sep 23, 2013 at 4:15 PM, shawn green wrote:
> Hi Larry,
>
>
> On 9/23/2013 3:58 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
>> wrote:
>>
>> Hi,
>>>
>>> I
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
wrote:
Hi,
In your second query, you seem to have MIN(date_time), but you are
talking about maximum. So your group by query is actually pulling the
minimum date for this recipe.
I pas
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
wrote:
> Hi,
>
> In your second query, you seem to have MIN(date_time), but you are
> talking about maximum. So your group by query is actually pulling the
> minimum date for this recipe.
>
I pasted the wrong query in. I get the same results r
Hi,
In your second query, you seem to have MIN(date_time), but you are talking
about maximum. So your group by query is actually pulling the minimum date
for this recipe.
Regards.
On Mon, Sep 23, 2013 at 3:35 PM, Larry Martell wrote:
> I want to find the rows from a table that have the max date
Hi Abhishek, Yes I can do that.
On Tue, Dec 11, 2012 at 12:50 PM, abhishek jain
wrote:
> Can you ping ip 192.168.1.9 from other machines?
> On Dec 11, 2012 11:21 AM, "Girish Talluru"
> wrote:
>
>> Hi Guys,
>>
>> I have environment as specified below.
>>
>> Main server: Windows Server 2008
>> Vir
Can you ping ip 192.168.1.9 from other machines?
On Dec 11, 2012 11:21 AM, "Girish Talluru" wrote:
> Hi Guys,
>
> I have environment as specified below.
>
> Main server: Windows Server 2008
> Virtual Box: Oracle VM
> VM OS: Ubuntu
>
> Inside Ubuntu I downloaded and configured Apache, MySql, PHP
Am 15.03.2012 17:31, schrieb Malka Cymbalista:
> We are running MySQL version 5.0.45 on a Linux machine. Most of our tables
> are MyIASM but we have recently installed drupal 7 and drupal 7 requires
> INNODB tables. Every now and then when we restart MySQL using the commands
> /etc/init.d/mys
On Mon, Jan 9, 2012 at 2:21 PM, Larry Martell wrote:
> Some may consider this slightly off-topic, but I'm out of places to
> turn to, so I'm hoping someone here can help me.
>
>
> I am having no luck with getting the python module MySQLdb to work on
> my Mac. I am getting the dreaded 'wrong archit
* Martin Mueller [12 13:42]:
<..>
> In short, in my installation there seems a gap between mysql and mysql, and
> I can't find any good explanations for what I might have done wrong or how I
> could fix it.
>
> I'll be grateful for any help.
I am probably not going to be very useful, but
在 2011-10-31一的 16:18 +0530，nataraj 0102写道：
> Hello,
>
>
>
> I am using MYSQL database with Linux server.
>
> I have a problem with one table, when I tried to get the data from that
> table, I am getting error : “mysql error 4600: mysql server gone away.
>
> No connection, trying to re-connect”
- Original Message -
> From: "Gavin Towey"
>
> The server will disconnect idle connections after a while. The
> wait_timeout variable controls how many seconds it will wait. You
> can set it for your connection when you connect by issuing a query
> like:
>
> SET SESSION wait_timeout=NN
The server will disconnect idle connections after a while. The wait_timeout
variable controls how many seconds it will wait. You can set it for your
connection when you connect by issuing a query like:
SET SESSION wait_timeout=NNN;
Just give it a large enough value.
But also, since your prog
Swaroop:
How are you handling the connections to db ? only one, with a pool,
something adhoc ?.
It looks like the connection is only one and expires after a time out
and you get the error that there is no connection.
Carlos
On 5/2/2011 3:15 PM, Andrés Tello wrote:
Seems more a java issue th
Seems more a java issue than a mysql issue... check for your parameters for
any keepalive or persostent option...
I think you wouldn't need to recompile just re-run or at leat, reboot the
server..
On Mon, May 2, 2011 at 2:34 AM, swaroop jois wrote:
> Hello friends, I have MySQL server versio
Go to the cmd line and type ps -ef , do you see mysqld listed? If so then it is
already running.
-Original Message-
From: Gergely Buday [mailto:gbu...@gmail.com]
Sent: Tuesday, April 26, 2011 5:56 AM
To: mysql@lists.mysql.com
Subject: problem starting server
Hi there,
I installed a my
Am 26.04.2011 14:56, schrieb Gergely Buday:
> Hi there,
>
> I installed a mysql server on my Mac using homebrew.
>
> $ mysql --version
> mysql Ver 14.12 Distrib 5.0.91, for apple-darwin10.0 (i386) using
> EditLine wrapper
>
> When trying to start it I get
>
> $ mysql.server start
> Starting M
After updating the SQL_MODE, it works as I expect.
Thanks for your prompt replies!
Johan
-Original Message-
From: petya [mailto:pe...@petya.org.hu]
Sent: Monday, March 21, 2011 12:10 PM
To: Johan De Taeye
Cc: mysql@lists.mysql.com
Subject: Re: Problem filtering with a "
On Mon, 21 Mar 2011 11:51:27 +0100
Johan De Taeye wrote:
> insert into lookup (name) values ('AAA');
>
> select * from lookup where name like 'A%';
> => 1 record returned. OK
>
> select * from lookup where name like 'A' || '%';
> => returns nothing. INCORRECT!
The query is incorrect. The O
Hi,
|| isn't the concatenation operator by default. If you want it to be set
sql_mode=PIPE_AS_CONCAT. Otherwise, use the CONCAT() function instead of
|| operator.
Peter Boros
On 03/21/2011 11:51 AM, Johan De Taeye wrote:
I ran into this case where a "like" expression is not evaluated correc
Dont you have mysql dump file for those table? It is best way to restore
InnoDB tables.
2011/1/7 Elim PDT
> I messed up the ibdata1,ib_logfile1,0 files and encounter the problems of
> openning innodb tables even after I copied the back-up files of few months
> ago. I don't have many innodb tabl
In the last episode (Dec 20), Johnny Withers said:
> On Mon, Dec 20, 2010 at 11:52 AM, muhammad subair wrote:
> > I have table post (id INT and parent VARCHAR)
> >
> > +--+-+
> > | id | parent |
> > +--+-+
> > |1 | 0 |
> > |2 | 0 |
The sub-select only returns a single row, so IN(...) is only looking at a
single value in the list .. it doesn't "expand" to into IN (5,7,11).
On Mon, Dec 20, 2010 at 11:52 AM, muhammad subair wrote:
> I have table post (id INT and parent VARCHAR)
>
> +--+-+
> | id | parent
Hi Baron
This tool works better than mytop, you solved my problem, thanks a lot
Carlos
> Date: Tue, 17 Aug 2010 10:41:23 -0400
> Subject: Re: Problem with mytop
> From: ba...@xaprb.com
> To: mysql@lists.mysql.com
>
> Carlos,
>
> Have you tried innotop instead? I
Carlos,
Have you tried innotop instead? It's a better replacement for mytop.
(I wrote it.)
- Baron
On Tue, Aug 17, 2010 at 8:50 AM, Carlos Eduardo Caldi
wrote:
>
>
> If sombody can help me I'll be gratefull
>
> I have a problem with mytop1.6 on Mandriva 2010.1, when I install it on a
> Slave
On 7/8/2010 10:59 AM, John Nichel wrote:
Hi,
I'm hoping what I'm trying to do can be done, but I can't seem to find
the right syntax. I have the following query:
SELECT
... snipped ...
if(
(
selec
> -Original Message-
> From: Peter Brawley [mailto:peter.braw...@earthlink.net]
> Sent: Thursday, July 08, 2010 12:27 PM
> To: mysql@lists.mysql.com
> Subject: Re: Problem with IF() inside of a select statement
>
> >Is there a way I
> >can do a IF((SELECT
Is there a way I
can do a IF((SELECT.), expr2, expr3) and have expr2 populate with
whatever is returned from the select statement?
Yes, select if( (select count(*) from mytable ) > 100, 1, 0) works fine.
The alias inside your last If(...), though, is not visible outside its
parentheses;
alba.albetti wrote:
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written
>C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says >Enter password: and I've given and I
get
mysqladmin: connect to server at 'local
what is mysql2010, it it host name or password.
If password, there cannot be space for a password, it its host, then dont
use if u connecting from the server.
regards
anandkl
On Fri, Apr 9, 2010 at 2:06 AM, Michael Dykman wrote:
> If you want to specify the password itself on the command line
If you want to specify the password itself on the command line use
'--password' (double hyphen). '-p' requests interactive password
prompt.
- michael
On Thu, Apr 8, 2010 at 4:31 PM, Carsten Pedersen wrote:
> don't have a space between '-p' and 'password', i.e. -ppassword
>
> / Carsten
>
> alb
don't have a space between '-p' and 'password', i.e. -ppassword
/ Carsten
alba.albetti skrev:
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written
>C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says >Enter pa
At 09:02 AM 4/8/2010, alba\.albetti wrote:
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've
written >C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says >Enter password: and I've given
and I get
mysqladmin: con
On Thu, Apr 8, 2010 at 10:25 AM, nwood wrote:
> OK, at a 5 minute glance:
> 1.) I think the reason it isn't working is that MySQL/PHP don't support
> reading from two buffered result sets concurrently: read from one then
> the other.
>
Specifically, it doesn't support multiple buffered result se
On Wed, 2010-04-07 at 21:37 -0700, Karthick Subramanian wrote:
> I need to read an array's content using a while loop and inside the loop
> read another array's content. Using the variables from the two arrays I need
> to execute a query. My problem is the inner while loop reads all records of
> th
skip-networking is OFF
On 1/22/2010 12:09 PM, Mark Matthews wrote:
On Jan 22, 2010, at 10:49 AM, Mark Witczak wrote:
Alright, here is the entire log entry:
Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Jan 21, 2010 9:40
On Jan 22, 2010, at 10:49 AM, Mark Witczak wrote:
> Alright, here is the entire log entry:
>
> Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
> INFO: ContextListener: contextInitialized()
> Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
> INFO: S
Alright, here is the entire log entry:
Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
Jan 21, 2010 9:43:06 PM or
On Jan 22, 2010, at 10:21 AM, Mark Witczak wrote:
> [snip]
> I create the WAR (jar cvf testapp.war *), undeploy the old version and
> redeploy the new one through Tomcat Web Application Manager. Then restart
> Tomcat (sudo /etc/init.d/tomcat restart). The result is:
>
> Jan 21, 2010 9:40:35 P
On Monday 11 January 2010 12:33, Mihamina Rakotomandimby wrote:
> (Correction, seel below)
>
> > Jørn Dahl-Stamnes :
> > > > I have checked the local DNS and 'r2-d2' and
> > > > 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse.
> > > > What's wrong?
> > >
> > > Reverse resolution?
> >
> > I
(Correction, seel below)
> Jørn Dahl-Stamnes :
> > > I have checked the local DNS and 'r2-d2' and
> > > 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse.
> > > What's wrong?
> > Reverse resolution?
> I have checked that, and reverse DNS is OK - both resolve to
> 192.18.2.22
I read you sol
> Jørn Dahl-Stamnes :
> > > I have checked the local DNS and 'r2-d2' and
> > > 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse.
> > > What's wrong?
> > Reverse resolution?
> I have checked that, and reverse DNS is OK - both resolve to
> 192.18.2.22
I read you solved your problem, but by "
On Monday 11 January 2010 09:55, Ananda Kumar wrote:
> use mysql;
> select * from user;
>
> see if you able to see 'r2-d2' entry in this table.
>
> also you can try this
>
> grant all on . to 'root'@'%' idenfified by
> 'secret-password';
I just found the cause of the problem... /etc/nsswitch.conf
use mysql;
select * from user;
see if you able to see 'r2-d2' entry in this table.
also you can try this
grant all on . to 'root'@'%' idenfified by
'secret-password';
regards
anandkl
On Mon, Jan 11, 2010 at 1:40 PM, Jørn Dahl-Stamnes
wrote:
> On Monday 11 January 2010 08:53, Mihamina Rakotoma
On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote:
> > Jørn Dahl-Stamnes :
> > I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net'
> > resovl to the same IP-addresse.
> > What's wrong?
>
> Reverse resolution?
I have checked that, and reverse DNS is OK - both resolve
> Jørn Dahl-Stamnes :
> I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net'
> resovl to the same IP-addresse.
> What's wrong?
Reverse resolution?
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche & Developpement
+26
On Sunday 10 January 2010 12:34, sureshkumar...@gmail.com wrote:
> Hi,
> The grant stmt has to be as below.
> Grant all on databasename.tablename to usern...@iporhostname identified by
> 'password';
>
> Use as above
> Grant stmt doesn't require a flush stmt.
Woops... Seems like the * in my first
Hi,
The grant stmt has to be as below.
Grant all on databasename.tablename to usern...@iporhostname identified by
'password';
Use as above
Grant stmt doesn't require a flush stmt.
Suresh Kuna
MySQL DBA
--Original Message--
From: Jørn Dahl-Stamnes
To: mysql@lists.mysql.com
ReplyTo: sq.
Hi John,
You can turn of name resolution by adding skip-name-resolve to the [mysqld]
section of your my.cnf file.
Regards,
Gavin Towey
-Original Message-
From: John Oliver [mailto:joli...@john-oliver.net]
Sent: Wednesday, September 16, 2009 4:24 PM
To: mysql@lists.mysql.com
Subject: Pro
together. Hence the need
> for a mysql dump tool ;-)
>
> Mysql dump is the better way to go in either situation.
>
> > -Original Message-
> > From: Victor Subervi [mailto:victorsube...@gmail.com]
> > Sent: Wednesday, September 02, 2009 1:43 PM
> > To:
..@gmail.com]
> Sent: Wednesday, September 02, 2009 1:43 PM
> To: Daevid Vincent; mysql@lists.mysql.com
> Subject: Re: Problem w/ mysqldump
>
> I checked my own backup script from earlier years and
> everything was good.
> You know, if I could simply figure out where the data
t;
> > -Original Message-
> > From: news [mailto:n...@ger.gmane.org] On Behalf Of Emile van Sebille
> > Sent: Wednesday, September 02, 2009 7:18 AM
> > To: mysql@lists.mysql.com
> > Cc: python-l...@python.org
> > Subject: Re: Problem w/ mysqldump
> >
>
ginal Message-
> From: news [mailto:n...@ger.gmane.org] On Behalf Of Emile van Sebille
> Sent: Wednesday, September 02, 2009 7:18 AM
> To: mysql@lists.mysql.com
> Cc: python-l...@python.org
> Subject: Re: Problem w/ mysqldump
>
> On 9/2/2009 3:43 AM Victor Subervi said...
>
On 9/2/2009 3:43 AM Victor Subervi said...
Hi:
I have the following python code:
import os
os.system("mysqldump -u root -pPASSWORD --opt spreadsheets > dump.sql")
First, test this at the system command line -- you'll likely get an
empty file there as well, so calling from within python simply
Did you deleted the data dir (inside Program Files) after uninstall ?? i
think that is was not empty and when the new install tries to set up
finds it and get messy (maybe because the 32 and 64 bit issue).
Carlos
On 7/13/2009 11:07 PM, Edward Diener wrote:
I had previously installed the 64-b
Marco, all,
Marco Bartz wrote:
> I accidentally sent it before finishing...
>
> I am looking for a way to do the following with a single query:
>> SELECT `ID`, `Name`, `Interface`,
>> (SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
>> `activeListings`
>> FROM `sites`
Marco Bartz wrote:
I accidentally sent it before finishing...
I am looking for a way to do the following with a single query:
SELECT `ID`, `Name`, `Interface`,
(SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
`activeListings`
FROM `sites`
I am querying the
I accidentally sent it before finishing...
I am looking for a way to do the following with a single query:
> SELECT `ID`, `Name`, `Interface`,
> (SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
> `activeListings`
> FROM `sites`
>
I am querying the sites table and I want
At 01:22 PM 5/17/2009, Walter Heck - OlinData.com wrote:
Try putting in a full existing pathname the server has write access to
as opposed to just a file name.
Walter Heck
Walter,
That didn't work either if I put it in the my.ini file. Without a path
it should default the location to the
Try putting in a full existing pathname the server has write access to
as opposed to just a file name.
Walter Heck
On Sun, May 17, 2009 at 12:13 PM, mos wrote:
> I'm having a problem defining slow logging file in my.ini (Windows XP). I'm
> using MySQL 5.1.30.
>
> In the MySQL reference manual
most likely a missing include it should have at least:
#include
#include
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
schrieb:
> make all-am
> Making all in mysql-test
> Making all in lib/My/SafeProcess
> g++ -DHAVE_CONFIG_H -I. -I../../../../include -O3
OK, Now I have gotten something...
[ '~/.tdphp-vserver/includes/10_electronica_admin.inc' ]
# while ($DB_list=db_fetch_array($DB_result)) {
#$output .= "\n";
while ($DB_list=db_fetch_array($DB_result)) {
print_r ($DB_list);
}
echo "\n";
exit();
--
Hi Krishna,
I use the script mysql_multi to stop and the start several, or all,
instances.
At the end, to work with more ease,
I will create scripts to connect to each instance
and in the script force the variable prompt at the connection
seems easy
Thanks for all !!!
Il
Hi Stefano,
I believe that, different mysql configuration file for different mysql
instance is a better idea. In your case, if any thing goes wrong with my.cnf
Then, it is going to effect all mysql instance (either restart mysql server
or any other way). It has a lots of disadvantages.
You might
Hi Krishna,
the problem is that you use --default-file on the command line and in
this mode it's working fine,
I also tried,
but I have the configuration of the variable "default-file" in the
general my.cnf and I enter in MySQL
in this way:
mysql --socket=/tmp/mysql50_SIA_SVILUPPO.sock
W
Hi Stefano,
I have tested. It's working fine without any issue.
Open mysql configuration(.cnf) file referencing to 1st mysql instance. Add
the below entires and restart the mysql server.
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
pro
Hi Krishna,
thanks for the your answer !!!
I have three different my.cnf for my three instances but one general
my.cnf to manage all instances,
my general my.cnf is:
[mysqld_multi]
mysqld = /opt/local/mysql50/bin/mysqld_safe
mysqladmin = /opt/local/mysql50/bin/mysqladmin
user = root
pas
prajapat...@gmail.com ("Krishna Chandra Prajapati") writes:
> You are running three mysql instance on single server. You can have three
> my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other
> information in them. In this way you can set the prompt for different
> instance.
Thanks for the all answers !!!
It's ok,
even if I have three different my.cnf for my three instances,
my general my.cnf is:
[mysqld_multi]
mysqld = /opt/local/mysql50/bin/mysqld_safe
mysqladmin = /opt/local/mysql50/bin/mysqladmin
user = root
password = mysys2008srv
log = /MYSQL/MYSQL_LOG/My
Stefano Elmopi wrote:
If I put the variable prompt in the general my.cnf, the prompt is
changed but for all instances.
If I put in the variable prompt in the my.cnf associated with the instance
in the [mysql] section, the prompt does not change.
This is because the client reads from my.cnf b
Ciao Stefano,
how do you connect to the different instances?
if you use different operating system users or different mysql home
directories
just put in the home directory of each user a .my.cnf file (or my.cnf in the
mysql home)
with just the prompt setting in the [mysql] section.
NOTE: in the
Hi Stefano,
You are running three mysql instance on single server. You can have three
my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other
information in them. In this way you can set the prompt for different
instance.
On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi
wrote:
Learnt!
On Wed, Oct 15, 2008 at 5:28 PM, philip <[EMAIL PROTECTED]> wrote:
> > Date: Tue, 14 Oct 2008 16:55:11 +0300
> > From: Olexandr Melnyk <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED], mysql@lists.mysql.com
> > Subject: Re: Problem with GROUP BY
> >
> Date: Tue, 14 Oct 2008 16:55:11 +0300
> From: Olexandr Melnyk <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], mysql@lists.mysql.com
> Subject: Re: Problem with GROUP BY
>
> http://jan.kneschke.de/projects/mysql/groupwise-max
>
> 2008/10/14 Peter Brawley <
http://jan.kneschke.de/projects/mysql/groupwise-max
2008/10/14 Peter Brawley <[EMAIL PROTECTED]>
> Philip
>
> mysql> SELECT number, MAX(event), name FROM info GROUP BY number;
>>
>
> For discussion & examples see "Within-group aggregates" at
> http://www.artfulsoftware.com/queries.php.
>
> PB
>
Philip
mysql> SELECT number, MAX(event), name FROM info GROUP BY number;
For discussion & examples see "Within-group aggregates" at
http://www.artfulsoftware.com/queries.php.
PB
-
philip wrote:
I created a table with,
CREATE TABLE info (
number INTEGER UNSIGNED,
event INTEGE
ROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2008 3:30 PM
To: Parikh, Dilip Kumar; mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: RE: Problem - "Host 'abc.def.com' is not allowed to connect to
this MySQL server", Please advice..
Hi,
I did that too,
I exec
2029004
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2008 3:30 PM
To: Parikh, Dilip Kumar; mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: RE: Problem - "Host 'abc.def.com' is not allowed to connect to
this MySQL server", Pl
make sure to FLUSH PRIVILAGES;
- Original Message
> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]; mysql@lists.mysql.com
> Cc: [EMAIL PROTECTED]
> Sent: Monday, 14 July, 2008 10:59:35 AM
> Subject: RE: Problem - "Host '
Hi,
I did that too,
I executed the command -> GRANT ALL PRIVILEGES ON *.* to
'root'@'localhost' ;
I tried also GRANT ALL PRIVILEGES ON *.* to 'root'@'abc.def.com' ; where
abc.def.com is my machine name
But both of these did not work, I did not mention this in my earlier
mail. Can you please let
On Jun 24, 2008, at 2:57 AM, Gwynne Raskind wrote:
I'm having the issue with CREATE TABLE described by Bug #30513 (http://bugs.mysql.com/bug.php?id=30513
). To summarize, a table which previously existed, and then is
dropped by DROP TABLE IF EXISTS, becomes randomly unable to be
recreated. He
On Jun 24, 2008, at 10:13 AM, Rolando Edwards wrote:
My first impression is to say: "Sounds like the InnoDB internal data
dictionary still has the table recorded somewhere." According to
Page 566 Paragraph 3 of "MySQL Administrator's Guide and Language
Reference" (ISBN 0-672-32870-4),
"Inn
My first impression is to say: "Sounds like the InnoDB internal data dictionary
still has the table recorded somewhere." According to Page 566 Paragraph 3 of
"MySQL Administrator's Guide and Language Reference" (ISBN 0-672-32870-4),
"InnoDB always needs the shared tablespace because it puts its
-infoshop.com
www.giiexpress.com
www.etudes-marche.com
>-Original Message-
>From: Tim McDaniel [mailto:[EMAIL PROTECTED]
>Sent: Monday, April 28, 2008 12:19 PM
>Cc: mysql@lists.mysql.com
>Subject: RE: Problem with character set and connection collation
>
>On Mon, 28 Apr 2008, Jerry
On Mon, 28 Apr 2008, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
A week or so ago I explored this in depth because I was having the
same problems. (It was affecting an English file that had some
Windows (CP-1252) characters that didn't directly map to UTF-8. That
message is at http://lists.mysql.co
A week or so ago I explored this in depth because I was having the same
problems. (It was affecting an English file that had some Windows (CP-1252)
characters that didn't directly map to UTF-8. That message is at
http://lists.mysql.com/mysql/212392. I didn't mention it in my posting, but
latin1 is
Hi Sulo,
Open the file you are importing as it is probably that it contains
references of another character set in the table creation. If so replace
that character set for '' or 'utf8'.
I hope it helps,
Leandro
sulochan acharya wrote:
Hello all,
here is my problem:
I am trying to set my
On Apr 14, 2008, at 4:37 PM, Daniel Brown wrote:
On Mon, Apr 14, 2008 at 3:45 PM, Daniel Brown <[EMAIL PROTECTED]>
wrote:
Does your file actually have the characters \t \t \n at the end of
each row like that?
Send it to me as an attachment off-list and I'll help you figure
it out and t
On Mon, Apr 14, 2008 at 3:45 PM, Daniel Brown <[EMAIL PROTECTED]> wrote:
>
> Does your file actually have the characters \t \t \n at the end of
> each row like that?
>
> Send it to me as an attachment off-list and I'll help you figure
> it out and then post back here for the MySQL archive
On Apr 14, 2008, at 3:29 PM, Daniel Brown wrote:
On Mon, Apr 14, 2008 at 1:29 PM, Jason Pruim <[EMAIL PROTECTED]>
wrote:
Hi Everyone,
I am attempting to use this command: load data infile
'/volumes/raider/elks.test.txt' into table elksCurrent fields
terminated by
'\t' lines terminated by '
On Mon, Apr 14, 2008 at 3:33 PM, Jason Pruim <[EMAIL PROTECTED]> wrote:
>
> On Apr 14, 2008, at 3:29 PM, Daniel Brown wrote:
> >
> > That's because it's attempting to insert the name of the columns
> > from your CSV into MySQL --- and 'Record' is not a valid INT.
> >
>
> Replaced field name wit
On Mon, Apr 14, 2008 at 1:29 PM, Jason Pruim <[EMAIL PROTECTED]> wrote:
> Hi Everyone,
>
> I am attempting to use this command: load data infile
> '/volumes/raider/elks.test.txt' into table elksCurrent fields terminated by
> '\t' lines terminated by '\n';
[snip!]
>
> The error that I'm getting is
Hi again everyone,
After taking the advice of someone offlist I tried the "IGNORE 1
LINES" and that didn't help... Same result. I've tried a tab delimited
file, and a comma separated file. Same result with both. Any other
ideas? :)
On Apr 14, 2008, at 1:29 PM, Jason Pruim wrote:
Hi Ever
On Apr 14, 2008, at 2:01 PM, Rob Wultsch wrote:
On Mon, Apr 14, 2008 at 10:47 AM, Rob Wultsch <[EMAIL PROTECTED]>
wrote:
It is probably trying to insert a string of no length into the not
null field.
Try it with:
SET SQL_MODE = '';
Above should read "into an int field, while the server is in
On Mon, Apr 14, 2008 at 10:47 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> It is probably trying to insert a string of no length into the not null
> field.
> Try it with:
> SET SQL_MODE = '';
Above should read "into an int field, while the server is in strict mode".
--
Rob Wultsch
[EMAIL PROT
1 - 100 of 1630 matches
Mail list logo
