Table function: A function that return a value of the table data type (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ta-tz_7ysl.asp). This is similar but not the same as creating a temporary table to store the results of a query. Variables declared as type "table" do not have any of the restrictions that apply to even local temporary tables because they only have procedure scope (unless used as a return data type then they are also available in the scope that called the function). MySQL does not support the "table" data type (yet).
Nested selects have been supported in MySQL since 4.0 (part of the UNION enhancement) SELECT tbl1.field1, ... FROM (SELECT ... FROM ... ) as tbl1 ... This is NOT subquery syntax, it is actually a form of an anonymous view (a view with no name). That is why, if you are going to use that form, you must alias the interior (SELECT ...) expression with a name (so the exterior select expression has a table name to work with). I looked in the docs but couldn't find it again. Who has a pointer to it handy? There are certain "convenience" facilities in MS SQL server (like DTS packages) that could require significant development and maintenance to migrate to MySQL 5.0. It's the "gee-whiz" where MS wins not on performance. If you like bare-knuckle database performance, MySQL can go toe-to-toe with just about any other player on the market. Plus, MySQL has a price advantage over most of the other players in its performance range. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Nick Porter" <[EMAIL PROTECTED]> wrote on 10/31/2005 10:26:45 AM: > Somebody give me some ammo for this. I flagged MySQL v5 to our CTO and > got shot down. We currently develop in MSSQL and I don't know enough > about either to make a constructive argument. I'm not even sure I > understand what he's on about with 'table functions' and 'nested > selects'. I couldn't find them specifically with a search through the > docs. All advocate rantings welcome. > -- > np > > -----Original Message----- > From: TT > Sent: Monday, October 31, 2005 3:10 PM > To: NP; JC > Subject: RE: So when are we switching over to the... > > Answer: never > > Last time I looked, mysql had no stored procedures. It has now, but I > doubt it can do table functions nor nested selects. > > > > > -----Original Message----- > > From: NP > > Sent: 31 October 2005 15:08 > > To: TT, JC > > Subject: So when are we switching over to the... > > > > > > > > ...vastly superior MySQL backend then? ;) > > > > http://dev.mysql.com/ > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
