mysql>
mysql> DELIMITER //
mysql> CREATE FUNCTION myProc (cost DECIMAL(10,2))
    -> RETURNS DECIMAL(10,2)
    ->
    -> SQL SECURITY DEFINER
    ->
    -> tax: BEGIN
    ->     DECLARE order_tax DECIMAL(10,2);
    ->     SET order_tax = cost * .05;
    ->     RETURN order_tax;
    -> END
    -> //
Query OK, 0 rows affected (0.00 sec)

mysql> DELIMITER&nbsp$$
mysql>
mysql> select myProc(123.45);
+—————-+
| myProc(123.45) |
+—————-+
|           6.17 |
+—————-+
1 row in set, 1 warning (0.00 sec)

mysql>
mysql> drop function myProc;
Query OK, 0 rows affected (0.00 sec)

mysql>

HTML, ASP, PHP, Perl, VBScript, JavaScript, CSS, XML, XSLT, XSLT2, XML Schema, WML files

jscript.zip (2007-05-10)

JScript stx with Prototype.js – W. Jordan

jscript.acp.zip (2007-05-10)

JScript acp, ctl with Prototype.js – W. Jordan

css.acp.zip (2007-05-10)

CSS acp, ctl – W. Jordan

asp_cs.zip (2007-05-10)

ASP.net with C# acp, ctl – W. Jordan

wsdl.zip (2007-04-05)

WSDL stx – Derli Marcochi

xslt2_acp.zip (2007-03-02)

XSLT2 acp, ctl – W. Jordan

xslt_acp.zip (2007-03-02)

XSLT acp, ctl – W. Jordan

ansi_meu.zip (2006-12-07)

ASCII to HTML acp, ctl (Portuguese) – Armindo Lapa

htmlbar3.zip (2006-12-04)

HTML toolbar for HTML and XHTML updated – Kartros

podcasting.zip (2006-06-16)

Apple iPod iTunes Podcasting (RSS/XML).stx – Valerio Capello

filezilla.zip (2006-06-13)

FileZilla Settings file (XML) stx – Valerio Capello

php514.zip (2006-05-08)

PHP 5.1.4 stx – BiHon

html_dotnet.zip (2006-04-27)

Html with Asp.net ctl – dp-U-To Solutions

css3.zip (2006-04-19)

CSS stx – W. Jordan

htmlbar2.zip (2006-03-30)

HTML toolbar for HTML and XHTML – Martin “Shuster” Švec

asp_net_20.zip (2006-03-21)

