between formats, e.g. (taking the above value),
date -d "@1409304102.153" "+%Y-%m-%d %a %H:%M:%S.%N"
2014-08-29 Fri 04:21:42.15300
--Phil
--
Philip Amadeo Saeli
openSUSE, CentOS, RHEL
psa...@zorodyne.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
#x27;s a big difference in experience. But
>>> someone who's done 100 vs. someone who's done 50 the difference in
>>> experience is not so great as they are both near the top of the learning
>>> curve. In essence number of jobs becomes less and less of a con
On 28 Oct 2010, at 18:45, Paul DuBois wrote:
>
> On Oct 26, 2010, at 6:31 AM, Philip Riebold wrote:
>
>>
>> On 26 Oct 2010, at 11:49, MikeB wrote:
>>
>>> I'm finding the MySQL online manuals hard going in figuring out how to
>>> construc
MySQL, The definitive guide to using, programming,
and administering MySQL 4.1 and 5.0' ISBN 0-672-32673-6 (there may be a more
recent version).
Well written, with a general introduction to SQL and (from my POV) very good
sections on writing MySQL with C and PHP
--
TTFN.
Philip Riebold, p.r
On 20 Aug 2010, at 16:24, Bryan Cantwell wrote:
> Yes, but I DON'T want eh spikes smoothed out
Display the max and min of each successive set of 10 (or 100 or 1000) elements
from the data ?
--
TTFN.
Philip Riebold, p.rieb...@ucl.ac.uk
--
MySQL General Mailing List
For list archiv
...
(Note the bzip2 in the pipeline. This reduces the size of the files by a
factor of between 5-8.)
It's certainly more than fast enough for my needs. I suspect most of the
time is taken up by mysqldmp and writing the ouput to the external media.
--
TTFN
Philip Riebold, p.rieb...
Andy Shellam wrote:
Am I missing something here? (It is late after a long day, I admit!)
Only something I forgot to mention.
All the foreign keys are set up as ON DELETE RESTRICT, meaning MySQL's
response to a foreign key violation is to spit out an error message to the
effect of "I'm sorry
Hi,
First of all, I apologise in advance for any mind-altering, or
headache-inducing effects this question may have. I've spent the past two days
trying to figure it out, and all I've got to show for it is a mostly-working
recursive depth-first-search routine and an empty packet of painkiller
> 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 <
body help please ?
TTFN,
Philip Riebold, [EMAIL PROTECTED] /"\
Media Services\ /
University College London X ASCII Ribbon Campaign
Windeyer Building, 46 Cleveland Street/ \ Against HTML Mail
London, W1T 4JF
+44 (
[take 2]
--
Philip M. Gollucci ([EMAIL PROTECTED])
o:703.549.2050x206
Senior System Admin - Riderway, Inc.
http://riderway.com / http://ridecharge.com
1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70 3F8C 75B8 8FFB DB9B 8C1C
Work
le_id)
- --
-
Philip M. Gollucci ([EMAIL PROTECTED])
o:703.549.2050x206
Senior System Admin - Riderway, Inc.
http://riderway.com / http://ridecharge.com
1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70 3F8C 75B8 8FFB DB9B 8C1C
Work like you don't need the money,
love like you'll never get
IED BY 'X'
obviously this doesn't work as there is no grant defined like that.
I'm trying to avoid doing something that I have to update everytime a table is
added/deleted.
- --
-
Philip M. Gollucci
Hi, all,
I had a server crash a few weeks ago and had to
restore my mySQL installation from backup after
reinstalling Fedora.
After the restore operation, I was no longer able to
log into mySQL, either as root or as myself. I believe
this may be because the UID in the recovered database
is now di
ome unavailable (ie. crash or refuse connections) ?
TTFN,
Philip Riebold, [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
My slave server isn't nearby, but...
show status like '%threads%';
will return just the results from "show status" that match on "threads".
Might work for slave status as well.
-philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.
I have a table that has a column with the id of the person that created the
row. In another column in the same row there is a column with the id of the
person that modified that row.
Is there a way to write a SELECT statement that will return all the rows
where the value in the creation colum
says it's not quite there (auto splitting
reads/writes).
http://forge.mysql.com/wiki/MySQL_Proxy_FAQ#In_load_balancing.2C_how_can_I_separate_reads_from_writes.3F
Will be nice once it is though!
-philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
1) Do you use a load-balancer for your MySQL Deployment?
Yes. Well, up till just a little while ago...
2) What load-balancer (product name) do you use for your MySQL Deployment?
We used to run MySQL's NDB Cluster behind a hardware load balancer (don't
remember the name, but it's not that re
Reading How AUTO_INCREMENT Handling Works in InnoDB[1] makes me
wonder how is it possible to replicate AUTO_INCREMENTed value to slaves.
According to the doc,
"If you specify an AUTO_INCREMENT column for an InnoDB table, the
table handle in the InnoDB data dictionary contains a special counter
c
[take 2]
Nobody has any comments ?
-- Forwarded message --
Date: Wed, 26 Sep 2007 12:19:21 -0400 (EDT)
From: Philip M. Gollucci <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: Crystal Reports XI on W2k3 Server SP2 x64
Hi All,
I'm trying to get Crystal Reports
ogling, I have a hunch they are right but I can't fathom why.
--
--------
Philip M. Gollucci ([EMAIL PROTECTED]) 323.219.4708
Senior System Admin - Riderway, Inc. http://riderway.com
1024D/EC88A0BF 0DE5 C55C 6BF3 B235 2DAB B89E 1
$result= mysql_query("SELECT date_format(date, '%d/%m/%Y') as date, title,
id, display FROM news ORDER BY date DESC ");
I have the query above the problem is oders them like so
30/05/2007
29/07/2007
25/0/2007
The order is taken by the first number. Is there any way to order them
properly wit
Not being very strong at math, I have a little problem that I'm not sure how
to solve. Maybe someone can help me.
Basically, given a point (latitude, longitude) and a radius (100 meters)
(think circle), I need to compute an equivalent square: That is, two points
that would correspond to two co
Hello,
I have several tables storing item information, keyword (mainly for searching),
category and subcategory (also for searching). The query I am using now is:
SELECT i.*, it.*, ic.*, c.*, cs.*, s.*, st.* FROM item i
LEFT JOIN iteminfo it ON i.id = it.id
LEFT JOIN itemkeyword ik ON i.id = ik
Naz,
Without going into detail about various projects I've seen, surfice it to
say that I have wittnessed some true horrors. In defence however, the
largest abomination I have ever witnessed was from an MS shop that had grown
a database from a MS Access system upward and had then, bluntly bolted
Afternoon everyone,
Not been on here for a while, works been to hectic and this thing called
life keeps getting in the way ;^)
--
Regards,
Phil
Afternoon everyone,
Sorry, don't you hate the fact that the tab key submits your emails on
web clients!?
Anyway please ignore that last partial email, I've got myself stuck with
some SQL. What it boils down to is...
SELECT
wordgroup.Title AS `Keyword Group`,
site.Site_name AS Site,
que
Maybe this is some SQL standard implementation and that's why it is what it
is, but to me it seems completely retarded that you have to explicitly call
out the columns...
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
Why doesn't it work in a more convenient and sane way?!
So i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Neil,
The short answer is probably "merge the two databases manually and
rebuild the index". I don't think there's any real answer otherwise.
Given the old version of MySQL you aren't going to be able to do
anything fancy like federating the two t
e a lot faster to do something like:
rowcount = select count(*) from table
random_value = something between 0 and rowcount - 1
select ... LIMIT 1 OFFSET random_value
-philip
And what about when there is a combination of tables
SELECT a.a, b.b FROM a,b WHERE a.b = b.id ORDER BY RAND() LIMIT 1
Marten
In more recent version you can do a simple...
SELECT ENGINE FROM TABLES WHERE TABLE_SCHEMA = "{database name}" AND
TABLE_NAME = "{table name}";
...dunno how you'd do it on older versions exactly, you can do...
SHOW TABLE STATUS WHERE Name = "BID_UNIQUE_IDS";
...but you can't sel
Marten
In more recent version you can do a simple...
SELECT ENGINE FROM TABLES WHERE TABLE_SCHEMA = "{database name}" AND
TABLE_NAME = "{table name}";
...dunno how you'd do it on older versions exactly, you can do...
SHOW TABLE STATUS WHERE Name = "BID_UNIQUE_IDS";
...but you can't sel
Guys,
I doubt I'd qualify as an expert but here's my two pence worth ( ;^)
)I wrote a search engine a while back that relies heavily on full-text
searching and the three things I found that improved results were...
1) Precisely what Dan explains, doing extra biasing per field in the SQL
wi
o "backlog_test" with ease :-). Any sexy suggetions? :-)
This is what I do...
mysqldump -v --lock-tables=false backlog | mysql backlog_test
Not practical if your dataset is huge, but if it's not that big, works
great.
-philip
--
MySQL General Mailing List
For list archives: h
Jan,
In English I pronounce them as...
My-eye-sam
In-oh-dee-bee
...respectively.
Regards,
Phil
2007/1/7, js <[EMAIL PROTECTED]>:
Hi list,
Sorry for this silly question but I've been always had trouble
pronouncing "MyISAM" and InnoDB.
How do you pronunce them?
Thanks in advance.
When
Mohsen,
Philip Mather wrote:
Mohsen,
First off, what version of MySQL are you running and on what
platform?
Now when i use --skip-grant-tables i can see my databases.
Please help me...
When you use MySQL via a shell I would assume you're logging in as
root? You also say you can only
hough, what should I pay attention to when selecting the
file system
Thanks
Olaf
On 12/29/06 11:31 AM, "Philip Mather" <[EMAIL PROTECTED]> wrote:
Olaf,
Thanks for the detailed answer.
So basically the limitations come from the OS and the file system used.
What is t
Servers24,
Hi Philip,
Thank you very much for your help.
Can you please tell me the differemce between COUNT(*) and COUNT(id) ?
Thanks again.
Actually sorry I was a bit misleading there. MySQL is optimized to
calculate...
SELECT COUNT(*) FROM aTable;
...but given the fact you've
Olaf,
Thanks for the detailed answer.
So basically the limitations come from the OS and the file system used.
What is the best file system to use for mysql (not considering the filesize
limitations)?
Thanks
Olaf
The "best" is probably ZFS if you really are intent on make things huge,
http:/
Servers24,
Well this question may seem funny...
No, a funny question would start something like "Why did the nun cross
the road?". ;^)
The problem is with counting a user's contribution in my site. Suppose
that
each user that send an email will be stored in DB. Now I want to count
number of
Mohsen,
I'm not sure you're receiving any of this as you also seem to have a
rather over-eager spam filter as well...
"
Symantec Mail Security detected prohibited content in a message sent from your
address (SYM:40763633734165155763)
Subject of the message: Re: MySQL & My program
Recipient
Mohsen,
First off, what version of MySQL are you running and on what platform?
Now when i use --skip-grant-tables i can see my databases.
Please help me...
When you use MySQL via a shell I would assume you're logging in as root?
You also say you can only see a "test" database, can you not see
Mohsen,
First off, what version of MySQL are you running and on what platform?
Now when i use --skip-grant-tables i can see my databases.
Please help me...
When you use MySQL via a shell I would assume you're logging in as root?
You also say you can only see a "test" database, can you not see
Kevin Old wrote:
On 12/8/06, Philip Mather <[EMAIL PROTECTED]> wrote:
So something like 15G, that's not that bad. I'd run mtop as someone
suggested and see if some query is hammering it, maybe some other
process on the machine is hogging or going IO bound?
Thanks. We
mos,
I'm looking for a free, perhaps open source, case tool for MySQL 5.x.
(Older MySQL 4.0 case tools may not work because of the changes to pw
security in 4.1 and later)
I tried MySQL Workbench 1.1.5 alpha but I keep getting errors "The
following error occurred while launching the object ed
[EMAIL PROTECTED] wrote:
Hi,
How much memory do you have on your system ? (the current setting in your
my.cnf could eat *a lot* of memory)
min_memory_needed = global_buffers + (thread_buffers * max_connections)
thread_buffers
---+-
sort_buffer_size
Chris,
On Thursday 07 December 2006 16:34, Ed Reed wrote:
Thanks for the quick reply Chris.
It's close but it's a little off. Your example also returns all
instances that where the letter N exists in another words as well
SELECT SUBSTRING(value,2) as value_num, value FROM num_test WHE
Has anyone here seen any software (preferably PHP and Open Source)
that connects to MySQL and allows people to build/design/modify
databases and tables?
I'm not really looking for something like DBDesigner or phpMyAdmin
although their close/similar to want I want, I'd like something more
or
[EMAIL PROTECTED],
hi,
i'm created a 'configuration' table:
create cofiguration (
config_key VARCHAR(25) NOT NULL PRIMARY KEY,
config_value VARCHAR(255) NOT NULL
) ENGINE=MyISAM;
I have about 30 records (store_name, store_owner, template_name,
website_width, owner_address, prodcuts_per_page,..
Kieran,
Just make a backup of the database to a file using mysqldump and then
drop the database. If you need to recreate it again in the future, you
can use the mysqldump backup file.
Oh indeed, but if you got a "x"GB database that's not exactly going to
be quick. I'm thinking of instead of sl
Dan,
In the last episode (Nov 22), Alfred Mak said:
Can I shutdown one of the databases in MySQL but not the whole mysqld
process (i.e. keeping the other databases still running) ?
"shutdown" would be the wrong word then :) How about revoking
permissions (either at the mysql or the fi
I can't find how to handle B.C. dates. I am not concerned about the
Julian to Gregorian cutover issue, and I simply need to be able to
represent dates such as the birth and death of Aristotle, 384-322 B.C..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
Leandro Guimarães Faria Corcete DUTRA wrote:
On Wed, 08 Nov 2006 18:51:20 -0800, Rares Vernica wrote:
Is it possible to access the Full-Text Index structures from SQL?
What do you mean exactly? SQL is not intended for physical structures.
I started writing a little
Jerry,
Is "9640" a word by itself? A full-text search wouldn't find "abc9640",
No a full text search would find numbers pretending to be a "word", the
full text search has a fairly high level definition of a "word". Try
searching for "1960" over at http://ftvdb.bfi.org.uk/search.php.
Regar
Jerry,
Is "9640" a word by itself? A full-text search wouldn't find "abc9640",
No a full text search would find numbers pretending to be a "word", the
full text search has a fairly high level definition of a "word". Try
searching for "1960" over at http://ftvdb.bfi.org.uk/search.php.
Regar
Warren Young wrote:
Paul Warner wrote:
When a user enters text with a £ sign (Great Britain Pound) in the
browser and clicks enter, any insert or update statement apparently
gets truncated in mysql.
It's possible that somewhere along the line, the character is getting
translated to a multiby
Warren Young wrote:
Paul Warner wrote:
When a user enters text with a £ sign (Great Britain Pound) in the
browser and clicks enter, any insert or update statement apparently
gets truncated in mysql.
It's possible that somewhere along the line, the character is getting
translated to a multiby
llion row limit of that table?
Interestingly I can't file a file limit mentioned for XFS, if it's
2^24 that's only 16.7 million. How about we leave it at "lots".
What Philip is saying is that you might run into problems with one of
the tables used to keep track of t
John,
How many databases does a single instance of MySQL Server 5.x support?
I suspect you'll get a bit of a , with a 64bit machine there's
a limit of 4.2 billion rows per table and with an XFS file system 8EB
per table, there's a join limit specified somewhere but I don't think
there's an
List,
Without getting into the specific problem the general debug path I'd
follow would be: -
1. Make sure you are actually connected to the database, you say it's
the admin area? Does the admin area login with different details? try
eching the result of a "select NOW()" right at the start
Kerry,
It gives me a solution and some reading.
No probs, here's some actual code that I hacked together on a
4.1-sommat-or-other database, an important thing to note is to be
careful of any Unique keys selected from the three individual tables as
they may no longer be unique of course once
nd
simply have "foo_staging" and "foo_development" databases?
Unless you are tweaking server parameters, this should work just fine...
-philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ravi,
Knight 4 to Pawn's 5!
Sorry, being serious for a minute, you'd need more info to solve
this problem. Your example implies that something without a number after
it still counts for a value of 1, i.e.
> and 3 if I am searching for WT.
Correct? What is the extent of the two letter co
Philip Hallstrom wrote:
Hi all, a though query problem for me...
I have a table with 2 rows that matter: url and id
If url and id are the same in 2 rows, then that's no good (bad data).
I need to find all the rows that are duplicates. I can't think of how
to approach the sql for
Hi all, a though query problem for me...
I have a table with 2 rows that matter: url and id
If url and id are the same in 2 rows, then that's no good (bad data).
I need to find all the rows that are duplicates. I can't think of how
to approach the sql for this.. any pointers?
Select COUNT(*)
I would also try to unorder the email addresses, so that large groups of
yahoo and aol etc emails do not hit the outbound queue at the same time.
They tend to look down on that activity, and throttle you back, making it
take even longer to get your messages out.
You might put special-case condit
Again, I know this is not necessarily a MySQL specific question, and sorry
for getting off target, but this is a pretty smart and experienced bunch, and
I'm sure that someone out there will be able to help me.
We have a web application in which we have a mass e-mail function. It allows
the us
What else would prevent queries from getting into the cache?
Anything with NOW() in it or any of it's related functions...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ng coordinates.
Once you have the lat/long you can do the math easily...
Not sure if they have a zip code only version... but the one we bought was
like $30 and works just fine...
-philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hat cluster can only do operations in batches of about
30,000 rows at a time. So, if that import is using extended inserts
(typical if it's a mysqldump output) it won't work. You need to insert
them in batches of no more than 30,000....
-philip
--
MySQL General Mailing List
For list a
On 8/15/06, Visolve DB TEAM <[EMAIL PROTECTED]> wrote:
Hello William
Try the below Query to insert next maximum value of the field into same
table
INSERT INTO Sample(id) SELECT MAX(id)+1 FROM Sample
Wooww it works :D ... i didn't know that... great !
Wouldn't this cause a problem if
I want to design a database for lots of users. Each user will be managing
their own messages. Does it make sense to create a table for each user after
they've registered?
Or should I just create one MESSAGES table and store messages there keyed off
of their user_id?
If I create a table for e
Brent,
Given that...
You really have to match cardinality with distribution of values.
...sounds like hard work (well you actually have to think about it) and...
considering all the above cases, what should I conclude? should I have
indexes on these three fields?
Looking for a specific answe
Bruce,
i had initially thought that i could have the following tbl structure:
UniversityTBL (
name
ID auto_increment,
)
In a generic kinda "Best Practice", things I've picked up from various
places way I'd recommend the following things: -
1) The first field always be the Primary Key an
Though I understand very well that it has been discussed lots of time
before but I don't have time to browse through the previous archives
and dig out the stuff I need. So, guys, I would be thankful if you
could give me your valuable advice that I need right now.
I just need to know
I've found something that works (in MySQL 5, anyway), but I don't know
whether it's accepted practice.
If I want to find all records with a date in, say, March 2006, it works if I
use "datefield like '2006-03%'" because it's a string.
This seems kind of obvious and a lot tidier than doing "da
?
--
Philip M. Gollucci ([EMAIL PROTECTED]) 323.219.4708
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Software Engineer - TicketMaster - http://ticketmaster.com
1024D/A79997FA F357 0FDD 2301 6296 690F 6A47 D55A 7172 A799 97F
"It takes a minute to have a crush on so
his unless I break up all my models
into ReadModel and WriteModel which defeats the whole purpose.
Any ideas?
Thanks!
-philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Just want to share and confirm my findings on a performance issue I've been
experiencing.
My database is strictly non-transactional, but it's got about 200,000 records
in this particular table. The table has a primary index, and 2 integers - one
for the date and the other for the time. Among t
Hi there,
I am in the midst of creating a forums hosting site.
1. It has to be highly scalable, so I doubt a single MYSQL db with TONS of
"subforums that simulate full forums" would do.
2. Also regarding scalablity, I hope to "Add capacity" as and when its
needed. So i'll have one server runn
Thanks to everyone's help. Instead of downgrading MySQL, I went ahead
and upgraded to PHP5. After I did that, it seemed to fix the
connection issue I was having.
~Philip
On Jan 30, 2006, at 4:41 AM, James Harvard wrote:
MySQL versions >= 4.1 use a new, more secure authen
PHP to version 5,
would that help me?
Does anyone have any suggestions on the direction I should go?
Thanks in advance,
~Philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all.
I am having some troubles with what should be contained within my
my.cnf file. Would a few of you be willing to show me what yours
consists of?
Thanks,
~Philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
On Jan 24, 2006, at 5:13 AM, James Harvard wrote:
Is there a reason why you're using Darwin Ports and not the
installer that MySQL offers?
James Harvard
Yes. I tried the installer multiple times and it would not work. I
got so fed up with it that I decided to give DP a chance. So far,
ne
ul. I have also searched archives on Darwin
Ports and found some similar problems, but nothing that
completely helps!
Sorry for my *newbness*! Please help me! =D
~Philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
>>I pretty much have no idea how I can do this without nested queries (and
>>to be frank not even how to do it with them) so I'd really appreciate
>>any help!
>
>
>>kind regards Philip
>
>
> Try this as a starting po
ething I'd like to avoid.
I pretty much have no idea how I can do this without nested queries (and
to be frank not even how to do it with them) so I'd really appreciate
any help!
kind regards Philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
look for information on the SMTP appender.
Cheers,
Philip.
-Original Message-
From: Jayson [mailto:[EMAIL PROTECTED]
Sent: May 31, 2005 6:59 AM
To: mysql@lists.mysql.com
Subject: email notification
I'm looking for a feature in mysql where it will email me if ther are
any changes
On May 30, 2005, at 1:28 AM, [EMAIL PROTECTED] wrote:
you can just play :
set @total:=0;
select name,price,quantity, price*quantity as
subtotal,@total:[EMAIL PROTECTED]
from fruits;
select @total as "grand total";
works great. thanks very, very much.
- philip
code at
runtime after selecting all the pertinent data.
thanks though. :)
- philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the
poster was actually talking about the privileges of the enclosing
folder, not the socket itself. my bad.
but, regardless, i think it's a path problem anyway, as i mentioned
earlier.
pardon the misfire. running on zero sleep.
- philip
--
MySQL General Mailing List
For
e in some weird place that php won't
find. also, make sure there's a mysql directory in /var of course.
- philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:
chown mysql:wheel /tmp/mysql.sock
chmod 4777 /tmp/mysql.sock
- philip
On May 29, 2005, at 12:33 PM, Philip George wrote:
try looking at these two pages:
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/connecting-disconnecting.html
search them
try looking at these two pages:
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/connecting-disconnecting.html
search them both for '2002' (multiple instances on one of the pages).
there a couple suggestions for things to try.
hth.
- philip
actually, i've decided this is sort of a moot point, since i can do
this calculation in the client app.
no sql required.
thanks.
- philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 | orange | 0.97 | 0.97 |
|3 | pear | 1.09 | 3.27 |
|3 | pear | 1.09 | NULL |
+--++---+--+
the NULL is in the wrong column. where is my mistake?
thanks, jochem.
- philip
--
MySQL General Mailing List
For list archives: http://lis
-- that are used with a join on
that page.
that's why i mentioned the join. sorry. i should have been more clear.
- philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On May 29, 2005, at 1:41 AM, Jochem van Dieten wrote:
http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
already read that. the join in my example is more complicated than
anything depicted on that page.
please explain.
- philip
--
MySQL General Mailing List
For list archives
x27;ve tried with no success to use SUM() to do this.
would i even use SUM()?
if i could refer to the resultant table above in a subsequent select,
that would be ideal. is there a way to do that (something like select
SUM(@@result.subtotal);)?
thanks.
- philip
On May 28, 2005, a
1 - 100 of 346 matches
Mail list logo
