-
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> T
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 n
-
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble un
request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
--
---
Peter Skipworth
Perl Developer/Unix Systems Administrato
o request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
--
---
Peter Skipworth
Perl Developer/Unix Systems Administrator
uest this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
--
---
Peter Skipworth
Perl Developer/Unix Systems Administrator
event_type, user_type,
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
event_type, user_type,
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
--+
| 7568 | hot | localhost | hot | Query | 67 | Sending data | select
count(distinct(cookie)) from tbl_webevents where event_time >=
from_unixtime(983833200) and e |
+--+--+---+--+-+--+--
--
----
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 t
**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 cod
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!
> :-)
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\micr
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 logg
The error log in ~mysql/var should give you a hint as to your problem.
P
On
Fri, 6 Apr 2001, François 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
> '/
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 -
> >
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 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
/usr/local/apache/htmldoc/images/simpleto
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
> M
mysql --username=xxx --password=xxx -e "SELECT * INTO OUTFILE
"/root/cTable-data.dump" FIELDS TERMINATED BY ',' ENCLOSED BY '"' FROM cTable WHERE
myfield='1'" dbname
On Wed, 4 Apr 2001, James
Salinas wrote:
> Hi,
>
> My problem is specifically concerning syntax for mysqldump.
> I can succe
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 commun
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 b
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 to
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 post
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 te
(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
-
- DB
This may help - I use 'htmldoc' from easysw.com to convert from HTML to
Postscript - it means I can write reports etc in HTML and them simply
convert them to GS and throw them at the printer. htmldoc adds a couple
of custom HTML tags which you can add to your HTML, including a page break
tag, whic
Thanks heaps...as long as I can use distinct(count..)), i'm happy going
back to .33 :)
Cheers!
P
On Mon, 26 Mar 2001, Fred van Engen wrote:
> Hi Peter,
>
> On Mon, Mar 26, 2001 at 04:30:43PM +0100, Peter Skipworth wrote:
> > Eeps...I'm running 3.23.35..I gather you&
; was added ? I
know it didn't used to work, but I thought I'd try it again this morning
and lo and behold, it was supported...
Cheers,
P
On Mon, 26 Mar 2001, Fred
van Engen wrote:
> Hi Peter,
>
> On Mon, Mar 26, 2001 at 03:04:29PM +0100, Peter Skipworth wrote:
> >
l of this on a dev
server!
On Mon, 26 Mar 2001, Fred
van Engen wrote:
> Hi Peter,
>
> On Mon, Mar 26, 2001 at 12:20:14PM +0100, Peter Skipworth wrote:
> > I've got a table which is basically a log of traffic on one of my websites
> > - I have a seperate table per month
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
tbl_webevents
Try copying your .MYD and .frm files to a directory and running 'restore
table [tablename] from '/this/directory'
regards,
P
On Fri, 23 Mar 2001, Carsten
Gehling wrote:
> I have to MYISAM tables where I... ahem... have lost the corresponding .MYI
> files. When I try to repair the tables, myis
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
>
>
-
This may well be a point which has been raised in the past, but has
there ever been any talk of splitting this list into a
"mysql-for-dummies" and a "mysql-for-people-who-read-the-manual" list
? I'm getting close to unsubscribing due to the enormously large noise
ratio - to be frank, questions suc
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 add
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
I'd love to see some benchmarks soonish if anyone has/is about to
compare each of the table handlers for speed and stability. Personally I'd
love to have row-level locking, but don't want to do it if it means
lower stability and/or slower basic select/insert queries.
regards,
P
On Sat, 17 Mar
2
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
bac
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.
>
> PA
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
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
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: Full
> 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
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 ModAuthMy
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
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
>
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
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 alrea
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 (previ
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 Ki
Oops...apologies...my mistake =)
*blush*
P
On Fri, 23 Feb 2001, Fred van Engen wrote:
> On Fri, Feb 23, 2001 at 08:13:20PM +0900, Sam Joseph wrote:
> >
> > however on the MySQL versions I currently have access to (3.22.32 &
> > 3.22.34) I get this:
> >
> > mysql> select COUNT(DISTINCT SOME_C
This feature isn't available in current versions of mySQL, but is on the
TODO list.
regards,
P
On Fri, 23 Feb 2001, Sam Joseph wrote:
> Hi there,
>
> Doesn't seem to be a FAQ so here goes with a question
>
> My MySQL manual has the following to say about how to count the number
> of distinc
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
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...
rega
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.
>
>
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:
>ht
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:
>
>
I'm afraid XML isn't going to help you - you need to investigate DHTML
options, although you'll be lucky to find a solution which is
compatible across both Netscape and IE.
regards,
P
On Sat, 17 Feb 2001, Siim Einfeldt
aka Itpunk wrote:
> Hi everybody,
>
> I want to implement ordering somethi
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 – training
given-(Mediterranean Coast)This is a fantastic opportunity to work
for the UK’s leading children’s adventure holiday
co
Solaris tar has bugs - download and install GNU tar from
www.gnu.org
Cheers,
Pete
On Sat, 17 Feb 2001, HASAN farooq wrote:
> I have GNU tarbut still when i decompress the the
> mysql i get
> mysql-3.22.32-sun-solaris2.7-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_
> i686-cmp-adabas,mysql
isn't it as simple as...
select id,lot_id,lot_type from scrap_table
where id >= 1932 and id <= 1942
order by id limit 10;
?
cheers,
P
>
> which should give me records 1932 - 1942 like this...
>
> +--+--+--+
> | id | lot_id | lot_type |
> +--+
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 pas
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
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
Or a handy one-liner...
perl -pi -e "s/[\012\015]//" *.sql
On Tue, 13 Feb 2001, Pat Sherrill wrote:
> When ftp'ing the file use the ASCII mode instead of the BINARY mode. All
> CR/LF conversions will take place automagically. Alternatively some linux
> distributions have a utility to strip C
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 pa
There'll be a .err file in your ~mysql/var directory - have a
look at it, and it should give you a pointer as to the precise problem.
regards,
P
On
Fri, 9 Feb 2001, Matt Davis wrote:
> I am new to MySQL and have just installed the MySQL rpm files to my Linux
> box.
>
> I have run "mysql_insta
Re your second query - without looking at the docs,
unix_timestamp(field1) - unix_timestamp(field2) would give you the
difference in seconds - I;m sure there's a cleaner way though!
On Thu, 8
Feb 2001, Quickling wrote:
> Hi,
>
> Question 1:
> ---
> We've got a server app that does a
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
>
>
> ---
Use mysqldump -q ...
This will prevent buffering of the table content in RAM.
regards,
P
On Wed, 7 Feb
2001, Brian Reichert wrote:
> I apologize if this has been discussed already, but I quick poke
> at the archives didn't reveal anything.
>
> We have a table that iamchk says is fine. We ar
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 Feb
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
password() encrypts the password - it's a one-way encryption with no
possibility of regaining the plain-text value.
On Mon, 22 Jan 2001, Opas
Suteppratanwong wrote:
> Now i use the Miscellaneous functions PASSWORD() , how can i decypt the
> values for use to show in true value . what function
74 matches
Mail list logo