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 CREATE, SELECT, UPDATE, DELETE, INSERT...
their syntax(es).
-
A passion
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 CREATE, SELECT, UPDATE,
DELETE, INSERT... their syntax(es).
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
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:
?
$todays_date=DATE(Y-m-d);
$username=user;
$password=password;
$database=database;
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( Unable to select
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 error
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
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
Oops... Correction to the last line of the script.
?php } while ($blah = mysql_fetch_array($exclude_results)); ?
Should be...
?php } while ($blah = array_shift($temp)); ?
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
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: php-db@lists.php.net
Subject: [PHP-DB] RE: Further MySQL query problems...
Date: Mon, 28 Mar 2005 10:49:24 -0600
Oops... Correction to the last line of
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
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 ? and if these are needed for the script to run from the command
line.
Ron
#!/path to php cli binary
?
$todays_date=DATE(Y-m-d);
$username=user;
Goes right where you have it
#!/path to php cli binary
?php
...rest of your script
?
Bastien
From: Ron Piggott [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: PHP DB php-db@lists.php.net
Subject: Re: [PHP-DB] Command Line Error
Date: Mon, 28 Mar 2005 12:35:09 -0500
I didn't realize I was required to
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 query
14 matches
Mail list logo