Does anyone please know where i can get a comprehensive SQL tutorial as in one
that contains stuffs on engines, data structures, table types, etc& NOT
JUST the basic query commands &
their syntax(es).
-
A passion till tomorrow,
Opeyemi Obembe | ng.clawz.c
On Monday 28 March 2005 13:00, Yemi Obembe wrote:
> Does anyone please know where i can get a comprehensive SQL tutorial as
> in one that contains stuffs on engines, data structures, table types,
> etc& NOT JUST the basic query commands DELETE, INSERT...> & their syntax(es).
Hi Yemi
It sound
Yemi,
Well, Joe Celko is a recognized expert; Googling for "Joe Celko tutorial"
turned up 8,900 hits,
but this link was found on the first page:
http://www.codebox.8m.com/sql.htm
Lots of stuff there.
If you want books,
The Practical SQL Handbook Bowman, Emerson and Darnovsky ISBN 0-201-
Check the docs for the DB of your choice. Or google for it.
Bastien
From: Yemi Obembe <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] comprehensive sql tutorial
Date: Mon, 28 Mar 2005 04:00:25 -0800 (PST)
Does anyone please know where i can get a comprehensive SQL tutorial as in
one
I wrote a really simple 11 or 12 line PHP script to remove old entries from
a web card application I made:
When this is run from the web it works fine.
I wanted it on a CRON then the expired entries are removed
automatically.
Take a look at this line:
$todays_date=DATE("Y-m-d");
When it
Ron Piggott wrote:
I wrote a really simple 11 or 12 line PHP script to remove old entries from
a web card application I made:
$todays_date=DATE("Y-m-d");
[snip]
Take a look at this line:
$todays_date=DATE("Y-m-d");
When it is ran from the command line this line causes the script to give
these erro
Martin Norland wrote:
00 8-19/2 * * mon-fri /usr/bin/php /foo/backup_script.php
I should have mentioned this - this runs twice an hour Monday through
Friday, between the hours of 8am and 7pm. You would more likely prefer
05 1* * * your_command
which would run at 1:05am every day. use 'cro
I am having trouble in the following code. Basically, I want to
query two separate database tables and then generate an array from these
two queries. The first query will return a list of ALL systems. The
second query will return a list of systems that should be excluded. The
problem is
Oops... Correction to the last line of the script.
Should be...
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
> -Original Message-
> From: NIPP, SCOTT V (SBCSI)
> Sent: Monday, March 28, 2005 10:47
why wouldn't you just run a query to return only the elements that you want?
Bastien
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To:
Subject: [PHP-DB] RE: Further MySQL query problems...
Date: Mon, 28 Mar 2005 10:49:24 -0600
Oops... Correction to the last line of the script.
If I could figure out how to structure the query, I would be
happy to do so. The problem is that I am working with 3 different
tables for this. Additionally, I ran into a brick wall when trying to
structure the query to remove/eliminate the entries in the exclusion
table. The exclusion t
I didn't realize I was required to do this.
Would you put this line where it belongs? I am not sure what to do with the
and if these are needed for the script to run from the command
line.
Ron
#!/
- Original Message -
From: <[EMAIL PROTECTED]>
To: Ron Piggott <[EMAIL PROTECTED]>
S
Goes right where you have it
#!/
?>
Bastien
From: "Ron Piggott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
CC: "PHP DB"
Subject: Re: [PHP-DB] Command Line Error
Date: Mon, 28 Mar 2005 12:35:09 -0500
I didn't realize I was required to do this.
Would you put this line where it belongs? I am not
OK. Maybe I am going about this in the wrong manner. Here is
the SQL statement that I am starting out with.
$query = "SELECT Hostname FROM Data
WHERE CPU_IN_SVC = \"Y\"
AND CPU_DNS = \"blah.com\"
ORDER BY Hostname ASC";
This q
14 matches
Mail list logo