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 cameron.mann at cybera.ca writes:
Hi all,
I've encountered a
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
!
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 correct initial database.
Jesus! I HATE systemd. The sysV init script handled this correctly
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:35 schrieb Bruce
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
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)
?
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
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
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
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
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
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
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
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
On Mon, Jan 16, 2012 at 1:52 PM, bruce badoug...@gmail.com 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 a
complete list
:08 PM, bruce wrote:
Hi Peter.
Not a mysql guru... so I've never used stored procedures/sub-queries..
But it sort of makes sense.
What I'm really trying to get is to be able to take a test table like
below
LOCK TABLES `parentChildTBL` WRITE;
/*!4 ALTER TABLE `parentChildTBL` DISABLE
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
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 records
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
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 Ferrellbferr...@baywinds.orgwrote:
On 09/08/2011 02:56 AM, Johan
On 09/08/2011 02:56 AM, Johan De Meersman wrote:
- Original Message -
From: Bruce Ferrellbferr...@baywinds.org
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
?
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 midnight the
= '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:
+--+---+--+-+--+-+-+
| id
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 -
The problem is that the index is useless, because you're running
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 918383
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
: Bruce Ferrell bferr...@baywinds.org
To: jeetendra.ran...@sampatti.com
Cc: mysql@lists.mysql.com
Sent: Thursday, October 15, 2009 12:20 PM
Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily
Have a look at mysqltuner. It reads the stats from a running mysql
instances
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
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
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
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
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 * 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
server. If you want to dump
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
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
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
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've looked at have 2 ISBN's - one
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,
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've
.
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 |+
| collegeID|+
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
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
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 processors, but I can
only see one
]
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/programming-and-development/?p=691
Under linux
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
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 General Mailing List
For list archives: http
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
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
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 www
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 table foo
(aa varchar(20),
id integer,
cc varchar(20
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
#
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
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 log-bin is enabled
log-bin = /var/log/mysql
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 list'
Subject: RE
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
is 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
???
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 6:31 AM
To: bruce; 'mysql list
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!
...
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 [EMAIL PROTECTED] wrote:
hi..
simple
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
Hi...
If I have a master/slave setup, I can do a mysqlshow 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
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...
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
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
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
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/Slave) Question
On 11/14/07 4
[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] wrote:
Correction to a couple of replies I've seen -- a slave
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
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
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
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
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
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/guru., just trying to solve this
issue.
thanks
-bruce
[EMAIL PROTECTED]
--
MySQL General Mailing List
, 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]
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
--
MySQL General
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?
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
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:
i'm trying to figure out how to create
: 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 to
include the STATUS or ID fields, then you
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' [EMAIL PROTECTED]
cc
'Chris White' [EMAIL PROTECTED], mysql@lists.mysql.com
Subject
RE
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 List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
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 List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
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 thoughts/comments..
thanks
-bruce
--
MySQL General Mailing List
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
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
: socket error
the file mysql.sock does not exist what I have to do?
- Original Message -
From: bruce [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
reference
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
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
1 - 100 of 586 matches
Mail list logo