JWorld@TW the best professional Java site in Taiwan
      註冊 | 登入 | 全文檢索 | 排行榜  

» JWorld@TW » JDBC/SQL討論區 » MySQL  

按列印兼容模式列印這個話題 列印話題    把這個話題寄給朋友 寄給朋友    訂閱主題
reply to postflat modego to previous topicgo to next topic
本主題所含的標籤
無標籤
作者 Re:MySQL 不支援的功能 [Re:snpshu]
arthuroy





發文: 106
積分: 3
於 2003-11-14 14:49 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
1.7.4.1 Subqueries

MySQL Version 4.1 supports subqueries and derived tables (unnamed views). See section 6.4.2 Subquery Syntax.

For MySQL versions prior to 4.1, most subqueries can be successfully rewritten using joins and and other methods. See section 6.4.2.11 Rewriting Subqueries for Earlier MySQL Versions.

6.4.1.2 UNION Syntax
Features Available in MySQL 4.0
http://www.mysql.com/doc/en/Nutshell_4.0_features.html

Many users will also be happy to learn that MySQL Server now supports the UNION statement, a long-awaited standard SQL feature. UNION syntax in SELECT. See section 6.4.1.2 UNION Syntax.

New Features Planned For MySQL 5.0
http://www.mysql.com/doc/en/TODO_MySQL_5.0.html

1.7.4.6 Views

Views are currently being implemented, and will appear in the 5.0 or 5.1 version of MySQL Server.

1.7.4.4 Stored Procedures and Triggers

* Stored procedures are currently being implemented. This effort is based on SQL-99, which has a basic syntax similar (but not identical) to Oracle PL/SQL. We will also implement the SQL-99 framework to hook in external languages, and (where possible) compatibility with, for example, PL/SQL and T-SQL.

Triggers are scheduled for implementation in MySQL version 5.1.


reply to postreply to post
Self-Pity

I never saw a wild thing sorry for itself.
A small bird will drop frozen dead from a bough
without ever having felt sorry for itself.
話題樹型展開
人氣 標題 作者 字數 發文時間
16745 [精華] MySQL 不支援的功能 Vicky 461 2003-11-13 11:39
15367 Re:MySQL 不支援的功能 Biologic 667 2003-11-13 11:57
11708 Re:MySQL 不支援的功能 CyrusLai 149 2004-12-17 01:36
10198 Re:MySQL 不支援的功能 kowala 130 2005-03-30 15:18
9946 Re:MySQL 不支援的功能 richard 122 2005-04-21 09:13
9648 Re:MySQL 不支援的功能 powerouch 0 2005-04-21 11:31
11160 Re:MySQL 不支援的功能 richard 593 2005-04-21 09:41
9646 Re:MySQL 不支援的功能 powerouch 816 2005-04-21 11:45
9613 Re:MySQL 不支援的功能 Shen 1169 2005-04-24 21:15
9856 Re:MySQL 不支援的功能 ARF 89 2005-04-21 16:51
9779 Re:MySQL 不支援的功能 richard 92 2005-04-24 17:38
9553 Re:MySQL 不支援的功能 powerouch 199 2005-04-25 11:42
10492 Re:MySQL 不支援的功能 richard 181 2005-04-28 10:29
14191 Re:MySQL 不支援的功能 ming215 28 2003-11-13 12:02
14276 Re:MySQL 不支援的功能 snpshu 85 2003-11-13 18:30
14155 Re:MySQL 不支援的功能 Biologic 155 2003-11-13 18:46
14120 Re:MySQL 不支援的功能 snpshu 17 2003-11-14 01:27
14413 Re:MySQL 不支援的功能 arthuroy 1385 2003-11-14 14:49
14089 Re:MySQL 不支援的功能 Vicky 155 2003-11-15 09:32
14136 Re:MySQL 不支援的功能 prometheus 457 2003-11-17 23:57
14046 Re:MySQL 不支援的功能 ak74 64 2003-11-18 09:02
13959 Re:MySQL 不支援的功能 ming215 214 2003-11-20 00:18
13942 Re:MySQL 不支援的功能 Forth 21 2003-11-20 09:04
13927 Re:MySQL 不支援的功能 ming215 92 2003-11-21 10:42
13930 Re:MySQL 不支援的功能 snpshu 236 2003-11-20 09:34
13971 Re:MySQL 不支援的功能 Forth 159 2003-11-20 11:09
13981 Re:MySQL 不支援的功能 snpshu 53 2003-11-18 23:17
13944 Re:MySQL 不支援的功能 Vicky 133 2003-11-19 16:13
14078 Re:MySQL 不支援的功能 prometheus 744 2003-11-20 00:42
14357 Re:MySQL 不支援的功能-決非練功,只愛 KISS linexpmail 304 2003-12-06 10:54
13807 Re:MySQL 不支援的功能 steven0617 115 2003-12-05 23:33
10505 Re:MySQL 不支援的功能 richard 116 2005-03-10 17:44
10135 Re:MySQL 不支援的功能 Shen 456 2005-03-30 17:04
» JWorld@TW »  JDBC/SQL討論區 » MySQL

reply to postflat modego to previous topicgo to next topic
  已讀文章
  新的文章
  被刪除的文章
Jump to the top of page

JWorld@TW 本站商標資訊

Powered by Powerful JuteForum® Version Jute 1.5.8