-Original Message-
From: Jeremy [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 12:49 PM
To: [EMAIL PROTECTED]
Subject: Newbie questions (3) - listeners / BLOB / PHP
Hi I'm from an Oracle background and wanted to ask a couple of questions:
1) Have installed mysql 4 on a linux ser
> 1) Have installed mysql 4 on a linux server. If I want to access this from
> another machine (i.e. run a MySQL-compliant client), is there a 'listener'
> of some sort that has to run on the server where the database is?
Nope, proper permissions is the only requirement. MySQL listens on port 33
No
Yes
www.php.net
Regards,
Mike Hillyer
> -Original Message-
> From: Jeremy [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 07, 2003 1:49 PM
> To: [EMAIL PROTECTED]
> Subject: Newbie questions (3) - listeners / BLOB / PHP
>
>
> Hi I'm from an Oracle background and wanted to ask a coup
Mark Sibly wrote:
>Hi,
>
>I'm new to this list, and have a few basic MySql questions:
>
>* Is it safe to convert a timestamp field to a datetime one? ie: will this
>'touch' each row and stuff up the ordering (hopefully not!).
>
What happend when you tried it on a test table?
>
>
>* I'm buildi
r [mailto:[EMAIL PROTECTED]]
: > Skickat: den 18 oktober 2001 14:47
: > Till: MySQL List
: > Ämne: Re: newbie - questions about timestamp(14)
: >
: > Thanks for your reply, I have tried using the query as you suggest,
: see
: > below:
: >
: > SELECT user_ip IF(TIME_TO_SEC(NOW())
Thanks for your reply, I have tried using the query as you suggest, see
below:
SELECT user_ip IF(TIME_TO_SEC(NOW()) - TIME_TO_SEC(log_time) < 300, 'true',
'false') FROM clinic_log
But this just gives me an error, ie the query won't run?
Does the query seem to be right?
Thanks again
Paul
-
Thank you guys. I guess there is a big backlog, plus it seems a pretty
active list. Maybe I'd better just stick with the archives. As I
become more familiar with MySQL I'll probably have more specific
questions, and can search the archives a little more productively.
Thank you.
Mike Kimball
> I know I'm getting away ahead of myself here, but is there a GUI
> application development tool for mySQL? Something like Paradox or
> Access, that lets you create complete applications with attractive
> screens/forms and even start-up/splash screens. This would be on an NT
> workstation.
Any
> And is there some way to download the previous posts to this list? I
> found one list admin function that will download up to 100 posts
> concatenated into one email, but I'd like to be able to d/l them
> individually, with their own subject line and threading info. I just
> think it would be
Date |Sat, 14 Jul 2001 20:38:23 -0500
>From |Hank Marquardt <[EMAIL PROTECTED]>
Hello!
HM> Try RLIKE or REGEXP --
HM> http://www.mysql.com/docs/S/t/String_comparison_functions.html
Little typo.
right url : http://www.mysql.com/docs/S/t/String_comparison_functions.html
___
At 6:39 PM -0700 7/14/01, Bob Rea wrote:
>OK, mr newbie here. I'm trying to lern SQL using MySQL. I have a
>general SQL book, Sams Teach Yourself SQL in 10 Minutes, by Ben
>Forta. I also have mSQL and MySQL fromO'Reilly. And of course i have
>the MySQL Manual.
>
>The 10 minute book's syntax somet
Try RLIKE or REGEXP --
http://www.mysql.com/docs/S/t/String_comparison_functions.html
On Sat, Jul 14, 2001 at 06:39:00PM -0700, Bob Rea wrote:
> OK, mr newbie here. I'm trying to lern SQL using MySQL. I have a
> general SQL book, Sams Teach Yourself SQL in 10 Minutes, by Ben
> Forta. I als
m on 02/10/2001
01:06:43 PM
To: "Aaron Sinclair" <[EMAIL PROTECTED]>
cc: [EMAIL PROTECTED] (bcc: Lad Gaal/MarconiMedical)
Subject: Re: Newbie Questions
You're correct in that /var/lib/mysql/mysql/* was not owned by mysql. I did a
chown mysql.mysql and then did a chmod
g password: YES)'
I'm open for suggestions TX
"Aaron Sinclair" <[EMAIL PROTECTED]> on 02/09/2001 08:20:16 PM
To: Lad Gaal/MarconiMedical@Marconi
cc:
Subject: Re: Newbie Questions
check that /var/lib/mysql/mysql/* are owned by mysql and have read write
premiss
14 matches
Mail list logo
