/**
popular collection of scripts for all
*/
/** Search */
{
Database-Related
}|
mSQL is a lightweight SQL
One of the most powerful
This is a nice tutorial on
Many devs using MySQL have
database engine for Unix
aspects of the MySQL server
how to use PostgreSQL and
fallen in love with PHP.
systems. It is extremely
is the amazing amount of
PHP together. Topics covered
Jason Gilmore explains why
easy to install and
control the administrator
include: Installation of
they're the perfect couple.
configure and it does a
has over each user's
PostgreSQL, PHP, and Apache,
This is ore of an
great job of handling simple
intended behavior. This
A Brief Introduction and
introductory article on PHP
SQL queries. This tutorial
control can restrict user
Basic Commands, Different
and MySQL covering such
shows you how to communicate
privileges over a general
Types of Data, Retrieving
topics as features of PHP
with the mSQL database
part of the server, such as
Data from a Database,
and MySQL, and how to use
engine using various
limited access to an entire
Inserting Data into a
PHP to interact with MySQL.
mSQL-PHP functions.
database, but can also be as
Database, Updating Data in a
specific as limiting
Database, Deleting Data from
privileges for a specific
a Database, Dealing with
table or even column. This
Errors, and Including Files.
article will serve to
The tutorial is also
explain the process in which
available for download.
the MySQL server
grants/revokes these user
privileges, highlighting in
particular the newest
additions to the MySQL
privilege system, the
tables_priv and columns_priv
tables. Please keep in mind
that the GRANT/REVOKE
commands detailed later in
this article are only
relevant to MySQL version
3.22.11 and up.
Date: Dec, 26 1999 Date: Nov, 09 1999 Date: Jan, 08 2001 Date: Oct, 17 2000 |
|
One of the great
This article will aid the
Even though loading data from
This tutorial is an
characteristics of SQL
reader in learning the basic
a text file into the
introductory guide to get
(Structured Query Language)
operations of the MySQL
database is not a task that
you started in the world of
is the fact that one can
server, including how to
user would perform on a
server-side-scripting and
develop access and modify
make a proper connection,
daily basis, there are
web databases. It covers
data across various tables.
set up the server for
several cases when the speed
installation and
There are several benefits
consequential manipulation
of this process is important
configuration of MySQL,
to this, including greater
and execute basic commands.
to DBA and company
Apache, and PHP. An example
ease of manipulation,
The commands covered within
management. One example
script is also included as a
increased speed of access,
this article are among the
would be having a
guide for making your own
and reduced data redundancy.
most important commands
"database guy"
server-side-scripts. You
In MySQL (as well as many
within the language, as they
receive the daily reports
will have accomplished after
other SQL languages), this
form the basis for the more
from the field offices or
successfully completing this
is accomplished via the join
advanced commands.
sales people on daily basis.
guide: setup the MySQL
command. This tutorial takes
Reports come as Excel
database server, setup the
a look at several types of
documents or delimited
Apache web server, setup the
the join command including
spreadsheets of some kind,
PHP 3.0 Hypertext
The Cross Join, The
and DBA's responsibility
Preprocessor for
Equi-join, The Left Join,
includes updating the
server-side-scripting, and
and Self-joins.
database on constant basis,
create a simple web enabled
so that by the end of the
database.
day, he is able to give the
management a report on the
amount of daily sales or
field office transactions.
Here you will find a MS
Word-format downloadable
file that examines the
benchmark results for Oracle
and MySQL speed of loading
the data from a text file.
Date: Nov, 09 1999 Date: Nov, 09 1999 Date: Dec, 17 2001 Date: Nov, 09 1999 |
{ Copyright } ©2019 NuclearScripts.com