advanced SQL

[Chris Mosser]

Until recently, I thought MySQL, and SQL in general was no problem....doing
simple INSERTS, DELETES, and UPDATES;...then I heard about triggers,
transactions, and stored procedures which I only slightly know what they
are. Can any one point me to a good tutorial on these advanced topics...I
am already googleing around...but am wondering if any one has any specific
places for me to look.

--
Chris Mosser

[Nikolai Chuvakhin]

"Chris Mosser" <cmosser@comcast.net> wrote in message
news:<-PmcnabKKP3wupOiXTWJiA@comcast.com>...

>
> Until recently, I thought MySQL, and SQL in general was
> no problem....doing simple INSERTS, DELETES, and UPDATES;
> ...then I heard about triggers, transactions, and stored
> procedures which I only slightly know what they are.
> Can any one point me to a good tutorial on these advanced
> topics...

The best place to look is the language reference manual for
the database you are working with.

As to MySQL, it does not support triggers and stored procedures
(the word is, in version 5 it will). Transactions, however, are
supported:

[url]http://www.mysql.com/doc/en/Transactional_Commands.html[/url]

Cheers,
NC

[Louis-Philippe Huberdeau]

PHP will not support triggers and stored procedures until MySQL5
(currently in development but no ETA).

As for Transactions, those are availible if you use InnoDB or BerkleyDB
storage (and not the default MyISAM). To use them in PHP, you will need
to use the mysqli library (MySQL Improved), which should be shipped with
PHP5 but will probably be in PHP4 someday. The library is currently
availible, you can probably get it from the CVS.

Transactions are quite simple:
Do normal queries and for them to apply on the 'real' database, you need
to commit. Otherwise, it will do a rollback and all changes you made
will disapear.

I don't know about any tutorial, but I hope those informations were
useful. You might want to search for PHP + MySQL + InnoDB and such on
your favorite search engine.

Chris Mosser wrote:

> Until recently, I thought MySQL, and SQL in general was no problem....doing
> simple INSERTS, DELETES, and UPDATES;...then I heard about triggers,
> transactions, and stored procedures which I only slightly know what they
> are. Can any one point me to a good tutorial on these advanced topics...I
> am already googleing around...but am wondering if any one has any specific
> places for me to look.
>
> --
> Chris Mosser
>
>

[Chris Mosser]

--

>
> I don't know about any tutorial, but I hope those informations were
> useful. You might want to search for PHP + MySQL + InnoDB and such on
> your favorite search engine.

will do..thanx for the info guys

cmosser

[Agelmar]

Chris Mosser wrote:

>>
>> I don't know about any tutorial, but I hope those informations were
>> useful. You might want to search for PHP + MySQL + InnoDB and such on
>> your favorite search engine.

>
>
> will do..thanx for the info guys
>
> cmosser

One other note is that if you want to use mysqli, you must use MySQL >= 4.1,
and 4.1 is still verymuch alpha quality (and designated as such).

[Sam Williams]

On Fri, 11 Jul 2003 11:18:48 -0400, Louis-Philippe Huberdeau
<lphuberdeau@sympatico.ca> wrote:

> PHP will not support triggers and stored procedures until MySQL5
> (currently in development but no ETA).

I think you mean that MySQL will not support triggers/stored procedures
until version 5 :-) These functions are performed within the database and
have nothing to do with php...

If you have need for triggers/stored procedures or row level table
locking, I suggest that you use postgresql instead of mysql. It supports
all these things and is IMHO a much better product. You can access
postgresql through either the native functions in php or using ODBC (my
preference as it leads to portable applications). The postgresql manual is
also very good at explaining how to write queries, design tables, use
these advanced features and optimise databases.

Regards,

Sam.
---
Posted via [url]news://freenews.netfront.net[/url]
Complaints to [email]news@netfront.net[/email]

[Louis-Philippe Huberdeau]

This was definetly a typo, thanks for pointing it out. I should really
start reading what I write once in a while.

Sam Williams wrote:

> On Fri, 11 Jul 2003 11:18:48 -0400, Louis-Philippe Huberdeau
> <lphuberdeau@sympatico.ca> wrote:
>
>

>>PHP will not support triggers and stored procedures until MySQL5
>>(currently in development but no ETA).

>
>
> I think you mean that MySQL will not support triggers/stored procedures
> until version 5 :-) These functions are performed within the database and
> have nothing to do with php...
>
> If you have need for triggers/stored procedures or row level table
> locking, I suggest that you use postgresql instead of mysql. It supports
> all these things and is IMHO a much better product. You can access
> postgresql through either the native functions in php or using ODBC (my
> preference as it leads to portable applications). The postgresql manual is
> also very good at explaining how to write queries, design tables, use
> these advanced features and optimise databases.
>
> Regards,
>
> Sam.
> ---
> Posted via [url]news://freenews.netfront.net[/url]
> Complaints to [email]news@netfront.net[/email]

[Heikki Tuuri]

Hi!

"Louis-Philippe Huberdeau" <lphuberdeau@sympatico.ca> kirjoitti viestissä
news:PpqQa.1402$104.143350@news20.bellglobal.com.. .

> This was definetly a typo, thanks for pointing it out. I should really
> start reading what I write once in a while.
>
> Sam Williams wrote:

> > On Fri, 11 Jul 2003 11:18:48 -0400, Louis-Philippe Huberdeau
> > <lphuberdeau@sympatico.ca> wrote:
> >
> >

> >>PHP will not support triggers and stored procedures until MySQL5
> >>(currently in development but no ETA).

> >
> >
> > I think you mean that MySQL will not support triggers/stored procedures
> > until version 5 :-) These functions are performed within the database

and

> > have nothing to do with php...

MySQL-5.0 is already available as a source tree
[url]http://www.mysql.com/doc/en/Installing_source_tree.html[/url].

I saw it run stored procedures in February. My guess is that the first
binary 5.0 release will happen around January 2004.

>> If you have need for triggers/stored procedures or row level table
>> locking,

MySQL has supported row level locking for over 2 years now, starting from
MySQL-Max-3.23.34a.

....

> >
> > Regards,
> >
> > Sam.

Best regards,

Heikki Tuuri
Innobase Oy
[url]http://www.innodb.com[/url]
Transactions, foreign keys, and a hot backup tool for MySQL