Kaushal
There are two ways to approach this:
1.) Turn off name resolution in MySQL and only do the ACL by IP. This is
probably best as name resolution can slow the database and cause
outright app failure if DNS fails for any reason.
2.) Make absolutely certain the names resolve correctly in
Mike,
check the datadir (usually /var/lib/mysql). If it's empty, manually execute
mysql_install_db. This will place an initial db in place and mysql will start
from then on
On 02/18/2015 03:11 PM, mike wrote:
> Cameron Mann cybera.ca> writes:
>
>> Hi all,
>>
>> I've encountered a problem w
It worked before, when you manually had to execute the script... It worked when
the script was auto invoked. Now it's silently busted, causing problems for
people you think
that's OK.
Whatever.
Moving on
On 02/12/2015 03:45 PM, Reindl Harald wrote:
>
> Am 13.02.2015 um 00:
;just work"? Except when they don't.
What slobs!
On 02/12/2015 03:11 PM, Reindl Harald wrote:
>
>
> Am 13.02.2015 um 00:03 schrieb Bruce Ferrell:
>> If the datadir is empty. you have to execute a different utility
>> mysql_install_db. This will create a corr
If the datadir is empty. you have to execute a different utility
mysql_install_db. This will create a correct initial database.
Jesus! I HATE systemd. The sysV init script handled this correctly.
On 02/12/2015 02:06 PM, Cameron Mann wrote:
> Hi Robert,
>
> The value in my.cnf is datadir=/var
The mysql_upgrade errors look like the mysql command line client can't be
located by the script... some kind of path error induced by a security "fix"
I'm thinking
On 02/12/2015 12:37 PM, Cameron Mann wrote:
> Hi all,
>
> I've encountered a problem with MySQL 5.6.23 on CentOS 7.0 and would
>
hey.
within php (or any other language)
is there a way to create the mysql sql, and execute the sql, where the
process can "wait" until the network connection for the mysql
command/process is actually valid?
IE (phpesque)
$pdo=new pdo()
sql = "select * from foo where a=:a"
$s=$pdo->prepare($sql)
he answers?
Inquiring minds want to know
Thanks in advance
Bruce Ferrell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On 07/30/2013 04:13 AM, Manivannan S. wrote:
Hi,
I've a table with 10 Million records in MySQL with INNODB engine. Using this
table I am doing some calculations in STORED PROCEDURE and getting the results.
In Stored Procedure I used the base table and trying to process all the records
in the
On 06/23/2013 11:18 AM, Rafael Valenzuela wrote:
Hi All,
I have a question about the materialized views , i remember in the DBA
course my trainer said me. In Mysql doesn't exist this type views like
Oracle. But My boss think the opposite.
In the new version has this type of view? and the difere
On 06/23/2013 11:18 AM, Rafael Valenzuela wrote:
Hi All,
I have a question about the materialized views , i remember in the DBA
course my trainer said me. In Mysql doesn't exist this type views like
Oracle. But My boss think the opposite.
In the new version has this type of view? and the difere
On 05/09/2013 03:25 PM, Robinson, Eric wrote:
-Original Message-
From: Robinson, Eric [mailto:eric.robin...@psmnv.com]
Sent: Thursday, May 09, 2013 1:58 PM
To: mysql@lists.mysql.com
Subject: Slow Response -- What Does This Sound Like to You?
We have a situation where users complain tha
Hi.
Considering a system, where I have a centralized Mysql setup. I'm not
sure exactly what this should be called, single box, cluster, etc...
But I'm looking to have a system of a a bunch of boxes, whihc run apps
that will access (read/write) to the different dbs/tbls on the mysql
setup.
I'm tr
I've long used mysqltuner.pl and have recently heard that it may not be the
best tool for the job. what are others using? What experiences have you had
with mysqltuner.pl
Inquiring minds want to know
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
rovide the sample tbl defs/data that I'm using, as well as more
data on what I'm trying to accomplish.
So, if you're skilled in this area, let's talk.
Thanks
-bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
some way
of linking the childID of the descendant to the linked ID of the
statusTBL so I can get the status of the childID/app.
And like I said, I'm not quite sure how to proceed in an efficient
manner on this.
Thanks
On Mon, Jan 16, 2012 at 4:08 PM, Peter Brawley
wrote:
> On 1/
On Mon, Jan 16, 2012 at 1:52 PM, bruce wrote:
> Hey Authur.
>
> Should have been more clear. I've looked over a number of sites. And
> with the exception of the the articles that talk about using the
> "Nested List" approach, nowhere did I find data on how to get
Running mysql(5.5) /linux/ php/python
Got a situation with a test env, where I'm dealing with a number of
spawned processes, that might also spawn processes, so I have a "tree"
where I'm looking to determine when the spawned processes have
completed. To manage this cluster/tree of processes, I'm c
ws, in this way is a significant contributor to the problem?
Bruce Ferrell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Bravo Basil! I've been looking at this all day and wondering myself. Now that
I've said that.. And now for something terribly evil, is there an strace for
cygwin?
On 11/18/2011 03:30 PM, Basil Daoust wrote:
> Maybe this is the wrong place to ask, but why would you want to do this?
> Mysql has
The meaning is:
increase max_connections
reduce wait_timeout
-- 28800 is wait 8 hours before closing out dead connections
same for interactive_timeout
increase key_buffer_size (> 7.8G) increase join_buffer_size
-- This keeps mysql from having to run to disk constantly for keys
-- Key buffer siz
I'd suggest mysqltuner. You can get it by using:
wget http://mysqltuner.pl
See what suggestions that makes
On 10/02/2011 06:44 AM, Joey L wrote:
> I have having issues with mysql db - I am doing a "select count(*) from
> table" -- and it take 3 to 4 min.
> My table has about 9,000,000 recor
That's the ticket! Thanks
On 09/08/2011 06:55 AM, Andrew Moore wrote:
Check that you're looking at the variable in the GLOBAL scope not the
SESSION scope.
SHOW GLOBAL VARIABLE ...
Andy
On Thu, Sep 8, 2011 at 11:34 AM, Bruce Ferrellwrote:
On 09/08/2011 02:56 AM, Johan De Meer
On 09/08/2011 02:56 AM, Johan De Meersman wrote:
- Original Message -
From: "Bruce Ferrell"
To: mysql@lists.mysql.com
Sent: Thursday, 8 September, 2011 3:10:16 AM
Subject: trying to change wait_timeout
I've read the documentation on MySQL for version 5.1 and it says all
at am I missing?
Thanks in advance,
Bruce Ferrell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On 01/31/2011 12:18 PM, Jørn Dahl-Stamnes wrote:
> On Monday 31 January 2011 21:12, Phillip Baker wrote:
>
>> Greetings All,
>>
>> I am looking for a little help in setting a where clause.
>> I have a dateAdded field that is a DATETIME field.
>> I am looking to pull records from Midnight to midn
On 01/14/2011 08:19 AM, Steve Meyers wrote:
> On 1/14/11 3:52 AM, Bruce Ferrell wrote:
>> select count(*) as count
>> from alerts where (unix_timestamp(stamp)> (unix_timestamp(now()) -
>> '300' ) )
>> and devid = '244';
>>
>
> Bruce
300' ) )
and devid = '244';
Thanks in advance,
Bruce
P.S.
I've tried it this way:
select count(*) as count from alerts where ((unix_timestamp(stamp) >
(unix_timestamp(now()) - '300' ) )) and devid = '244';
and explain always says this:
+--+
Mysql tuner is a very useful tool to pull metrics
http://blog.mysqltuner.com/
On 09/21/2010 05:48 AM, Jangita wrote:
> I find this quite good
>
> http://www.mysqlperformanceblog.com/
>
> Send your my.cnf and maybe we could look at it and pick anything that would
> help.
>
>
> Jangita | +254 76
l-recursive] Error 1
Any ideas on how I can get the libraries and headers to build DBD::mysql?
Thanks in advance
Bruce Ferrell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
is script
>
>
> Thanks & Regards
> Jeetendra Ranjan
>
> - Original Message -
> From: "Bruce Ferrell"
> To:
> Cc:
> Sent: Thursday, October 15, 2009 12:20 PM
> Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily
>
>
>&g
Hi.
I've got a situation where I have a couple of tables. The relationship
between the tables is one of parent/child. I'm trying to figure out the best
approach to being able to delete the associated children in the child tbls,
of a given parentID in the parentTBL...
I've checked into various sit
Have a look at mysqltuner. It reads the stats from a running mysql
instances and makes suggestions for what can be changed
http://blog.mysqltuner.com/
Gavin Towey wrote:
> Hi,
>
> This script might help with some tuning suggestions, run it after you have
> some production traffic running ag
I seem to recall a SQL select syntax along these lines:
SELECT col1, col2
WHERE col1 IN (set)
Is this or similar syntax in MySQL or is my dotage coming upon me
Thanks in advance,
Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
hi.
i've got a situation, where i'm trying to figure out how to select an item
from tblA that may/maynot be in tblB.
if the item is only in tblA, i can easilty get a list of the items
select * from tblA
if the item is in tblA but not linked to tblB, i can get the items as well
select * from tb
hi martin...
thanks for the reply.. but that still generates two separate rows as well...
-Original Message-
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Friday, June 12, 2009 12:04 PM
To: bruce Douglas
Subject: RE: a possible group issue???
mysql> select * f
Hi...
I have the following...
mysql> INSERT INTO ParseScriptTBL VALUES
-> ('auburnCourse.py',40,1,1),
-> ('auburnFaculty.py',40,2,2),
-> ('uofl.py',2,1,3),
-> ('uky.py',3,1,4),
-> ('ufl.py',4,1,5)
-> ;
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql> select * from
Thanks all who replied.
After I posted I kept looking and found it... Also had folks point it
out to me.
Your suggestion is what I ended up doing.
Bruce
Gavin Towey wrote:
> Hi Bruce,
>
>
>
> SELECT … INTO OUTFILE always creates the file local to the database
> serve
runs the file tries to drop on the
database server and the application directory doesn't exist there giving
me the error.
Any suggestions to get the outfile to drop in the right place would be
appreciated.
Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
jason... did a fresh mysql install..
simply type
foo> mysql
and mysq will start, assuming you have the mysq daemon started.
to start the mysql daemon,
/etc/init.d/service/mysql start
(check it first, but it's something like the above..)
-Original Message-
From: Jason Todd Slack-Moeh
hi wm.
take this for what it's worth!
i think you're trying to solve an issue that's already been solved. why
don't you do some quick/dirty research on companies that either issue/manage
isbn numbers, or companies who sell solutions for online/brick-mortar
bookstores. explain that you're thiking
right...
forgot about that!
-Original Message-
From: Paul Wilson [mailto:hoo...@staff.iinet.net.au]
Sent: Monday, January 05, 2009 5:59 PM
To: 'bruce'; 'PJ'; 'mos'
Cc: mysql@lists.mysql.com
Subject: RE: how to design book db
Recent books that I'v
hey phil...
are you sure that a book can have multiple ISBN numbers. I was under the
impression that a book/version has a single ISBN number.
care to share where you have derived your understanding...
i believe bowkers/new jersy is responsible for allocating ISBN blocks for US
authors/publishers
hey...
got a quick situation where i'm trying to figure out how to do a
unique/distinct so i get "two" (2) rows for the 'faculty_id'...
so.. how can i get just two unique/distinct rows based on the faculty_id
thanks
mysql> select distinct f1_status.faculty_id, c1.cname, course1.cname,
f1_
Hi..
I have the following query.. missing something based on 'net searches. but
how do i create a "group" to allow me to get a single "row"/count based on
the 'd1_status.dept_id'
i can't figure out exactly where in the query to have the "count(*) xxx
group by abc"... the few different approaches i
always expedient for my
needs.
Thanks
-bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi.
I have the following test db/tbl setup.
stateTBL
+--+
| stateName|
| stateID |>>>+
+--+ V
V
V
collegeTBL V
+--+ V
| collegeName | V
| stateID |<<<+
| college
PROTECTED]
Sent: Friday, October 17, 2008 10:12 AM
To: bruce; 'Dan Nelson'
Cc: 'Marten Lehmann'; mysql@lists.mysql.com
Subject: RE: MySQL und dual cores
need to specify processor with 'taskset'
windows specific hacky workaround
http://blogs.techrepublic.com.com/program
2008 8:41 AM
To: bruce
Cc: 'Marten Lehmann'; mysql@lists.mysql.com
Subject: Re: MySQL und dual cores
In the last episode (Oct 17), bruce said:
> From: Dan Nelson
> > In the last episode (Oct 17), Marten Lehmann said:
> > > we are using MySQL 4.1 and 5 on AMD dual core
sorry..
my bad,
i was looking for the exact sequence of cmds that i could type in, in order to
test this!!... sorry for the confusion..
thanks
-Original Message-
From: ?? [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2008 8:26 AM
To: bruce
Cc: Dan Nelson; Marten Lehmann; mysql
hi...
a sa short test, how would one demonstrate this from the cli.., using the
mysql cmd interface??
thanks
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2008 7:59 AM
To: Marten Lehmann
Cc: mysql@lists.mysql.com
Subject: Re: MySQL und dual core
Hi..
I've got an issue with doing a Load data file" cmd..
my test text tbl has a column named "company name" i'm trying to figure out
how to use the load data file cmd, to be able to extract the "company name"
col...
when i do:
load data file '/foo/test.csv' into table abc.test (company name)";
You could load the data into several smaller tables and combine them
into a merged table which would have no real effect on the schema.
Ade
Simon Collins wrote:
I'm loading the data through the command below mysql -f -u root -p
enwiki < enwiki.sql
The version is MySQL 5.0.51a-community
I've
hat this is my own personal project, I've got a small amount of $$$
for your time!
Also, I apologize in advance if this is an inappropriate post for the list.
And if the list isn't the right place, let me know of a better place to
post!!
Thanks
-bruce
[EMAIL PROTECTED]
--
MySQL
Hi..
Fairly new to mysql, in particular tuning.
I have a test mysql db, on a test server. I've got a test app that runs on
multiple servers, with each test app, firing/accessing data from the central
db server.
the central server is on a 2GHz, 1GMem, 100G system. MySQL is the basic app.
the remo
Hi...
I have a situation where I want to periodically copy new rows from a source
database/tables on a remote server. Using a cron process, I'm looking to
periodically copy the new tbl/rows into the dest database on my local
server.
i don't want to get into implementing slave/master replication,
ryan...
mysql has the ability to set access rights to a given database/tables for
given users.
so it's easy to create a database, and to only allow a given set of users
access to the database. in fact, if you lock it down enough, only the user
with permissions will know the db exists... unless th
uldn't be set prior to the
row being created...
any more pointers/thoughts/...
thanks
-Original Message-
From: joe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 7:33 PM
To: 'bruce'; 'mysql list'
Subject: RE: trigger question..
create ta
hi.
using mysql 5.0.27 and playing with triggers.
a simple db:
create table foo{
aa varchar (10),
bb int auto_increment,
cc varchar (10),
} innondb
i'm trying to figure out how to create a trigger, such that if the user does
an insert into foo (cc) value ("www");
the table will concat the ww
hi...
i have the following test sql/schema. i'm trying to create a trigger that
would allow an item in tbl2 to be updated, based upon values from the tbl
that's being inserted into, and the value in a 2nd tbl.element.
the sql/schema:
/*
test schema for stratalight file project
#
# b douglas
#
#3
oh...
btw, also made sure the permissions are set on the /var/log/msql dir, and
the underlying files, as well as that the owner/group are 'mysql'...
thanks
-Original Message-----
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 08, 2007 5:39 PM
To: 'mysql li
in" in the my.cnf, allowing mysql to
write things to the "default" locations then everything starts as
expected...
thanks
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 08, 2007 1:49 PM
To: bruce
Subject: Re: log-bin
Bruce-
when l
hi...
i'm trying to run mysql on a fedora core 5, system to allow the log bin
files to be created.
i have the following my.cnf file:
---
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections=3
#log-error = /var/log/mysql_err.log
#set-var
to parse using grep...
thanks
-Original Message-
From: Alex Arul Lurthu [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 27, 2007 7:19 PM
To: bruce; mysql list
Subject: Re: "show slave staus"
You can set pager command to grep out unwanted fields.
On 11/28/07, bruce <[E
hi..
simple question!!
mysql> show slave status
returns a number of fields, with information on the status of the slave. is
there a way to only return the field(s) i'm interested in...
i thought that i had figured this out, but i can't recall, and it's been
awhile since i've played with this!
there an option/attribute for this.
thanks
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Baron Schwartz
Sent: Tuesday, November 27, 2007 6:50 AM
To: bruce
Cc: B. Keith Murphy; mysql list
Subject: Re: mysql replication
You can only do that in the my.cnf
from within the mysql cmd???
in fact, even if i only had a single master, but multiple dbs, i'd still
like to know this, given that i might not want to use the my.cnf file...
thanks
-Original Message-
From: B. Keith Murphy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 27, 2007
hi...
a quick question that i haven't found an answer to.
i can use "replicate-do-db=foo" in a my.cnf file for replication, to
replicate the master foo db on the slave. but this requires that i use/have
a my.cnf set on the slave.
is there a way to dynamically set this attribute/parameter within
hi..
doing a simple test of master/slave replication, using mysql.
i have two test systems:
master - foo (192.168.10.13)
slave - cat (192.168.20.20)
on both machines, i created a testmasterdb. on the master, i populated the
tbl within the db with some test data. there are no tbls in the sla
Hi...
I'm considering the following issue:
need to copy in db1 tbl_1 -> tbl_2
and in db2 cat -> dog
so i need to perform copies of both tbls in the two databases. and i need
them to both succeed, or to both be rolled back. the copies are in two
separate databases.
any thoughts on this...
t
Hi...
If I have a master/slave setup, I can do a "mysql>show slave status\G" and
get information on the overall status of the slave. Is there a way to break
out this information without having to parse the output? In other words, are
there other cmds that might provide the different pieces of info
-Original Message-
From: Dan Rogart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 14, 2007 1:07 PM
To: Mike Johnson; Baron Schwartz; bruce
Cc: mysql list
Subject: Re: MySQL - Replication (Master/Slave) Question
On 11/14/07 4:01 PM, "Mike Johnson" <[EMAIL PROTECTED]>
ible, can I get/see a sample my.cnf file illustrating
how this can be handled
thanks
-Original Message-
From: Dan Rogart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 14, 2007 1:07 PM
To: Mike Johnson; Baron Schwartz; bruce
Cc: mysql list
Subject: Re: MySQL - Replication (Master
Hi...
I have a number of servers that I want to treat as Master Servers or the
purpose of Replication..
I'd like to have each of the Master, have the Slave DB on the same machine.
Ie, a Slave server, might have 10 different Slave Databases/config files,
with each of the SlaveDB tied back to the M
Hi...
As I understand mysql, Innodb provides for row level locking, as opposed to
myIsam which does tbl level locking. Is this correct?
If I am correct, if I have a trigger on a Innodb tbl (foo), such that the
trigger then copies a row to another innodb tbl (cat), foo should only do a
lock of the
Hi...
I'm trying to get me head around a possible situation involving
locks/triggers.
Suppose I have two tables:
FooTBL
CatTBL
in FooTBL, I have a trigger that operates such that whenever a new row is
added to FooTBL, it's immeadiately copied to CatTBL.
I'm trying to understand what happens i
Hi.
I'm considering a situation where I have a number of child/client servers,
each of which are running local apps that feed into a local mysql db/tbl. In
order to manage the data, I want to copy all the mysql db/tbl data from the
chil/client systems, to a single central/master db.
I do not want
esses
that would update the parent system with the local client information.
thoughts/comments...
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Monday, November 05, 2007 9:55 AM
To: bruce
Cc: mysql@lists.mysql.com
Subject: Re: Replication - Master/Slave Issue...
Hi...
I have a situation where I'm looking at multiple child servers, each of
which has it's own mysql/DB/Tbls... I want to be able to have all the
information that exists in these tbls, to be captured, and copied to a
single parent TBL on a separate machine.
So, I'm trying to figure out what's t
you need to group the result sets by date, look at the manual link below:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
Richard Reina wrote:
I have a database table paycheck like this.
empno, date, gross, fed_with
1234 "2007-09-01" 1153.85 108.26
1323 "2007-09-01"
there should be no space between function name and () i.e. it should be
group_concat(hosts.name)
(unless you have the sql mode IGNORE_SPACE set)
Andrey Dmitriev wrote:
I knew I’ve seen this error before ☺
Thanks a lot.
-andrey
From: Peter Brawley [
one who might be, we ask
that you please pass this along!
Thanks for your time on this.
Bruce Douglas
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi
Multi-master replication is safely possible with MySQL 5.0 when they
introduced auto_increment_increment and auto_increment_offset
variables. Before this it was possible to run into problems with auto
increment columns generating non-unique numbers between servers. Try
the following link
hi...
i'm trying to determine if it's safe, or if there are pitfalls to running
simultaneous copies of mysql on a given server. assume that the instances
are completely separate, dirs/ports/etc...
can't really determine from the various information sources on the net.
-bruce
--
his awhile back, but i can't seem
to find any information on it now..
thanks
-bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
db the crawling app that i've killed had been writing to...
which is a less than elegant solution. i've looked at docs that talk about
master/slave replication/etc...
so.. i'm open to a discussion on the potential solutions to this kind of
scenario. keep in mind, i'm not a mysql dba/g
hi shawn...
mysql permits you to set/modify the number of simultaneous connections via
the my.cnf file
my assumption is that this is for all the databases for a mysql instance. is
this correct? also, what issues might one run into if you have multiple
copies of mysql running on a single server?
plish
this...??
so, for tom, i would return 'null', and for sue, i'd return '3' for the
'01/24/07' the date for the last '3' is later than the date for the last
'4'...
i imagine that there's a way to accomplish this using subselects.
any thoug
plish
this...??
so, for tom, i would return 'null', and for sue, i'd return '3' for the
'01/24/07' the date for the last '3' is later than the date for the last
'4'...
any thoughts/comments..
thanks
-bruce
--
MySQL General Mailing Li
me' (group) for when the tbl has an actionID=3 with a _date later than
the _date of the actionID=4
i've played with the inner 'select' but can't quite seem to get what i'm
looking for...
any thoughts/comments..
thanks
-bruce
--
MySQL General Mailing Li
s are in all versions of MySQL, I use MySQL
5.0. If your tables are big, you'll probably need to add an index on
universityID.
Hope that helps.
Donna
"bruce" <[EMAIL PROTECTED]>
01/04/2007 12:49 PM
Please respond to
<[EMAIL PROTECTED]>
To
"'Peter Bradley&
27;; mysql@lists.mysql.com
Subject: Re: group by/select issue..
Bruce,
Try:
SELECT DISTINCT NAME
FROM DOG
WHERE STATUS != 3
Should do the trick.
You obviously don't want the STATUS field. If you include it, you'll
get more than one line per name. Similarly for ID. If you want
eturn the
other status that aren't equal to '3' for the given name...
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 04, 2007 9:07 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: group by/select issue..
bruce wrote:
ed the
'name' (group) that do not have a status=2.
i'm not sure how to craft the select using the group by/distinct, and i
couldn't find examples via google to solve this...
once i get my hands around this, i can apply it to a test tbl of 2000-3000
rows...
thanks
bruce
--
My
hi...
i've asked something similar before.. but it appears something is going
wrong... so, back to basics...
i have the following test tbl.
dog
fooID int
size int
id int
dog
fooIDsizeid
1 2 1
2 5 2
1 5 3
if i do a query
select * from
: socket error
the file mysql.sock does not exist what I have to do?
- Original Message -
From: "bruce" <[EMAIL PROTECTED]>
To:
Sent: Thursday, December 21, 2006 4:35 PM
Subject: RE: socket error
> you might also need to check that the my.cnf file is configured to
> ref
you might also need to check that the my.cnf file is configured to reference
the sock file. additionally, you should check to make sure the mysql
app/daemon is even running. (this has bit me a few times when i've been
tired!!)
sample my.cnf file..
[EMAIL PROTECTED] ~]# cat /etc/my.cnf
[mysqld
add "LIMIT 2" to the end of the statement
goose wrote:
Hi All,
I have the following SQL statement
SELECT
channel.channel_name, program_title, start_time, finish_time
FROM
program, channel
WHERE
program.channel_id='3'
AND
program.channel_id=channel.channel_id
UNION
SELECT
channel.ch
Daniel Kasak wrote:
VeeJay wrote:
Hi
Where one can find Source Distribution of MySQL Server 5.0 Standard for
FreeBSD?
Not on the website, that's for sure.
Have you tried the usual warez sites, p2p networks, etc?
Actually the source tarball IS on the mysql download site.
--
One day at
Try dropping the indexes first if you can, would save you about half the
time and then re-build them after the dump finishes. Obviously you
would need to do it at a quite time though when the DB is not being
used. Is a binary backup not an option? at 29G is a large text file to
write
Ade
D
1 - 100 of 598 matches
Mail list logo