ASP.NET (C#, ASP/ADO.NET, VB) ctl, template – Dimitrios Markatos

php16.zip (2006-02-22)

PHP stx – Julien Perez

php5x.zip (2006-01-30)

PHP 5.x stx – Will Buckner

js5.zip (2005-11-17)

JavaScript stx – Ze Thriller

html_asp.zip (2005-11-15)

HTML with ASP.net 2 Web Controls stx – W. Jordan

asp_cs2.zip (2005-11-15)

ASP.net with C# for .Net Framework 2 stx – W. Jordan

dhtml.zip (2005-10-20)

DHTML Events ctl – Daniel Guinn

ant_2020.zip (2005-10-04)

xml ANT (A Neat Tool) stx – Greg Presedo-Floyd

csdoc.zip (2005-09-30)

C# XML Documentation ctl – W. Jordan

gps_xml.zip (2005-09-19)

GPS xml (Google Earth KML XML, Geocaching XML, GPX XML) stx – Valerio Capello

xul.zip (2005-08-27)

XUL (XML-based User Interface Language) stx – rgv151

php504.zip (2005-08-01)

PHP 5.0.4 stx, acp – Bernhard Kirchen

php.5.0.4.zip (2005-05-07)

php 5.0.4 stx – Ilya V. Glazkov

php_stx2.zip (2005-04-11)

PHP 5.0.4 stx – Timofei Ivaschenko

php-5.0.3.zip (2005-03-25)

PHP 5.0.3 stx – Stoyan Dimitrov

php_acp3.zip (2005-03-24)

PHP acp – Iuri Carraro

wsf2.zip (2004-08-27)

Windows Script Host with JScript stx, acp – W. Jordan

php503.zip (2005-01-08)

PHP 5.0.3 stx – Seung Hwan Kang

plsql3.zip (2007-10-22)

pl/sql Oracle’s procedure language stx – Mark Huber

mysql3.zip (2007-07-30)

MySQL 5.0 stx – Harry Long

ms-tsql.zip (2007-06-04)

Microsoft T-SQL 7.0 stx – Matthew Black

java_1_6_0.zip (2007-02-06)

Java SE 6 (1.6.0) stx – Тимофей Иващенко

cpp_qt.zip (2006-11-21)

C++ Qt 4.2.0/ANSI stx – Павел Спицин Валерьевич

esql.zip (2006-11-20)

ESQL for IBM Websphere Message Broker stx, acp – Sridar Swaminathan

java.rar (2006-08-17)

Java 2 SE Development Kit 5.0 (1.5.0) stx – Тимофей Иващенко

sql4.zip (2006-03-20)

SQL stx – George Alatrash

cpp7.zip (2006-03-18)

C++ stx (POSIX/ANSI/STL) – 임유빈 님

velocity.zip (2006-02-01)

Velocity for Java (*.vm) stx – Alon Halimi

cs2.zip (2005-11-15)

C# for .Net Framework 2 stx – W. Jordan

java_1_4_2.zip (2005-10-10)

Java 1.4.2 stx and Java syntax file generator software – Тим

sql3.zip (2005-09-17)

C/C++ with SQL stx – Marcos Moya

dp_div.zip (2005-08-25)

JavaScript ctl – dp-U-To Solutions

mayacpp.zip (2005-08-04)

C++ with Maya API class names stx – David Chen

mysql2.zip (2005-07-23)

MySQL stx – rgv151

mobilec.zip (2005-06-07)

Mobile C (GVM, GNEX) stx, acp – 이근수 님

cpp_ctl.zip (2005-04-27)

C++ ctl – Allen Varner 2005

cpp_sym.zip (2005-03-23)

C++ Programming for Symbian OS (Series 60) stx – Gaurav Jain

plpg_postgre.zip (2004-11-23)

PL/pgSQL and PostgreSQL (7.4.5) stx, acp – Tomek Jakubas

dotnet11.zip (2005-01-19)

C# with .Net Framework 1.1 stx – W. Jordan

cpp8.zip (2005-01-18)

C/C++ (enhanced) stx – Tim

How MySQL Optimises ORDER BY

In some cases MySQL can uses index to satisfy an ORDER BY or GROUP BY request without doing any extra sorting.

The index can also be used even if the ORDER BY doesn’t match the index exactly, as long as all the unused index parts and all the extra are ORDER BY columns are constants in the WHERE clause. The following queries will use the index to resolve the ORDER BY / GROUP BY part:

SELECT * FROM t1 ORDER BY key_part1,key_part2,…
SELECT * FROM t1 WHERE key_part1=constant ORDER BY key_part2
SELECT * FROM t1 WHERE key_part1=constant GROUP BY key_part2
SELECT * FROM t1 ORDER BY key_part1 DESC,key_part2 DESC
SELECT * FROM t1 WHERE key_part1=1 ORDER BY key_part1 DESC,key_part2 DESC

Some cases where MySQL can not use indexes to resolve the ORDER BY: (Note that MySQL will still use indexes to find the rows that matches the WHERE clause):

* You are doing an ORDER BY on different keys: SELECT * FROM t1 ORDER BY key1,key2
* You are doing an ORDER BY using non-consecutive key parts. SELECT * FROM t1 WHERE key2=constant ORDER BY key_part2
* You are mixing ASC and DESC. SELECT * FROM t1 ORDER BY key_part1 DESC,key_part2 ASC
* The key used to fetch the rows are not the same one that is used to do the ORDER BY: SELECT * FROM t1 WHERE key2=constant ORDER BY key1
* You are joining many tables and the columns you are doing an ORDER BY on are not all from the first not-const table that is used to retrieve rows (This is the first table in the EXPLAIN output which doesn’t use a const row fetch method).
* You have different ORDER BY and GROUP BY expressions.
* The used table index is an index type that doesn’t store rows in order. (Like the HASH index in HEAP tables).

In the cases where MySQL have to sort the result, it uses the following algorithm:

* Read all rows according to key or by table scanning. Rows that don’t match the WHERE clause are skipped.
* Store the sort-key in a buffer (of size sort_buffer).
* When the buffer gets full, run a qsort on it and store the result in a temporary file. Save a pointer to the sorted block. (In the case where all rows fits into the sort buffer, no temporary file is created)
* Repeat the above until all rows have been read.
* Do a multi-merge of up to MERGEBUFF (7) regions to one block in another temporary file. Repeat until all blocks from the first file are in the second file.
* Repeat the following until there is less than MERGEBUFF2 (15) blocks left.
* On the last multi-merge, only the pointer to the row (last part of the sort-key) is written to a result file.
* Now the code in `sql/records.cc’ will be used to read through them in sorted order by using the row pointers in the result file. To optimise this, we read in a big block of row pointers, sort these and then we read the rows in the sorted order into a row buffer (read_rnd_buffer_size) .

You can with EXPLAIN SELECT … ORDER BY check if MySQL can use indexes to resolve the query. If you get Using filesort in the extra column, then MySQL can’t use indexes to resolve the ORDER BY. See section 5.2.1 EXPLAIN Syntax (Get Information About a SELECT).

If you want to have a higher ORDER BY speed, you should first see if you can get MySQL to use indexes instead of having to do an extra sorting phase. If this is not possible, then you can do:

* Increase the size of the sort_buffer_size variable.
* Increase the size of the read_rnd_buffer_size variable.
* Change tmpdir to point to a dedicated disk with lots of empty space. If you use MySQL 4.1 or later you can spread load between several physical disks by setting tmpdir to a list of paths separated by colon : (semicolon ; on Windows). They will be used in round-robin fashion. Note: These paths should end up on different physical disks, not different partitions of the same disk.

By default, MySQL sorts all GROUP BY x,y[,…] queries as if you specified ORDER BY x,y[,…] in the query as well. If you include the ORDER BY clause explicitly, MySQL optimises it away without any speed penalty, though the sorting still occurs. If a query includes GROUP BY but you want to avoid the overhead of sorting the result, you can supress sorting by specifying ORDER BY NULL:

INSERT INTO foo SELECT a,COUNT(*) FROM bar GROUP BY a ORDER BY NULL;

SecureCRT gives you an encrypted Secure Shell (SSH1 and SSH2) session with servers and devices. For SSH, Telnet, Telnet/SSL, and other protocols, SecureCRT’s tabbed sessions reduce desktop clutter and make it easy to switch between sessions and organize groups of connected sessions. Extensive session management and customization features include named sessions, and multiple-session windows. Choose from a wide range of emulations including VT100, VT102, VT220, ANSI, SCO ANSI, Wyse 50/60, Xterm, and Linux console. SecureCRT can help you save valuable time by automating routine configuration tasks with powerful scripting capabilities.

SecureCRT 5.5 offers new time-saving features, with a script recorder and the ability to open multiple sessions or folders on startup using auto session. Additional enhancements include custom logging options, support for generating and converting private keys in OpenSSH format, improved integration with SecureFX®, and support for Windows Vista.