Hi Shripal,
your requests were:
>I can't able to do following things with MySQL 3.23.54.
>Sub-selects
Thats right , subselects come with version 4.1 (out for a view days).
About 99% of all subselects are can be done with the right JOIN.
>SELECT INTO TABLE
Try: INSERT INTO <Table_Name> SELECT ...
>Transactions
You have to compile with mysql-max to get them
>Stored Procedures and Triggers
There aren't any.
>Foreign Keys
There is a support for this I heard , but don't know if for 3.23.54
>Views
There aren't any , but a view is (I guess it is ORACLE you come from) just
a stored 'SELECT'-statement.
After you said , that you are using a programming-language , (I heard VB is something
like this - just
kidding) this should not be a problem.
>But, what can I do if I can't do anything without Transaction Support,
>Stored Procedures & Triggers.
>Please suggest me, if there is any alternative. And hopefully in which
>version I can able to get this. For your information I am using MySQL
>with Visual Basic.
It depends on what you want to achieve.
You can work around a lot of these things by planning your jobs
in a different way saving triggers , but sometimes there is no clean
solution without triggers.
If you describe a certain problem on that list , a lot of real experts (not me I
guess) will try
to help.
prosit
Klaus
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
