mysql myisam
2024-10-15 09:21:39
.frm
.myd
.myi
insert delayted
show variables like '%delayed%'
lock
read,
write,
read local
pointer
优先级
low_priovity
height_priovity
导出数据到文件
select * from t1 into outfile '/data.data' fields terminated by ',' enclosed by '"';
load data in file
load data infile '/data.data' into table t2 fields terminated by ',' enclosed by '"';
行格式: dynamic,fixed,compressed
决定于行包含的数据类型.
hexdump -C /data/t.MYD
对于 fix 行格式的表,手工录入的数据需要做如下处理
check table t;
optimize table t;
repair table t;
动态行格式,如果行太长的话还存在行迁移.迁移
SELECT
[ALL | DISTINCT | DISTINCTROW ]
[HIGH_PRIORITY]
[STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
select_expr [, select_expr ...]
[FROM table_references
[PARTITION partition_list]
[WHERE where_condition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
[PROCEDURE procedure_name(argument_list)]
[INTO OUTFILE 'file_name'
[CHARACTER SET charset_name]
export_options
| INTO DUMPFILE 'file_name'
| INTO var_name [, var_name]]
[FOR UPDATE | LOCK IN SHARE MODE]]
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[PARTITION (partition_name,...)]
[CHARACTER SET charset_name]
[{FIELDS | COLUMNS}
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number {LINES | ROWS}]
[(col_name_or_user_var,...)]
[SET col_name = expr,...]
最新文章
- 优化与扩展Mybatis的SqlMapper解析
- Android总结篇系列:Android Intent
- jQuery.extend()方法和jQuery.fn.extend()方法源码分析
- 莫名戳中";肋骨";的文章
- ZOJ3772 - Calculate the Function(线段树+矩阵)
- javascript 通过面向对象编写圆形数字时钟
- StarUML启动报RPC服务器不可用错误
- Sql Server同步之订阅
- 非GUI-Qt程序运行后显示Console(简单好用)
- <;转>;如何利用socket进行HTTP访问
- 使用ADO对象添加、修改、删除数据
- Dockerfile 最佳实践
- ORA-01157,记一次Oracle故障恢复过程
- 【算法与数据结构】Java实现字符串的全排列及组合
- PhpStorm中如何使用Xdebug工具,入门级操作方法
- LocalMaxima_NOI导刊2009提高(1)
- MongoDB集群之分片
- Three.js基础学习【修改版】
- P5002 专心OI - 找祖先
- x11vnc配置--ubuntu14.04
热门文章
- EventDemoandStyleDemoandThemeDemo
- HDU4268 Alice and Bob(贪心+multiset)
- [SQL]SUTFF内置函数的用法 (删除指定长度的字符并在指定的起始点插入另一组字符)
- Cocos2d-js中使用纹理对象创建Sprite对象
- 【学习笔记】【C语言】指向函数的指针
- EasyUI form ajax submit到MVC后,在IE下提示下载内容的解决办法
- berkerly db 中简单的读写操作(有一些C的 还有一些C++的)
- java.lang.ThreadLocal源码分析
- 简单版解决IE兼容性问题
- CMD规范的函数与普通函数间调用