随笔分类 - 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
阅读全文
摘要: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...
阅读全文
摘要:IF(expr1,expr2,expr3)Ifexpr1isTRUE(expr1 0andexpr1 NULL) thenIF()returnsexpr2; otherwise it returnsexpr3.IF()returns a numeric or string value, depend...
阅读全文
摘要:Full-text searching is performed usingMATCH() ... AGAINSTsyntax.MATCH()takes a comma-separated list that names the columns to be searched.AGAINSTtakes...
阅读全文
摘要:mysql> INSERT INTO articles (title,body) VALUES -> ('MySQL Tutorial','DBMS stands for DataBase ...'), -> ('How To Use MySQL Well','After you wen...
阅读全文
摘要:对于MySQL的优化主要按照以下几点进行表的设计要合理,最好要符合3NF。添加适当的索引,主要有四种索引:主键索引, 普通索引,唯一索引,空间索引使用分表技术(水平分表,垂直分表)读写分离技术存储过程技术【模块化编程,可以提高速度,但是一移植性不好】对MySQL配置优化,【配置最大并发数my.ini...
阅读全文