summaryrefslogtreecommitdiff
path: root/fs/dump.sql
diff options
context:
space:
mode:
authormonty@work.mysql.com <>2001-04-11 13:04:03 +0200
committermonty@work.mysql.com <>2001-04-11 13:04:03 +0200
commit8f62579c38e860ddc1d62c463d895c4c951fe979 (patch)
tree9ad58a68370fc8feb8195b7b9c6423d58372093a /fs/dump.sql
parent4709a1721a656f175e7b27aef2c01fa3910000f8 (diff)
downloadmariadb-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.sql28
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`');
+