Database Management 整理
来源:互联网 发布:鲜活的数据 pdf 下载 编辑:程序博客网 时间:2024/06/03 08:48
参考书:Learning MySQL and Mariadb
Chapter 6.
1. show columns in table_name like ” 显示列信息
Chapter 7.
1. select … from … limit n,m 显示查询结果从第n行开始的m行
2. column_name (not) regexp ‘pattern’ 正则表达式,作用与like相似(regexp是 regular expression 缩写),默认不区分大小写,可添加binary选项区分大小写。
eg. WHERE common_name REGEXP BINARY ‘Hawk’ AND common_name NOT REGEXP ‘Hawk-Owl’
3. order by rand() 随机排序
4. 同时更新多个表,注意 order by 和 limit 只能应用于一个表,采用子查询解决多表
5. INSERT…ON DUPLICATE KEY UPDATE,添加一列用来鉴别是否有重复,如果重复,执行update语句
6. CREATE TEMPORARY TABLE … 临时表只在mysql运行时存在。
阅读全文
0 0
- Database Management 整理
- Database Management Systems (Transaction Management)
- Database management system
- Database Management Systems
- Liquibase --- Database Change Management
- Database Management Systems (Foundations)
- SQLite database management tool
- Database Management Systems (Database Design and Tuning)
- EMS Database Management all software
- Database Management in PERL - DBI
- Database Writer and Buffer Management
- Database Management Systems (Application Development)
- Database Management Systems (Query Evaluation)
- Database Management Systems (Additional Topics)
- Fundamentals of Relational Database Management Systems
- Creating Database Management Systems as Source Systems
- FastDB - Main Memory Relational Database Management System
- Modern Database Management (8th Edition)
- 五周第二次课 2017.11.14 yum更换国内源、yum下载rpm包、源码包安装
- java keytool证书工具使用小结
- 《白话深度学习与Tensorflow》学习笔记(6)生成式对抗网络(GAN)
- Java并发编程:线程封闭和ThreadLocal详解
- ELF 文件格式学习
- Database Management 整理
- 计算圆形和长方形的面积
- springmvc中validator的使用
- 简单按钮调适设置
- OpenCV-006:图片的叠加
- POJ 3026 Borg Maze
- lua去掉字符串中的空格
- python入门弱智题目
- 分布式事务XA