, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
---
Peter Skipworth
Perl Developer/Unix Systems Administrator
[EMAIL PROTECTED]
+44 795 055 0029
---
4c
: http://lists.mysql.com/php/unsubscribe.php
--
---
Peter Skipworth
Perl Developer/Unix Systems Administrator
[EMAIL PROTECTED]
+44 795 055 0029
---
4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61
20 45 65
Like duh! =)
On Tue, 24 Apr 2001, Rene Tegel wrote:
RTFM=Read The Fucking Manual
now you know.
On Tue, 24 Apr 2001 21:37:44 +0100 (BST)
Peter Skipworth [EMAIL PROTECTED] wrote:
I for one vote to not bother with abbreviations from now on - let's just
spell it out loud and clear
: http://lists.mysql.com/php/unsubscribe.php
--
---
Peter Skipworth
Perl Developer/Unix Systems Administrator
[EMAIL PROTECTED]
+44 795 055 0029
---
4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61
20 45 65 62
recorded, event_time, uni_id) va |
---
Peter Skipworth Perl Developer/Unix Systems Administrator
[EMAIL PROTECTED]
+44 795 055 0029
---
4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61
20 45 65 62 4f 4c 47 6e
recorded, event_time, uni_id) va |
---
Peter Skipworth Perl Developer/Unix Systems Administrator
[EMAIL PROTECTED]
+44 795 055 0029
---
4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61
20 45 65 62 4f 4c 47 6e
.mysql.com/php/unsubscribe.php
--
-------
Peter Skipworth
Perl Developer/Unix Systems Administrator
[EMAIL PROTECTED]
+44 795 055 0029
---
4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61
20 45 65 62 4f 4c 47 6e 7
| 67 | Sending data | select
count(distinct(cookie)) from tbl_webevents where event_time =
from_unixtime(983833200) and e |
+--+--+---+--+-+--+--
--
---
Peter Skipworth
Perl Developer/Unix Systems
select * from blah where fieldname in (1,3,4)
On Thu, 12 Apr 2001, Jim
Zarvis wrote:
What is good clean sql syntax to accomplish the following with MySQL:
SELECT * FROM tablename WHERE value is in array of values
i.e. (psudocode)
Assume I have a field called ID in my table, and that I
**READ THE MANUAL BEFORE POSTING TO THE LIST**
http://www.mysql.com/docs
On Tue, 10 Apr 2001, Bruno Roselli wrote:
Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ?
mysql BEGIN;
Query OK, 0 rows affected (0.00 sec)
mysql UPDATE tabgral set codigo=2 where codigo=1
The error log in ~mysql/var should give you a hint as to your problem.
P
On
Fri, 6 Apr 2001, Franois Grenapin wrote:
I have a little matter for begin my server mysql...
When I want to connect to mysql, it happends that :
RROR 2002: Can't connect to local MySQL server through socket
Agreed - I'd love to be able to turn it on/off on demand.
regards,
P
On Fri, 6 Apr
2001, Tim Bunce wrote:
On Fri, Apr 06, 2001 at 12:13:22AM -0400, Thalis A. Kalfigopoulos wrote:
On Thu, 5 Apr 2001, Roel Vanhout wrote:
Hi all,
Is there a way to turn the query logging on and
Nicholas,
Is this anything to do with mysql ?
P
On Fri, 6 Apr 2001
[EMAIL PROTECTED] wrote:
Hi,
I am getting an error
c:\development\microsoft visual studio\vc98\include\excpt.h(37) : error
C2146: syntax error : missing ';' before identifier '_STDAFX_H'
c:\development\microsoft
It should work fine as printed...but you'll need mysql 3.23.xx
On Fri, 6
Apr 2001, Temeschinko, Michael wrote:
hi,
I need to make a select like above in the subject count distinct (I need the
count of the different values of a coloumn)
Hope you guys won't let me die silly!
:-)
I am not sure what you explained. You mean that place PATH/filename.jpg to
picture field. isn't it? If yes, it is just a text. How can we explore that
picture thru web browser such as IE or Netscape? Thanks for the answer
Your image would be in, say
That's it! One more like this and I'm unsubscribing - this is driving
me insane!!
P
On Thu, 5 Apr 2001, Water wrote:
Dear Webmaster,
Does your homepage address look long and difficult to remember like this:
http://www.myhomepage.com/entertainment/w/love/index.html?
Wouldn't you like it
I think William mentioned MS-SQL - as opposed to mysql - on the NT
box...
P
On Thu, 5 Apr 2001, Gerald Clark wrote:
Perl/DBI, or any mysql client on Linux should connect to mysql on NT
with no problem. Why would you need ODBC?
William Goedicke wrote:
Dear Y'all -
I've
Ouch! I don't know if many people would recommend this method - that's a
fair bit of unnecesary overhead to place ony our server...depending, of
course, on how often these images are created/modified/read.
P
Here's how I do b) in PHP:
1) Get the MIME type of the image.
2) Read the
I just had my mysql server go down - the processes still appeared to
be running, but were not accepting connections. The only entry in my
hostname.err log was as follows...
010404 11:12:07 Aborted connection 31 to db: 'unconnected'
user: 'root' host: `localhost' (Got an error writing
Eric,
Download the source tarball for mysql from the website and reinstall
using that - the necessary
include files do not come with the redhat rpm.
regads,
P
On Wed, 4 Apr 2001, Eric Fegraus wrote:
Hello,
I have redhat 7.0 with Mysql Ver 8.8 Distrib 3.23.22-beta. This was the
Mysql
I think what Kris needs answered is...
If mysql.a.com and mysql.b.com are two virtual hosts on the same
physical server, can
mysql -h mysql.a.com dbname
and
mysql -h mysql.b.com dbname
be differentiated. I'm fairly sure that mysqld has an option so that the
IP to bind to can be specified
Read the archives of this list.
P
On Fri, 30 Mar 2001, Sheikh wrote:
Respected Sir
i want to know how i store a image in mysql.i sue perl for scripting on linux.
please help me
thanks
allah hafiz
-
Before posting,
(I think) most people figure that the disadvantages of having images and
most other binary files stored within the DBMS far outweigh any
advantages. From the top of my head...
Advantages
--
- tidiness
- ease of backup - all data is in one respository.
Disadvantages
-
-
You do not need telnet to access a mysql server - mysql has it's own
client-server protocol, accessible via the means described by Jean-Claude.
regards,
P
On Tue, 27
Mar 2001, Chad Nielsen wrote:
Thanks Jean - Claude,
NT Workstation comes with a built-in client. but from what I can
Hi peeps,
I've got a table which is basically a log of traffic on one of my websites
- I have a seperate table per month, all of which are MERGED for queries
which need access to more than a month's worth of data.
select count(distinct cookie) as c,dayofmonth(event_time) as d from
All you need is a single SQL function - have a look in the docs.
On Fri, 23
Mar 2001, roger westin wrote:
Hi,
Anyone got a small script to store a file in a BLOB.
Nothing fancy, just so that I dont need to think that much today.
/roger
Bryan,
You've given no indication of what "this structure" is - the fact that
your data is rarely read or updated will have little bearing on whether
an RDBMS is suitable for your needs. It would be a very rare case,
however, where a simple flat text file gave you quicker access to a search
of a
Strictly speaking, they're not unique - there's a lot of many to one
mappings- eg my work email address and my home email address - and a
hell of a lot of one to many mappings - ie [EMAIL PROTECTED] As long
as you're happy with that, most people end up being happy assuming that
a user's email
If you're looking for PAM modules that authenticate from a mySQL
database, I know they exist - although I can't comment on them as I
haven't used them before.
regards,
P
On Tue, 13 Mar 2001, Roberto Meyer wrote:
Hi,
We're trying to "unify" the authentication system in our Linux.
PAM is
Since upgrading to mysql 3.23 and using MYIAM tables, I'm experiencing a
problem which is becoming more and more common. When conducting queries
which take more than about 15 seconds to run (ie mass deletes, mysqldumps,
check table etc), I end up with corrupt tables. The database server is the
Jamie,
mySQL doesn't support triggers, and you'd need them (or a stored
procedure). Surely you could just set both A and B explicitly in your
application logic to the same value though ? Or am I missing your point
?
P
On Fri, 9 Mar 2001, Jamie S Buchanan wrote:
Hello all,
I'm a third year
Antione,
What's your definition of a week number ? A week number in the range
1..52 is not in itself enough to calculate a precise date from..
regards,
P
On Thu, 8
Mar 2001, Adams, Antoine A SSI-ISES-56 wrote:
I've been strugling with a query for some time now and I can't get the
desired
fulltext is now a reserved word - either change the name of the field,
or use quotes when refering to it.
regards,
P
On Tue, 6 Mar 2001
[EMAIL PROTECTED] wrote:
Hi! I just upgraded from 3.22.26a to 3.23.33. We've got a database
that has a table that has a column with the name:
Sounds like it installed to a different directory than the previous
version - try
/usr/local/bin/mysqld --version
or
/usr/local/mysql/bin/mysqld --version
It would be a good idea to remove any previous binaries to avoid
confusion, as well.
Cheers,
P
On Wed, 7 Mar 2001, Cal Evans wrote:
I
Edd,
mySQL, like any other RDBMS, does (and can not) not insert data in a
guaranteed order into a table. While mySQL might usually insert the most
recent record "last" in a table, you should never rely upon the fact.
Refusing to sort your data on the basis of system load sounds a little
strange
select Name,Income,Out,(Income-Out) as Balance from tblname
On Mon, 26 Feb
2001 [EMAIL PROTECTED] wrote:
Dear all,
Sorry to ask question again, or maybe i am just a beginner.
I wanna ask:
If there are 2 records
Name Income Out
Data1 1000 700
Data2
As far as I know, this is on the wishlist, but has not been implemented
- ie, a thread should die if the client disconnects. You'll probably
need to run mysqladmin kill xxx, where is the offending thread id.
regards,
P
On
26 Feb 2001 [EMAIL PROTECTED] wrote:
Hi Everybody,
I am a
Oh...
Isn't ModAuthMySQL used for HTTP authentication against a mysql database
? I can't see how that could influence queries running from within a
mod_perl/CGI script...
P
On Mon, 26 Feb 2001, Simon Green wrote:
Hi there Kiran
We had the same problme and we found that updating
How is this superior to SQL?
It includes the letters "XML", which, apparantly, can do everything from
butter your toast to giving you an orgasm like no other you've had
before. Don't you just *love* buzzwords!
Sorry...I had to say it =) And no, I'm not at all the cynical type...not
I!
P
Why
Sorry for going slightly off-topic...I realise this is more a Perl
question , but suspect someone here might know the answer.
I'm halfway through writing a module (it's at alpha stage) to cache
mysql/DBI query results, either within RAM using shared memory or to disk
using Storable. Testing
Agreed
I generally set aside a directory for any images, etc, per table, and
simply save any images as [primary_key].jpg. That way you can write
simple GetImage([table_name], [primary_key]) functions to return the
location/URL of the matching image.
regards,
P
On Fri, 23 Feb 2001, Mikel
Look up "repair table" in the on-line manual.
regards,
P
On Fri, 23 Feb 2001, Hardy
Merrill wrote:
In the 3.23 news article, at the bottom it says this:
Online Table Maintenance
MySQL 3.23 now incorporates many of the table maintanence
features of the (previously
Matt,
Before posting to a mailing list, you should ensure you RTFM!
Have a look at www.mysql.com and you'll find tha answers in the
documentation.
regards,
P
On Thu, 22
Feb 2001, Matt Davis wrote:
Hi Can anybody tell me what the maximum number of characters I can have in
one field.
I'd heard that even in general use, some users had a noticeable increase
in disk reads/writes under ReiserFS...it sounds like you haven't
experienced this (?). I'm thinking about moving over to ReiserFS as well,
shortly, and am looking for as much feedback from people using it as
possible...
check your error log in ~mysql/var
On Thu, 22 Feb 2001, Matthew P. Marino
wrote:
exact command is "./safe_mysqld --user=mysql ". The error "010222 17:25:00
mysqld ended" happens immediately.
-
Before posting, please
Can you just not use...
...WHERE myDateField '1997-10-04 22:23:00'
...WHERE myDateField '1997-10-04'
?
regards,
P
You get the idea... thoughts?
Best,
Nick
-
Before posting, please check:
Hi all,
All of a sudden, some of my data (originating from a web form) is showing
content such as the following...
Sailing Windsurfing Instructor #8211; training
given-(Mediterranean Coast)This is a fantastic opportunity to work
for the UK#8217;s leading children#8217;s adventure
XML is all about data definition - not being able to dynamically
change the display of the data on a webpage. Browsers don't even
understand XML natively - you need to write it out as HTML before you can
display it in IE or Netscape.
P
On Sat, 17 Feb 2001, Siim Einfeldt aka Itpunk wrote:
select if(columnname now(), "future", "past") from tblname
On Fri, 16 Feb
2001, Vyacheslav Chukin wrote:
Please, tell me,
how could I determine,
which one of two datetime values is greater?
In other words,
how could I determine,
is stored on db datetime value in future or past?
mysqladmin create newdatabasename
mysqldump olddatabasename | mysql newdatabasename
Of course you'll need the usual username/password parameters as well.
On Thu, 15 Feb 2001, Joe
Ferrara wrote:
I want to make an exact duplicate (differenet name) of my entire DB for
test purposes. My DB
Save to a CSV (comma-delimited file) from Excel, and take a look at the
"load data infile..." command within the mysql documentation.
regards,
P
On
Thu, 15 Feb 2001, Joe Ferrara wrote:
I am not a Perl Guru. How would I set up this environment? Or is there
another way to go from excel
While the output you've shown could well be considered eroneous, surely
you shouldn't be relying on this sort of logic in a decent piece of code
? Or am I missing something ?
If you're trying to work out which row was inserted most recently,
shouldn't you be using your db handle lastinsert_id
As of 3.23.xx, WHEN is a reserved word.
regards,
P
On Thu, 8 Feb 2001, Andy Woolley
wrote:
Hi All,
Does anyone know if a field called WHEN could cause trouble with queries?
Many Thanks
Andy Woolley
www.databasewatch.com
Take your pic - personally, I usually use a tinyint, and assign a 0 or 1
- I suspect the options you describe would work just as well.
regards,
P
On Tue, 6 Feb
2001, John Halladay wrote:
If I am using MS Access and linking to tables in MySQL through MyODBC, what
is the equivalent format of
Nope...
It's stated explicitly in the docs that this is a *Bad Idea* (with caps,
even! *grin*). You'll need to look at other options - replication,
possibly, either on to the same machine with your db on a different
drive, or (probably preferable) onto a seperate box.
regards,
P
On Tue, 6
55 matches
Mail list logo