📄 index.js
字号:
var lastItem=null;
var enablehide=1;
var cTime=new Date();
function OnItemClick(obj){
var dtNow=new Date();
dd=dtNow.getTime()-cTime.getTime();
if(dd<500)return;
cTime=dtNow;
if(obj.className=="clsItemShow"){
obj.className="clsItemHide";
document.all(obj.id+'u').className="clsItemsHide";
}else{
if (lastItem!=null){
lastItem.className="clsItemHide";
document.all(lastItem.id+'u').className="clsItemsHide";
}
obj.className="clsItemShow";
document.all(obj.id+'u').className="clsItemsShow";
lastItem = obj;
}
}
function move(x,y){
object1.style.pixelLeft+=x;
object1.style.pixelTop+=y;
}
function makeStatic(){
object1.style.pixelTop=document.body.scrollTop;
}
function a(ID){
if (ID == 601){window.location.href="about.html"; Return;};
if (ID == 602){window.location.href="index.html"; Return;};
if (ID == 603){window.location.href="function_index.html"; Return;};
if (ID == 610){window.location.href="06-1.html"; Return;};
if (ID == 611){window.location.href="06-1.html#Literals"; Return;};
if (ID == 6111){window.location.href="06-1.html#String_syntax"; Return;};
if (ID == 6112){window.location.href="06-1.html#Number_syntax"; Return;};
if (ID == 6113){window.location.href="06-1.html#Hexadecimal_values"; Return;};
if (ID == 6114){window.location.href="06-1.html#NULL_values"; Return;};
if (ID == 612){window.location.href="06-1.html#Legal_names"; Return;};
if (ID == 613){window.location.href="06-1.html#Name_case_sensitivity"; Return;};
if (ID == 614){window.location.href="06-1.html#Variables"; Return;};
if (ID == 615){window.location.href="06-1.html#System_Variables"; Return;};
if (ID == 616){window.location.href="06-1.html#Comments"; Return;};
if (ID == 617){window.location.href="06-1.html#Reserved_words"; Return;};
if (ID == 620){window.location.href="06-2.html"; Return;};
if (ID == 621){window.location.href="06-2.html#Numeric_types"; Return;};
if (ID == 622){window.location.href="06-2.html#Date_and_time_types"; Return;};
if (ID == 6221){window.location.href="06-2.html#Y2K_issues"; Return;};
if (ID == 6222){window.location.href="06-2.html#DATETIME"; Return;};
if (ID == 6223){window.location.href="06-2.html#TIME"; Return;};
if (ID == 6224){window.location.href="06-2.html#YEAR"; Return;};
if (ID == 623){window.location.href="06-2.html#String_types"; Return;};
if (ID == 6231){window.location.href="06-2.html#CHAR"; Return;};
if (ID == 6232){window.location.href="06-2.html#BLOB"; Return;};
if (ID == 6233){window.location.href="06-2.html#ENUM"; Return;};
if (ID == 6234){window.location.href="06-2.html#SET"; Return;};
if (ID == 624){window.location.href="06-2.html#Choosing_types"; Return;};
if (ID == 625){window.location.href="06-2.html#Other-vendor_column_types"; Return;};
if (ID == 626){window.location.href="06-2.html#Storage_requirements"; Return;};
if (ID == 6261){window.location.href="06-2.html#Num_Storage_requirements"; Return;};
if (ID == 6262){window.location.href="06-2.html#Date_Storage_requirements"; Return;};
if (ID == 6263){window.location.href="06-2.html#Str_Storage_requirements"; Return;};
if (ID == 630){window.location.href="06-3.html"; Return;};
if (ID == 631){window.location.href="06-3.html#Non-typed_Operators"; Return;};
if (ID == 6311){window.location.href="06-3.html#Parentheses"; Return;};
if (ID == 6312){window.location.href="06-3.html#Comparison_Operators"; Return;};
if (ID == 6313){window.location.href="06-3.html#Logical_Operators"; Return;};
if (ID == 6314){window.location.href="06-3.html#Control_flow_functions"; Return;};
if (ID == 632){window.location.href="06-3.html#String_functions"; Return;};
if (ID == 6321){window.location.href="06-3.html#String_comparison_functions"; Return;};
if (ID == 6322){window.location.href="06-3.html#Case_Sensitivity_Operators"; Return;};
if (ID == 633){window.location.href="06-3.html#Numeric_Functions"; Return;};
if (ID == 6331){window.location.href="06-3.html#Arithmetic_functions"; Return;};
if (ID == 6332){window.location.href="06-3.html#Mathematical_functions"; Return;};
if (ID == 634){window.location.href="06-3.html#Date_and_time_functions"; Return;};
if (ID == 635){window.location.href="06-3.html#Cast_Functions"; Return;};
if (ID == 636){window.location.href="06-3.html#Other_Functions"; Return;};
if (ID == 6361){window.location.href="06-3.html#Bit_functions"; Return;};
if (ID == 6362){window.location.href="06-3.html#Miscellaneous_functions"; Return;};
if (ID == 637){window.location.href="06-3.html#Group_by_functions"; Return;};
if (ID == 640){window.location.href="06-4.html"; Return;};
if (ID == 641){window.location.href="06-4.html#SELECT"; Return;};
if (ID == 6411){window.location.href="06-4.html#JOIN"; Return;};
if (ID == 6412){window.location.href="06-4.html#UNION"; Return;};
if (ID == 642){window.location.href="06-4.html#HANDLER"; Return;};
if (ID == 643){window.location.href="06-4.html#INSERT"; Return;};
if (ID == 6431){window.location.href="06-4.html#INSERT_SELECT"; Return;};
if (ID == 644){window.location.href="06-4.html#INSERT_DELAYED"; Return;};
if (ID == 645){window.location.href="06-4.html#UPDATE"; Return;};
if (ID == 646){window.location.href="06-4.html#DELETE"; Return;};
if (ID == 647){window.location.href="06-4.html#TRUNCATE"; Return;};
if (ID == 648){window.location.href="06-4.html#REPLACE"; Return;};
if (ID == 649){window.location.href="06-4.html#LOAD_DATA"; Return;};
if (ID == 6410){window.location.href="06-4.html#DO"; Return;};
if (ID == 650){window.location.href="06-5.html#Data_Definition"; Return;};
if (ID == 651){window.location.href="06-5.html#CREATE_DATABASE"; Return;};
if (ID == 652){window.location.href="06-5.html#DROP_DATABASE"; Return;};
if (ID == 653){window.location.href="06-5.html#CREATE_TABLE"; Return;};
if (ID == 6531){window.location.href="06-5.html#Silent_column_changes"; Return;};
if (ID == 654){window.location.href="06-5.html#ALTER_TABLE"; Return;};
if (ID == 655){window.location.href="06-5.html#RENAME_TABLE"; Return;};
if (ID == 656){window.location.href="06-5.html#DROP_TABLE"; Return;};
if (ID == 657){window.location.href="06-5.html#CREATE_INDEX"; Return;};
if (ID == 658){window.location.href="06-5.html#DROP_INDEX"; Return;};
if (ID == 660){window.location.href="06-6.html"; Return;};
if (ID == 661){window.location.href="06-6.html#USE"; Return;};
if (ID == 662){window.location.href="06-6.html#DESCRIBE"; Return;};
if (ID == 670){window.location.href="06-7.html"; Return;};
if (ID == 671){window.location.href="06-7.html#COMMIT"; Return;};
if (ID == 672){window.location.href="06-7.html#LOCK_TABLES"; Return;};
if (ID == 673){window.location.href="06-7.html#SET_TRANSACTION"; Return;};
if (ID == 680){window.location.href="06-8.html"; Return;};
if (ID == 681){window.location.href="06-8.html#Fulltext_Restrictions"; Return;};
if (ID == 682){window.location.href="06-8.html#Fulltext_Fine-tuning"; Return;};
if (ID == 683){window.location.href="06-8.html#Fulltext_TODO"; Return;};
if (ID == 690){window.location.href="06-9.html"; Return;};
if (ID == 691){window.location.href="06-9.html#Query_Cache_How"; Return;};
if (ID == 692){window.location.href="06-9.html#Query_Cache_Configuration"; Return;};
if (ID == 693){window.location.href="06-9.html#Query_Cache_in_SELECT"; Return;};
if (ID == 694){window.location.href="06-9.html#Query_Cache_Status_and_Maintenance"; Return;};
/*
alert(ID);
*/
}
var t1='\<li class="clsItemHide" onClick="OnItemClick(this);" id=i';
var t2='\><font color="#00FF1C"\>';
var t3='\<li class="clsLI"\>\<a href="javascript:a(';
var t4=')"\><font color="#00FFFF"\>';
var t5=''+'</font>\</a\>\</li\>';
var html= ''
+ '<DIV id="object1" style="Position:Absolute; Left:-308px;Top:0px;Width:0px;Z-Index:20" visibility: visible"\>'
+ '<table width="212" cellspacing="0" cellpadding="0" align="center" onmouseover="move(290,0)" onmouseout="move(-290,0)"\>'
+ '<tr valign=top\>\<td bgcolor=#004747\> \<img src="images/head.gif" width="300" height="26"\>\</td\><td rowspan="2" background="images/line1.gif" height="33"\><img src="images/line1.gif" width="10" height="122"\>\</td\>\</tr\>'
+ '<tr valign="top"\>\<td align="left" bgcolor=#004747\>'
/* 内容开始 */
+ '<font color="#00FF1C"\><ul\>'/*\*/
+ t1+'60'+t2+'6 MySQL 语言参考</font>\</li\>'
+ '\<ul id="i60u" class="clsItemsHide"\>'
+ t3+'601'+t4+' 译者序'+t5
+ t3+'602'+t4+' 目录'+t5
+ t3+'603'+t4+' 列类型与函数索引'+t5
+ '\</ul\>'
+ t1+'61'+t2+'6.1 MySQL 语言结构</font>\</li\>'
+ '\<ul id="i61u" class="clsItemsHide"\>'
+ t3+'610'+t4+'6.1 语言结构'+t5
+ t3+'611'+t4+' 6.1.1 文字 怎么写字符串与数字'+t5
+ t3+'6111'+t4+' 6.1.1.1 字符串'+t5
+ t3+'6112'+t4+' 6.1.1.2 数字'+t5
+ t3+'6113'+t4+' 6.1.1.3 十六进制值'+t5
+ t3+'6114'+t4+' 6.1.1.4 NULL 值'+t5
+ t3+'612'+t4+' 6.1.2 数据库、表、索引、列和别名'+t5
+ t3+'613'+t4+' 6.1.3 名字的大小写敏感性'+t5
+ t3+'614'+t4+' 6.1.4 用户变量'+t5
+ t3+'615'+t4+' 6.1.5 系统变量'+t5
+ t3+'616'+t4+' 6.1.6 注释句法'+t5
+ t3+'617'+t4+' 6.1.7 MySQL 对保留字挑剔吗？'+t5
+ '\</ul\>'
+ t1+'62'+t2+'6.2 列类型</font>\</li\>'
+ '\<ul id="i62u" class="clsItemsHide"\>'
+ t3+'620'+t4+'6.2 列类型'+t5
+ t3+'621'+t4+' 6.2.1 数字类型'+t5
+ t3+'622'+t4+' 6.2.2 Date 和 Time 类型'+t5
+ t3+'6221'+t4+' 6.2.2.1 Y2K 问题和日期类型'+t5
+ t3+'6222'+t4+'   6.2.2.2 DATETIME、DATE 和 TIMESTAMP 类型'+t5
+ t3+'6223'+t4+'   6.2.2.3 TIME 类型'+t5
+ t3+'6224'+t4+' 6.2.2.4 YEAR 类型'+t5
+ t3+'623'+t4+' 6.2.3 字符串类型'+t5
+ t3+'6231'+t4+' 6.2.3.1 CHAR 和 VARCHAR 类型'+t5
+ t3+'6232'+t4+' 6.2.3.2 BLOB 和 TEXT 类型'+t5
+ t3+'6233'+t4+' 6.2.3.3 ENUM 类型'+t5
+ t3+'6234'+t4+' 6.2.3.4 SET 类型'+t5
+ t3+'624'+t4+' 6.2.4 为列选择正确的类型'+t5
+ t3+'625'+t4+' 6.2.5 使用来自其它的数据库引擎的列类型'+t5
+ t3+'626'+t4+' 6.2.6 列类型存储需求'+t5
+ t3+'6261'+t4+' 6.2.6.1 数字类型存储需求'+t5
+ t3+'6262'+t4+' 6.2.6.2 日期和时间类型存储需求'+t5
+ t3+'6263'+t4+' 6.2.6.3 字符串类型存储需求'+t5
+ '\</ul\>'
+ t1+'63'+t2+'6.3 用于 SELECT 和 WHERE 子句的函数</font>\</li\>'
+ '\<ul id="i63u" class="clsItemsHide"\>'
+ t3+'630'+t4+'6.3 用于 SELECT 和 WHERE 子句的函数'+t5
+ t3+'631'+t4+' 6.3.1 无类型的特殊运算符和函数'+t5
+ t3+'6311'+t4+' 6.3.1.1 圆括号'+t5
+ t3+'6312'+t4+' 6.3.1.2 比较运算符'+t5
+ t3+'6313'+t4+' 6.3.1.3 逻辑运算符'+t5
+ t3+'6314'+t4+' 6.3.1.4 控制流函数'+t5
+ t3+'632'+t4+' 6.3.2 字符串函数'+t5
+ t3+'6321'+t4+' 6.3.2.1 字符串比较函数'+t5
+ t3+'6322'+t4+' 6.3.2.2 字母大小写敏感性'+t5
+ t3+'633'+t4+' 6.3.3 数字函数'+t5
+ t3+'6331'+t4+' 6.3.3.1 算术运算'+t5
+ t3+'6332'+t4+' 6.3.3.2 数学函数'+t5
+ t3+'634'+t4+' 6.3.4 日期和时间函数'+t5
+ t3+'635'+t4+' 6.3.5 Cast 函数'+t5
+ t3+'636'+t4+' 6.3.6 其它函数'+t5
+ t3+'6361'+t4+' 6.3.6.1 位函数'+t5
+ t3+'6362'+t4+' 6.3.6.2 辅助功能函数'+t5
+ t3+'637'+t4+' 6.3.7 用于 GROUP BY 子句的函数'+t5
+ '\</ul\>'
+ t1+'64'+t2+'6.4 数据操纵 SELECT, INSERT, UPDATE, DELETE</font>\</li\>'
+ '\<ul id="i64u" class="clsItemsHide"\>'
+ t3+'640'+t4+'6.4 数据操纵 SELECT, INSERT, UPDATE, DELETE'+t5
+ t3+'641'+t4+' 6.4.1 SELECT 句法'+t5
+ t3+'6411'+t4+' 6.4.1.1 JOIN 句法'+t5
+ t3+'6412'+t4+' 6.4.1.2 UNION 句法'+t5
+ t3+'642'+t4+' 6.4.2 HANDLER 句法'+t5
+ t3+'643'+t4+' 6.4.3 INSERT 句法'+t5
+ t3+'6431'+t4+' 6.4.3.1 INSERT ... SELECT 句法'+t5
+ t3+'644'+t4+' 6.4.4 INSERT DELAYED 句法'+t5
+ t3+'645'+t4+' 6.4.5 UPDATE 句法'+t5
+ t3+'646'+t4+' 6.4.6 DELETE 句法'+t5
+ t3+'647'+t4+' 6.4.7 TRUNCATE 句法'+t5
+ t3+'648'+t4+' 6.4.8 REPLACE句法'+t5
+ t3+'649'+t4+' 6.4.9 LOAD DATA INFILE 句法'+t5
+ t3+'6410'+t4+' 6.4.10 DO 句法'+t5
+ '\</ul\>'
+ t1+'65'+t2+'6.5 数据定义 CREATE、DROP、ALTER</font>\</li\>'
+ '\<ul id="i65u" class="clsItemsHide"\>'
+ t3+'650'+t4+'6.5 数据定义 CREATE、DROP、ALTER'+t5
+ t3+'651'+t4+' 6.5.1 CREATE DATABASE 句法'+t5
+ t3+'652'+t4+' 6.5.2 DROP DATABASE 句法'+t5
+ t3+'653'+t4+' 6.5.3 CREATE TABLE 句法'+t5
+ t3+'6531'+t4+' 6.5.3.1 隐式的列定义变化'+t5
+ t3+'654'+t4+' 6.5.4 ALTER TABLE 句法'+t5
+ t3+'655'+t4+' 6.5.5 RENAME TABLE 句法'+t5
+ t3+'656'+t4+' 6.5.6 DROP TABLE 句法'+t5
+ t3+'657'+t4+' 6.5.7 CREATE INDEX 句法'+t5
+ t3+'658'+t4+' 6.5.8 DROP INDEX 句法'+t5
+ '\</ul\>'
+ t1+'66'+t2+'6.6 基本的 MySQL 用户实用命令</font>\</li\>'
+ '\<ul id="i66u" class="clsItemsHide"\>'
+ t3+'660'+t4+'6.6 基本的 MySQL 用户实用命令'+t5
+ t3+'661'+t4+' 6.6.1 USE 句法'+t5
+ t3+'662'+t4+' 6.6.2 DESCRIBE 句法 (获得列的信息)'+t5
+ '\</ul\>'
+ t1+'67'+t2+'6.7 MySQL 事务与锁定命令</font>\</li\>'
+ '\<ul id="i67u" class="clsItemsHide"\>'
+ t3+'670'+t4+'6.7 MySQL 事务与锁定命令'+t5
+ t3+'671'+t4+' 6.7.1 BEGIN/COMMIT/ROLLBACK 句法'+t5
+ t3+'672'+t4+' 6.7.2 LOCK TABLES/UNLOCK TABLES 句法'+t5
+ t3+'673'+t4+' 6.7.3 SET TRANSACTION 句法'+t5
+ '\</ul\>'
+ t1+'68'+t2+'6.8 MySQL 全文搜索</font>\</li\>'
+ '\<ul id="i68u" class="clsItemsHide"\>'
+ t3+'680'+t4+'6.8 MySQL 全文搜索'+t5
+ t3+'681'+t4+' 6.8.1 全文的限制'+t5
+ t3+'682'+t4+' 6.8.2 微调 MySQL 全文搜索'+t5
+ t3+'683'+t4+' 6.8.3 全文搜索 TODO'+t5
+ '\</ul\>'
+ t1+'69'+t2+'6.9 MySQL 查询缓存 </font>\</li\>'
+ '\<ul id="i69u" class="clsItemsHide"\>'
+ t3+'690'+t4+'6.9 MySQL 查询缓存'+t5
+ t3+'691'+t4+' 6.9.1 查询缓存如何运作'+t5
+ t3+'692'+t4+' 6.9.2 查询缓存设置'+t5
+ t3+'693'+t4+' 6.9.3 在 SELECT 中的查询缓存选项'+t5
+ t3+'694'+t4+' 6.9.4 查询缓存的状态和维护'+t5
+ '\</ul\>'
/* 内容结束 */
+'\</td\>\</tr\><tr valign="top"\><td colspan="2" align="right" height="2"\> <img src="images/line11.gif" height="11"\></td\></tr\>'
+'\</table\>\</div\>';
document.write(html);
window.onscroll=makeStatic;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -