I had a problem with getting the list of the tables in a mysql db.

MySQL 5.0 offers Views so the usual

is not accurate

Used this to get the tables alone

Stored Procedures at last in version 5 of MySQL.

Often people from the SQL Server world would downplay MySQL saying that it lacks views and stored procedures which have been present in the MS world and the PostgreSQL world for a long time.

With the latest version of 5.0.18 MySQL has made a promising effort to bring these cool features into its feature set. I had blogged about Views in Mysql 5 here earlier.

Now got some time to write about the Stored Procedures feature in MySQL 5

Why Stored Procedures ?

Links

Database Journal Article
I will post a part 2 of this article where i will take you through some examples

News.com says that Open-source database company MySQL said it has secured $18.5 million in series C funding, a round led by Institutional Venture Partners. The total venture investment in the company, which has operations in Sweden and Cupertino, Calif., is about $39 million.

The money will be used to fund the company’s growth, product development and expanded marketing and sales operations, MySQL said. Also participating in the round were Intel Capital, Red Hat, SAP Ventures and Presidio STV, the venture investment subsidiary of Sumitomo. “With the release of MySQL 5.0, the company is offering deep functionality at a fraction of the cost of the competition, prompting many CIOs to reconsider their database strategy,” said Steve Harrick, managing director and general partner of Institutional Venture Partners.

Views have been introduced MySql. Lets see how they can be created and used.

Views are nothing but subset of a table in a database.

You may not want all tabular data for a particular purpose. You may want to certain users not to see some part of the tabular data.

Views comes to your rescue in such a situation.

general syntax from mysql manual

[code lang="SQL"]

CREATE
[OR REPLACE]
[ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
[DEFINER = { user | CURRENT_USER }]
[SQL SECURITY { DEFINER | INVOKER }]
VIEW view_name [(column_list)]
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION]

[/code]

A very good example straight from the manual.

[code lang="SQL"]

mysql> CREATE TABLE t (qty INT, price INT);
mysql> INSERT INTO t VALUES(3, 50);
mysql> CREATE VIEW v AS SELECT qty, price, qty*price AS value FROM t;
mysql> SELECT * FROM v;

[/code]

+------+-------+-------+
| qty  | price | value |
+------+-------+-------+
|    3 |    50 |   150 |
+------+-------+-------+