随笔分类 -  MySQL

摘要:SQL databases are commonly used to store data; for example - your application could store user profile information in a database. Yous should never cr 阅读全文
posted @ 2019-11-25 04:19 Zhentiw 阅读(125) 评论(0) 推荐(0) 编辑
摘要:Sometime you might want to dump some tables or database from the mysql database. If you using heroku, you can not find the graphy interface like phpMy... 阅读全文
posted @ 2015-02-28 16:28 Zhentiw 编辑
摘要:IF(expr1,expr2,expr3)Ifexpr1isTRUE(expr1 0andexpr1 NULL) thenIF()returnsexpr2; otherwise it returnsexpr3.IF()returns a numeric or string value, depend... 阅读全文
posted @ 2014-09-03 04:33 Zhentiw 编辑
摘要:Full-text searching is performed usingMATCH() ... AGAINSTsyntax.MATCH()takes a comma-separated list that names the columns to be searched.AGAINSTtakes... 阅读全文
posted @ 2014-09-03 04:27 Zhentiw 编辑
摘要:mysql> INSERT INTO articles (title,body) VALUES -> ('MySQL Tutorial','DBMS stands for DataBase ...'), -> ('How To Use MySQL Well','After you wen... 阅读全文
posted @ 2014-09-03 04:11 Zhentiw 编辑
摘要:对于MySQL的优化主要按照以下几点进行表的设计要合理,最好要符合3NF。添加适当的索引,主要有四种索引:主键索引, 普通索引,唯一索引,空间索引使用分表技术(水平分表,垂直分表)读写分离技术存储过程技术【模块化编程,可以提高速度,但是一移植性不好】对MySQL配置优化,【配置最大并发数my.ini... 阅读全文
posted @ 2013-06-30 01:40 Zhentiw 编辑

点击右上角即可分享
微信分享提示