欢迎访问 生活随笔！
TAG聚合

生活随笔

当前位置： 首页 >

mysql myisam

发布时间：2025/5/22 31 豆豆
生活随笔 收集整理的这篇文章主要介绍了 mysql myisam 小编觉得挺不错的,现在分享给大家,帮大家做个参考.

.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,...]

 

转载于:https://www.cnblogs.com/mjorcen/p/4059751.html

总结

以上是生活随笔为你收集整理的mysql myisam的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。