diff options
author | monty@work.mysql.com <> | 2001-04-11 13:04:03 +0200 |
---|---|---|
committer | monty@work.mysql.com <> | 2001-04-11 13:04:03 +0200 |
commit | 8f62579c38e860ddc1d62c463d895c4c951fe979 (patch) | |
tree | 9ad58a68370fc8feb8195b7b9c6423d58372093a /fs/dump.sql | |
parent | 4709a1721a656f175e7b27aef2c01fa3910000f8 (diff) | |
download | mariadb-git-8f62579c38e860ddc1d62c463d895c4c951fe979.tar.gz |
Added all changes from old 4.0 version:
PSTACK, libmysqld and MySQL filesystem
UPDATE ... ORDER BY
DELETE ... ORDER BY
New faster fulltext handling
Faster compressed keys
Diffstat (limited to 'fs/dump.sql')
-rw-r--r-- | fs/dump.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/fs/dump.sql b/fs/dump.sql new file mode 100644 index 00000000000..c61669cecb5 --- /dev/null +++ b/fs/dump.sql @@ -0,0 +1,28 @@ +# MySQL dump 8.12 +# +# Host: localhost Database: mysqlfs +#-------------------------------------------------------- +# Server version 3.23.33 + +# +# Table structure for table 'functions' +# + +CREATE TABLE functions ( + type enum('server','database','table','field','key') NOT NULL default 'server', + name char(20) NOT NULL default '', + sql char(128) NOT NULL default '', + PRIMARY KEY (type,name) +) TYPE=MyISAM; + +# +# Dumping data for table 'functions' +# + +INSERT INTO functions VALUES ('server','uptime','SHOW STATUS like \'Uptime\''); +INSERT INTO functions VALUES ('server','version','SELECT VERSION()'); +INSERT INTO functions VALUES ('table','count','SELECT COUNT(*) FROM `%table`'); +INSERT INTO functions VALUES ('key','min','SELECT MIN(%key) FROM `%table`'); +INSERT INTO functions VALUES ('key','max','SELECT MAX(%key) FROM `%table`'); +INSERT INTO functions VALUES ('key','avg','SELECT AVG(%key) FROM `%table`'); + |