摘要: MariaDB表(CREATE,DROP,RENAME,ALTER)InnoDBis atransaction-safe engine (see Chapter 26, “Managing TransactionProcessing”). It does not support full-te... 阅读全文
posted @ 2016-03-19 21:17 李庆喜 阅读(286) 评论(0) 推荐(0) 编辑
摘要: MariaDB INSERT,UPDATE,DELETEINSERT插入一整行(jlive)[crashcourse]>DESC customers;+--------------+-----------+------+-----+---------+----------------+| Fi... 阅读全文
posted @ 2016-03-19 20:50 李庆喜 阅读(359) 评论(0) 推荐(0) 编辑
摘要: MariaDB Full-Text SearchingCREATE TABLE productnotes( note_id int NOT NULL AUTO_INCREMENT, prod_id char(10) NOT NULL, note_date... 阅读全文
posted @ 2016-03-19 19:52 李庆喜 阅读(297) 评论(0) 推荐(0) 编辑
摘要: MariaDB Combined Queries(jlive)[crashcourse]>SELECT vend_id,prod_id, prod_price FROM products WHERE prod_price SELECT vend_id,prod_id, prod_price F... 阅读全文
posted @ 2016-03-19 19:37 李庆喜 阅读(65) 评论(0) 推荐(0) 编辑
摘要: MariaDB JOIN JOIN两张表(jlive)[crashcourse]>SELECT vend_name,prod_name, prod_price FROM vendors, products WHERE vendors.vend_id = products.vend_idORDE... 阅读全文
posted @ 2016-03-19 15:46 李庆喜 阅读(231) 评论(0) 推荐(0) 编辑
摘要: MariaDB Subqueryprod_id ==>order_num(jlive)[crashcourse]>SELECTorder_num FROMorderitems WHERE prod_id = 'TNT2';+-----------+| order_num |+---------... 阅读全文
posted @ 2016-03-19 15:26 李庆喜 阅读(113) 评论(0) 推荐(0) 编辑
摘要: MariaDB Grouping(jlive)[crashcourse]>SELECT vend_id,COUNT(*) AS num_prods FROM products GROUP BY vend_idWITH ROLLUP;+---------+-----------+| vend_i... 阅读全文
posted @ 2016-03-19 14:14 李庆喜 阅读(228) 评论(0) 推荐(0) 编辑
摘要: MariaDB 求和,最大值,最小值,平均数-----------------------------------------------Functions Description-----------------------------------------------AVG() Retu... 阅读全文
posted @ 2016-03-19 13:54 李庆喜 阅读(291) 评论(0) 推荐(0) 编辑
摘要: MariaDB Text,Time,Numeric ManipulationFunction字符操作函数Commonly Used Text-Manipulation Functions---------------------------------------------------Fun... 阅读全文
posted @ 2016-03-19 13:18 李庆喜 阅读(97) 评论(0) 推荐(0) 编辑
摘要: MariaDB Calculated Fields合并查询列(jlive)[crashcourse]>SELECTConcat(RTrim(vend_name), ' (', RTrim(vend_country), ')')AS vend_title FROM vendors ORDER B... 阅读全文
posted @ 2016-03-19 13:06 李庆喜 阅读(104) 评论(0) 推荐(0) 编辑
摘要: MariaDB 正则匹配规则正则" title="MariaDB 正则">----------------------------------------------------------------Class Description-------------------------... 阅读全文
posted @ 2016-03-19 00:03 李庆喜 阅读(282) 评论(0) 推荐(0) 编辑