-
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
shawn.l.gr...@oracle.comwrote:
Hello Larry,
On 9/23/2013 6:22 PM, Larry
[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
shawn.l.gr...@oracle.comwrote:
Hello Larry,
On 9/23/2013 6:22 PM, Larry Martell wrote:
On Mon
Hello Larry,
On 9/23/2013 6:22 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 3:15 PM, shawn green shawn.l.gr...@oracle.comwrote:
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
narula...@gmail.comwrote:
Hi,
In your second
On Tue, Sep 24, 2013 at 9:05 AM, shawn green shawn.l.gr...@oracle.comwrote:
Hello Larry,
On 9/23/2013 6:22 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 3:15 PM, shawn green shawn.l.gr...@oracle.com**
wrote:
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23,
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 larry.mart...@gmail.comwrote:
I want to find the rows from a table
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
narula...@gmail.comwrote:
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
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
narula...@gmail.comwrote:
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
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 shawn.l.gr...@oracle.comwrote:
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
On Mon, Sep 23, 2013 at 3:15 PM, shawn green shawn.l.gr...@oracle.comwrote:
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
narula...@gmail.comwrote:
Hi,
In your second query, you seem to have MIN(date_time), but you are
On Mon, Sep 23, 2013 at 2:17 PM, Sukhjinder K. Narula
narula...@gmail.comwrote:
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
Hi Abhishek, Yes I can do that.
On Tue, Dec 11, 2012 at 12:50 PM, abhishek jain
abhishek.netj...@gmail.comwrote:
Can you ping ip 192.168.1.9 from other machines?
On Dec 11, 2012 11:21 AM, Girish Talluru girish.dev1...@gmail.com
wrote:
Hi Guys,
I have environment as specified below.
Main
Can you ping ip 192.168.1.9 from other machines?
On Dec 11, 2012 11:21 AM, Girish Talluru girish.dev1...@gmail.com 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
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/mysql
On Mon, Jan 9, 2012 at 2:21 PM, Larry Martell larry.mart...@gmail.com 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
* Martin Mueller martinmuel...@northwestern.edu [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
在 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” …. This
- Original Message -
From: Gavin Towey gto...@ffn.com
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
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
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 jois_swar...@yahoo.com wrote:
Hello friends, I
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
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 MySQL
..
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
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
On Mon, 21 Mar 2011 11:51:27 +0100
Johan De Taeye johan.de.ta...@gmail.com 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
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 like
Dont you have mysql dump file for those table? It is best way to restore
InnoDB tables.
2011/1/7 Elim PDT e...@pdtnetworks.net
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
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 msub...@gmail.com wrote:
I have table post (id INT and parent VARCHAR)
+--+-+
| id
In the last episode (Dec 20), Johnny Withers said:
On Mon, Dec 20, 2010 at 11:52 AM, muhammad subair msub...@gmail.com wrote:
I have table post (id INT and parent VARCHAR)
+--+-+
| id | parent |
+--+-+
|1 | 0 |
|2 | 0
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? It's a better replacement for mytop
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
ce_ca...@hotmail.com wrote:
If sombody can help me I'll be gratefull
I have a problem with mytop1.6 on Mandriva 2010.1, when I install
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(
(
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;
-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.), expr2, expr3) and have expr2
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 enter and I
get
mysqladmin: connect to server at
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 mdyk...@gmail.com wrote:
If you want to specify the password itself on
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
the
On Thu, Apr 8, 2010 at 10:25 AM, nwood nw...@plus.net 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
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 enter
and I get
mysqladmin:
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
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 cars...@bitbybit.dk wrote:
don't have a space between '-p' and 'password', i.e. -ppassword
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 PM
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
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:
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
On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote:
Jørn Dahl-Stamnes sq...@dahl-stamnes.net :
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 -
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
sq...@dahl-stamnes.netwrote:
On Monday 11 January 2010
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.
It
Jørn Dahl-Stamnes sq...@dahl-stamnes.net :
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,
(Correction, seel below)
Jørn Dahl-Stamnes sq...@dahl-stamnes.net :
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
On Monday 11 January 2010 12:33, Mihamina Rakotomandimby wrote:
(Correction, seel below)
Jørn Dahl-Stamnes sq...@dahl-stamnes.net :
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
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:
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 mail
Jørn Dahl-Stamnes sq...@dahl-stamnes.net :
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
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:
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
-
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...
Hi:
I have the following python code:
import
-
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...
Hi:
I have the following python
: 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 was
actually stored,
in what file, I could copy
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: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: Problem w/ mysqldump
I
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
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 to
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
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`
There is
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 mo...@fastmail.fm 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
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
most likely a missing include it should have at least:
#include sys/time.h
#include sys/resource.h
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.
OK, Now I have gotten something...
[ '~/.tdphp-vserver/includes/10_electronica_admin.inc' ]
snip
# while ($DB_list=db_fetch_array($DB_result)) {
#$output .= lia href=\/?what=adminwhere= . $VAL2 . action=edit
#if ($_COOKIE[$VAL2 . '_desc_short'] == 'show') {
#
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
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
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
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,
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 !!!
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
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
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
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 =
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.
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
http://jan.kneschke.de/projects/mysql/groupwise-max
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 [EMAIL PROTECTED]
Philip
mysql SELECT number
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 INTEGER
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
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
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 'abc.def.com' is not allowed to connect
]
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 executed the command - GRANT ALL PRIVILEGES ON *.* to
'root
; 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 executed the command - GRANT ALL PRIVILEGES ON *.* to
'root'@'localhost' ; I tried also GRANT ALL PRIVILEGES
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.
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
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),
InnoDB
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
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
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
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 Schwartz [EMAIL PROTECTED] wrote:
A week
On Mon, Apr 14, 2008 at 10:29 AM, 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';
My table is created as such:
|
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 PROTECTED]
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
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
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:
|
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 with 0 and had
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: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 archives.
1 - 100 of 1571 matches
Mail list logo